Previously named to the Inc. 5000 list of America's fastest-growing companies, Truelogic Software specializes in custom web and mobile software development. By leveraging its globa
Senior Database Administrator – Software
Location
Brazil
Posted
3 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Administrator – Software
Truelogic Software
• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.
Job Requirements
- 5+ years of experience in Database Administration, Database Engineering, or a heavily database-focused Data Engineering role.
- PostgreSQL Expertise: Deep hands-on experience managing and tuning PostgreSQL databases, specifically within the AWS ecosystem (RDS or Aurora).
- Snowflake Proficiency: Strong experience working with Snowflake, including data loading, performance tuning, and warehouse cost management.
- Advanced SQL Profiling: Exceptional skills in query profiling, execution plan analysis (EXPLAIN), partition strategies, and index optimization.
- Hands-on ETL/ELT: Proven experience building and maintaining data pipelines using tools like dbt, Airflow, AWS Glue, or custom Python scripting.
- Data Migration & Synchronization: Core experience using AWS Data Migration Service (DMS) to move and continuously synchronize data between relational databases and data warehouses.
- Version Control: Absolute proficiency with Git.
Benefits
- 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.
- Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
- Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.
- Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.
- Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator – DBA
FP Markets (First Prudential Markets)Multi-regulated Broker | 40+ Industry Awards | Established in 2005 | 24/7 Customer Support |
• Administer production databases on AWS RDS — MySQL, PostgreSQL, MS SQL Server • Design and maintain HA / DR architectures: replication, Multi-AZ, read replicas, failover, backups • Tune performance — query optimization, indexing, execution plans, parameter groups • Capacity planning, sizing, and cost optimization across the database fleet • Manage schema changes and migrations safely in production • Monitor database health with Prometheus / Grafana / CloudWatch; tune alerting • Lead incident response for database outages, performance issues, and data integrity events • Implement and enforce security controls — encryption, access management, auditing, secrets rotation • Partner with developers on data modeling, query reviews, and access patterns • Automate routine work — backups, patching, provisioning — using IaC • Document standards, runbooks, and recovery procedures • Participate in on-call rotation
Database Administrator
FP MarketsFP Markets is a global CFD and forex broker founded in 2005 with a mission to deliver superior trading solutions through cutting-edge technology, tight spreads, and fast execution.
Role Description We're looking for a Database Administrator to own the health, performance, and reliability of our database fleet on AWS. You'll work across MySQL, PostgreSQL, and MS SQL Server — running production workloads on RDS — and partner with engineering teams on schema design, query performance, and operational excellence. What You'll Work With: - AWS RDS / Aurora - MySQL - PostgreSQL - MS SQL Server - Terraform - Prometheus - Grafana - Python - ClickHouse Reporting to: Head of Security and Infrastructure Responsibilities - Administer production databases on AWS RDS — MySQL, PostgreSQL, MS SQL Server - Design and maintain HA / DR architectures: replication, Multi-AZ, read replicas, failover, backups - Tune performance — query optimization, indexing, execution plans, parameter groups - Capacity planning, sizing, and cost optimization across the database fleet - Manage schema changes and migrations safely in production - Monitor database health with Prometheus / Grafana / CloudWatch; tune alerting - Lead incident response for database outages, performance issues, and data integrity events - Implement and enforce security controls — encryption, access management, auditing, secrets rotation - Partner with developers on data modeling, query reviews, and access patterns - Automate routine work — backups, patching, provisioning — using IaC - Document standards, runbooks, and recovery procedures - Participate in on-call rotation Qualifications - 4+ years as a DBA or database-focused engineer in production environments - Strong hands-on experience with AWS RDS (and ideally Aurora) - Deep expertise in at least two of: MySQL, PostgreSQL, MS SQL Server - Advanced SQL — query tuning, execution plans, stored procedures, window functions - Solid understanding of replication, backups, point-in-time recovery, and HA / DR patterns - Experience with database security — IAM, encryption (KMS), TLS, auditing - Schema design and migration experience in high-availability environments - Experience with ClickHouse - Scripting in Python, Bash, or PowerShell for automation - Linux fundamentals and networking basics Nice to Have - IaC for databases — Terraform, CloudFormation - Schema migration tooling — Flyway, Liquibase, Alembic - NoSQL exposure — DynamoDB, MongoDB, Redis, ElastiCache - Data warehousing — Redshift, Snowflake, BigQuery - Experience with CDC tooling — Debezium, AWS DMS - Familiarity with observability stacks (Prometheus, Grafana, Percona Toolkit, pgBadger) - Experience in regulated environments (fintech, financial services, SOC 2, ISO 27001, DORA) - Certifications — AWS Database Specialty, Microsoft, Oracle, PostgreSQL Benefits - Welcoming, young and multicultural team with approachable leadership - Ability to contribute to dynamic business at a growth phase - High level of autonomy, support of ideas and putting your expertise into the best practices for the company - Continuous personal development, training budget, growth with the company and opportunity to learn from industry leaders - Competitive remuneration, regular salary reviews and performance-based incentive schemes - Vibrant company life: from team activities to global celebrations - Fully remote work Journey to FP Markets - Interview with People Function member (30 - 45 min) to assess match to our culture - Interview with your future manager (45 min - 1 hour) to assess match to the job and the team and discuss role expectations Join our team and be a part of a professional, rapidly-growing company operating in a multicultural environment!
Database Administrator - Network, Operations
PEAC SolutionsPEAC Solutions, founded in 1997, is the world's largest independent equipment financing provider, managing a global portfolio exceeding $5 billion with over 750
Title: Database Administrator - Network, Operations Location: Mount Laurel Township United States Job Description: We are PEAC Solutions-large enough to finance the globe, yet small enough to stand shoulder-to-shoulder with our customers. We believe in the power of partnership and the promise of possibility. Our purpose is to fuel growth by providing smart, flexible lending solutions that help businesses overcome obstacles and seize new opportunities. Backed by HPS Investment Partners, a leading global investment firm, we offer equipment financing, working capital, and inventory lending solutions that keep businesses moving forward. As the world's largest independent equipment finance company, we are expanding our global footprint-and we are doing it with purpose, grit, and a commitment to those we serve. You are someone who thrives in an environment where ambition meets action. You bring curiosity, resilience, and a strong sense of accountability. You see challenges as opportunities and believe in making an impact for customers, for your team, and for the business. If you are looking to be a part of a company that values partnership over hierarchy and purpose over routine, your next chapter could start here. Detail-oriented Database Administrator / Network Operations professional with 5+ years of experience supporting Microsoft SQL Server environments, vendor-supported financial applications, and enterprise infrastructure operations. Skilled in maintaining database security, integrity, availability, and performance while collaborating with infrastructure teams on network and system operations. Proven ability to monitor and respond to load spikes, validate OS and database-level configurations, and manage network changes affecting connectivity, throughput, and application stability. Experienced in ETL processes, SSRS reporting, PowerShell scripting, Windows Server administration, and troubleshooting across database, system, and network layers. Strong track record of coordinating with stakeholders and third-party vendors to ensure reliable delivery of mission-critical services. TECHNICAL SKILLS Database Platforms: MS SQL Server 2005/2008/2012/2016/2019 Reporting: SSRS (SQL Server Reporting Services) ETL Tools: SSIS, custom T-SQL scripts, PowerShell Database Management: Backup & Recovery, Performance Tuning, Indexing, Data Modeling Security: Role-based access control, encryption, patch management Network/Operations: Change management for network-impacting activities (maintenance windows, firewall/DNS/routing dependencies), connectivity troubleshooting (latency, packet loss, name resolution), baseline and spike monitoring (CPU/memory/disk/network throughput), coordination with network/infra teams to restore service Monitoring & Diagnostics: Performance counters, SQL wait stats, job/agent monitoring, log review and alert triage, root-cause analysis (RCA) support Tools: SQL Server Management Studio (SSMS), Profiler, Power BI (if applicable) Other: Vendor Financial Application Support, Remote User Support, Disaster Recovery Planning Database Administrator - Network/Operations - Administer and maintain MS SQL Server databases ensuring security, integrity, high availability, and recoverability across production and non-production environments. - Manage database feeds, integrations, and connectivity across enterprise systems; troubleshoot end-to-end connection issues spanning application, network, and database layers. - Monitor system health and respond to load spikes by analyzing resource utilization (CPU/memory/disk/network), SQL wait statistics, blocking, and query performance; implement stabilizing actions and document findings. - Perform database patching, upgrades, and performance tuning; optimize indexing strategies and maintenance plans to support SLA and uptime targets. - Implement, test, and validate backup and disaster recovery procedures; participate in DR exercises and ensure runbooks reflect current network and system dependencies. - Provide finance application configuration support to business users and coordinate incident resolution with software vendors and internal infrastructure teams. - Develop and maintain operational and financial reports using SSRS; support ETL processes including data extraction, transformation, and loading for reporting and integrations. ADDITIONAL QUALIFICATIONS - Experience working in collaborative, cross-functional environments (DBA, Network, Systems, and Application Support) - Ability to manage multiple priorities including project work, change windows, and production support - Experience in equipment leasing or financial services industry is a plus - Familiarity with SQL Server Reporting Services (SSRS) - Vendor financial applications support administration experience is a plus Knowledge, Skills and Abilities - Bachelor's degree in computer science or a related field - 5+ years of experience in database administration, information technology, database architecture, or a related field - Experience with Linux and Windows Server environments - Working knowledge of networking fundamentals (TCP/IP, DNS, DHCP, routing/switching concepts) and how they impact database connectivity and application performance - Ability to troubleshoot connectivity and performance issues using monitoring and diagnostics (e.g., Windows Performance Monitor/PerfMon, Wireshark) in partnership with Network/Systems teams - Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB) - Experience with PowerShell scripting and writing business scripts involving DB loads and financial business processes. - Experience with cloud services (Microsoft Azure) a plus CERTIFICATIONS (Optional but Strong for This Role) - Microsoft Certified Database Administrator (MCDBA) - Microsoft Certified Solutions Associate (MCSA - SQL Server) - Microsoft Certified: Azure Database Administrator Associate (DP-300) (Focuses on cloud and hybrid environments) - Microsoft Certified: Azure Data Fundamentals - ITIL Foundation (if applicable) - Microsoft Certified: Azure Data Fundamentals Additional Information: This is a hybrid position, based in our Mt. Laurel, NJ office, three days a week, with two days remote. PEAC Solutions is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, ethnicity, disability, religion, national origin, gender, gender identity, gender expression, marital status, sexual orientation, age, protected veteran status, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. The successful candidate will receive competitive compensation along with our benefit package which includes medical, dental, vision, life insurance, short and long-term disability, 401(k) with match, flexible spending, and paid time off. PEAC provides one paid day off per year to support community involvement. Celebrate you by also having off your birthday on us!
Senior AWS Database Administrator
Rocket MortgageRocket Mortgage® is the home loan experience designed for you. NMLS #3030
• Create and modify database structures, ensuring optimal design for both transactional integrity and analytical reporting • Perform advanced database maintenance tasks, including backups/restores, statistics updates, index optimization, and performance tuning • Proactively monitor and optimize database performance across AWS MySQL, Azure TSQL, and Databricks AnsiSQL environments • Design, implement, and manage Master Data Management (MDM) solutions that ensure data consistency across systems • Collaborate with data engineers to map production data to data warehouse solutions with MDM standards • Develop and maintain comprehensive Entity Relationship Diagrams (ERDs), system flow documents, and technical specifications for leadership and cross-functional teams • Maintain system security and data integrity across all data environments • Partner with systems engineers to optimize hardware and storage subsystems for AWS • Develop, manage, and maintain robust disaster recovery and high availability plans • Collaborate with Infosec and Security teams on data compliance, security, and retention • Participate in data architectural design reviews with both Technology and Data teams • Mentor and coach team members on database best practices


