Remote Senior PostgreSQL Reliability Engineer

YO AI Labs; New York (NY); Remote; USD 140,000 - 190,000; Full time

Job summary

YO AI Labs is seeking a Senior Database Reliability Engineer to design, optimize, and maintain PostgreSQL systems across cloud-centric environments. The role emphasizes high availability, performance, and scalability using AWS RDS and Aurora.

You will implement automated maintenance, migrations support, and clear documentation while collaborating with data and dev teams to keep large-scale databases reliable and responsive.

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 PostgreSQL

High-Availability Architecture

Large-Scale Databases

Database Performance Optimization

Backup & Disaster Recovery

Replication & Failover

Tools

Terraform

CI/CD

Cloud-native environments

Job description

YO AI Labs is seeking a Senior Database Reliability Engineer to design, optimize, and maintain PostgreSQL systems across cloud-centric environments. The role emphasizes high availability, performance, and scalability using AWS RDS and Aurora.

You will implement automated maintenance, migrations support, and clear documentation while collaborating with data and dev teams to keep large-scale databases reliable and responsive.