Senior PostgreSQL Reliability Engineer - Remote

YO AI Labs; Austin (TX); Remote; USD 120,000 - 180,000; Full time

Job summary

YO AI Labs is seeking a Senior Database Reliability Engineer to architect, optimize, and maintain PostgreSQL environments in a highly available, cloud-based setup. You will design HA architectures using AWS RDS and Aurora, optimize queries, and ensure reliability at scale.

You will lead backups, replication, failover, and performance tuning, automate maintenance, support data migrations, and document architectures.

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.

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

Job description

YO AI Labs is seeking a Senior Database Reliability Engineer to architect, optimize, and maintain PostgreSQL environments in a highly available, cloud-based setup. You will design HA architectures using AWS RDS and Aurora, optimize queries, and ensure reliability at scale.

You will lead backups, replication, failover, and performance tuning, automate maintenance, support data migrations, and document architectures.