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
