Remote Senior PostgreSQL Reliability Engineer

YO AI Labs; Boston (MA); 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 design scalable architectures and ensure reliability, performance, and disaster recovery across our data platforms.

You will manage AWS RDS and Aurora deployments, tune queries and indexes, implement backup and failover procedures, and automate maintenance workflows.

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.

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

AWS

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 design scalable architectures and ensure reliability, performance, and disaster recovery across our data platforms.

You will manage AWS RDS and Aurora deployments, tune queries and indexes, implement backup and failover procedures, and automate maintenance workflows.