Remote PostgreSQL Reliability Engineer — HA & Scale

YO AI Labs; California; À distance; USD 140 000 - 190 000; Plein temps

Résumé du poste

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.

Responsabilités

• 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.

Connaissances

PostgreSQL

AWS RDS & Aurora PostgreSQL

High-Availability Architecture

Large-Scale Databases

Database Performance Optimization

Backup & Disaster Recovery

Replication & Failover

Outils

Terraform

CI/CD

Monitoring tools

Description du poste

Senior Database Reliability Engineer

Role Type: Full-time
Location: Remote

About the Role

We are looking for an experienced Database Reliability Engineer to architect, optimize, and maintain highly available PostgreSQL environments. You'll ensure reliability, performance, and scalability across large-scale, cloud-based database systems.

Key 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.

Required Skills

• PostgreSQL
• AWS RDS & Aurora PostgreSQL
• High-Availability Architecture
• Large-Scale Databases
• Database Performance Optimization
• Backup & Disaster Recovery
• Replication & Failover

Preferred 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.