Remote PostgreSQL Reliability Engineer — HA & Scale

YO AI Labs; California (MO); Remote; USD 140,000 - 190,000; Full time

Job summary

YO AI Labs is seeking a Senior Database Reliability Engineer to architect, optimize, and maintain highly available PostgreSQL environments in cloud-based systems. You will ensure reliability, performance, and scalability for large-scale databases using AWS RDS and Aurora.

You will design HA architectures, optimize queries and indexes, manage backups and failover, automate maintenance, and contribute to migration and operational improvements while maintaining clear documentation.

Qualifications

• Production experience with PostgreSQL.
• Strong knowledge of PostgreSQL internals, query tuning, indexing, and replication.
• Experience managing large-scale, high-traffic databases.

Responsibilities

• Design and manage highly available PostgreSQL architectures using AWS RDS and Aurora.
• Optimize queries, indexes, partitioning, and database performance.
• Manage backup, replication, recovery, and failover processes.
• Troubleshoot slow queries, locks, deadlocks, and database bottlenecks.
• Automate database maintenance and reliability workflows.
• Support data migrations, application scaling, and operational improvements.
• Maintain clear technical documentation.

Skills

PostgreSQL

AWS RDS & Aurora PostgreSQL

High-Availability Architecture

Large-Scale Databases

Database Performance Optimization

Backup & Disaster Recovery

Replication & Failover

Tools

Terraform

CI/CD

Monitoring tools

Job description

YO AI Labs is seeking a Senior Database Reliability Engineer to architect, optimize, and maintain highly available PostgreSQL environments in cloud-based systems. You will ensure reliability, performance, and scalability for large-scale databases using AWS RDS and Aurora.

You will design HA architectures, optimize queries and indexes, manage backups and failover, automate maintenance, and contribute to migration and operational improvements while maintaining clear documentation.