Remote Senior PostgreSQL Reliability Architect

YO AI Labs

Philadelphia (Philadelphia County)

Remote

USD 140,000 - 190,000

Full time

4 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

YO AI Labs is seeking a Senior Database Reliability Engineer to architect, optimize, and maintain highly available PostgreSQL environments in a remote role within the United States. You will ensure reliability, performance, and scalability across cloud-based database systems used to support large-scale applications.

The role emphasizes designing robust architectures, tuning performance, and managing backups, replication, and failover.

Qualifications

PostgreSQL proficiency in production environments with strong tuning skills.
Experience with AWS RDS/Aurora PostgreSQL and cloud-based architectures.
Hands-on design of high-availability database systems.
Experience handling large-scale, high-traffic databases.
Strong skills in query performance, indexing and partitioning.
Backup, disaster recovery, and reliable failover planning.
Experience with replication, failover and recovery workflows.

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.