Archived listing. The details below describe a past opening.
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