Remote | Senior Database Reliability Engineer — $220,000–$260,000/year

24-MAG; United States; Remote; USD 220,000 - 260,000; Full time

Job summary

24-MAG is offering a fully remote, full-time role for an expert PostgreSQL architect and reliability engineer. You will design, operate, and optimize production-grade PostgreSQL environments using AWS RDS and Aurora PostgreSQL, focusing on high availability, disaster recovery, and performance tuning.

You will diagnose slow queries, implement partitioning, manage replication, and automate operational tasks while collaborating with cross-functional teams to scale platforms and ensure reliability

Qualifications

• 5 years of professional experience managing and optimising PostgreSQL databases in production.
• Expert-level knowledge of PostgreSQL internals, query tuning, indexing, partitioning, and replication.
• Strong hands-on experience with AWS RDS and Aurora PostgreSQL.
• Experience designing backup, recovery, failover, and high-availability architectures.
• Ability to troubleshoot execution plans, slow queries, locks, and deadlocks.
• Experience operating large-scale, high-traffic databases.

Responsibilities

• Design and operate highly available PostgreSQL architectures in cloud-native environments.
• Provide production troubleshooting and automate routine maintenance tasks.
• Lead data migrations and scaling initiatives for growing workloads.
• Collaborate with engineering on platform improvements and feature scalability.
• Document architectures, topologies, and operational runbooks.

Skills

PostgreSQL

AWS

Query tuning

Partitioning

Replication

High availability

Disaster recovery

Production troubleshooting

Observability

CI/CD

Tools

AWS RDS

Aurora PostgreSQL

Terraform

CI/CD tools

Job description

We are sharing a specialised full-time opportunity for experienced database and infrastructure engineers with deep expertise in PostgreSQL, AWS RDS, Aurora PostgreSQL, high-availability architecture, performance optimisation, and large-scale production databases.

Selected professionals will play a central role in designing, operating, and improving mission-critical PostgreSQL environments within cloud-native infrastructure. The role combines database architecture, query optimisation, disaster recovery, replication, operational automation, and production troubleshooting across high-traffic systems where reliability and performance are critical.

PostgreSQL Architecture & Reliability

• Design and operate highly available, resilient PostgreSQL database architectures
• Build production environments using AWS RDS and Aurora PostgreSQL
• Develop architectures that support reliability, scalability, and fault tolerance
• Apply strong knowledge of PostgreSQL internals when designing database systems
• Support mission-critical workloads requiring consistent availability and operational stability

Performance Optimisation & Query Tuning

• Analyse query execution plans and identify performance bottlenecks
• Tune indexes, queries, and database configuration for improved efficiency
• Design and implement partitioning strategies for large-scale datasets
• Diagnose slow queries and inefficient access patterns
• Improve database performance across high-traffic production workloads

High Availability, Backup & Disaster Recovery

• Design and maintain robust backup, replication, recovery, and failover processes
• Ensure database environments are prepared for disaster-recovery scenarios
• Implement high-availability strategies appropriate for production-scale systems
• Validate recovery procedures and operational resilience
• Reduce risk associated with data loss, service interruption, and infrastructure failure

Production Troubleshooting & Operational Excellence

• Diagnose locks, deadlocks, slow queries, and complex database bottlenecks
• Troubleshoot issues affecting large-scale or high-volume database systems
• Automate routine maintenance and operational database tasks
• Improve monitoring, observability, and operational practices
• Support production incidents while identifying long-term corrective improvements

Platform Collaboration & Scaling

• Collaborate with engineering teams on new product features and platform requirements
• Support data migrations and application scaling initiatives
• Contribute database expertise to architectural and infrastructure decisions
• Help ensure databases evolve safely as system usage and data volumes increase
• Maintain clear technical documentation and communicate proactively with stakeholders

Ideal Profile

• 5 years of professional experience managing and optimising PostgreSQL databases in production
• Expert-level knowledge of PostgreSQL internals, query tuning, indexing, partitioning, and replication
• Strong hands-on experience with AWS RDS and Aurora PostgreSQL
• Practical experience designing backup, recovery, failover, and high-availability architectures
• Strong ability to troubleshoot execution plans, slow queries, locks, and deadlocks
• Experience operating large-scale, high-traffic databases containing millions of rows or more
• Strong analytical and production-debugging skills
• Excellent written and verbal communication
• Ability to work effectively both independently and within a distributed engineering team
• Experience supporting analytics platforms, ETL workloads, operational databases, or data infrastructure is advantageous
• Familiarity with Terraform or other Infrastructure as Code tools is beneficial
• Experience with CI/CD pipelines and cloud-native infrastructure is advantageous
• Familiarity with modern monitoring and observability tools is strongly valued

Engagement Details

• Full-time engagement
• Fully remote
• Compensation: $220,000--$260,000/year
• Work will involve PostgreSQL architecture, AWS RDS and Aurora, performance optimisation, high availability, disaster recovery, and production database reliability
• Strong hands-on experience operating large-scale PostgreSQL environments is central to this role
• Responsibilities will include production troubleshooting, operational automation, data migrations, and infrastructure scaling
• Familiarity with cloud-native infrastructure, Infrastructure as Code, and modern observability practices is highly relevant
• Technical priorities and platform requirements may evolve as infrastructure and product needs develop
• Work must be completed without using confidential or proprietary information belonging to any employer, client, institution, or other third party

About the Platform

This opportunity is available through 24-MAG LLC. We connect experienced professionals with remote consulting opportunities across technical, evaluation, and project-based workstreams.

By submitting this application, you acknowledge that your information may be processed by 24-MAG LLC for recruitment and opportunity matching in accordance with our Privacy Policy: https://www.24-mag.com/privacy-policy