Remote Senior PostgreSQL Reliability Architect

YO AI Labs; Texas; Remote; USD 140,000 - 180,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 a remote flexible setting. You will ensure reliability, performance, and scalability across cloud-based database systems.

Key responsibilities include designing architectures with AWS RDS/Aurora, optimizing performance, backups, replication, and disaster recovery, plus automation of maintenance workflows across large-scale datasets.

Qualifications

• Proficiency with PostgreSQL, AWS RDS and Aurora PostgreSQL for highly available deployments.
• Experience designing and operating large-scale, cloud-based databases with HA.
• Strong understanding of backup, recovery, replication, and failover processes.

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.

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

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.