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.
Key Responsibilities
- 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