Senior PostgreSQL Reliability Engineer (Remote)

YO AI Labs; Town of Schroeppel (NY); Remote; USD 120,000 - 160,000; Full time

Job summary

YO AI Labs is seeking a Senior Database Reliability Engineer to architect and maintain highly available PostgreSQL environments in cloud-based systems. You will drive reliability and scale for mission-critical databases across AWS.

You will optimize performance, manage backups and failover, and collaborate with teams on migrations, scalability, and automation to ensure smooth operations and rapid delivery.

Qualifications

• 5+ years of production PostgreSQL experience.
• Strong knowledge of PostgreSQL internals, query tuning, indexing, partitioning, and replication.
• Experience managing large-scale, high-traffic databases.
• Familiarity with Terraform, CI/CD, and cloud-native environments.
• Experience with data platforms, ETL, analytics workloads, and monitoring tools.
• Strong analytical, communication, and troubleshooting skills.

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

HA Architecture

Large-scale DBs

Performance optimization

Backup/DR

Replication/Failover

Tools

Terraform

CI/CD

Cloud-native infra

Job description

YO AI Labs is seeking a Senior Database Reliability Engineer to architect and maintain highly available PostgreSQL environments in cloud-based systems. You will drive reliability and scale for mission-critical databases across AWS.

You will optimize performance, manage backups and failover, and collaborate with teams on migrations, scalability, and automation to ensure smooth operations and rapid delivery.