Senior Postgres DBA: Cloud, HA & Automation Expert

Machine Learning Technologies, LLC; Sunnyvale (CA); On-site; USD 150,000 - 210,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking a senior PostgreSQL Database Engineer to architect, deploy, and operate large-scale databases in Sunnyvale. You will manage backup strategies, PITR, upgrades, and high-availability with replication, RDS/EC2, and GCP.

Strong scripting in Shell or Python and solid collaboration with cross-functional teams are required. Ideal candidate will handle multi-terabyte production databases, optimize performance, and drive automation and reliability across

Qualifications

• Extensive production PostgreSQL experience with architecture and internals.
• Experience with full lifecycle backup strategies including PITR.
• Ability to perform minor and major PostgreSQL version upgrades.
• Deep knowledge of replication and high-availability solutions.
• Day-to-day database operations, monitoring, and performance troubleshooting (CPU, locks, long queries).
• Strong knowledge of configuration parameters, system catalogs, and performance views.
• Routine maintenance practices (vacuum, analyze, reindex, patching).
• Experience with cloud deployments on AWS (RDS/EC2) and/or GCP.

Responsibilities

• Operate and monitor PostgreSQL databases in production to ensure high availability and performance.
• Implement and maintain backup/restore strategies, including PITR and disaster recovery planning.
• Perform upgrades (minor and major) to PostgreSQL versions as required.
• Manage replication setups and HA tools to ensure data integrity and uptime.
• Tune configurations, monitor performance, and troubleshoot issues across platforms and environments.
• Collaborate with engineering and operations teams on deployment and capacity planning.

Skills

PostgreSQL

High Availability

PITR

Backups & Recovery

Replication

Kubernetes

Shell scripting

Python scripting

AWS

GCP

RDS/EC2

Performance tuning

Monitoring

Multi-terabyte DBs

Tools

Repmgr

Pgpool

pgBackRest

Kubernetes

AWS

GCP

RDS

EC2

Job description

Machine Learning Technologies, LLC is seeking a senior PostgreSQL Database Engineer to architect, deploy, and operate large-scale databases in Sunnyvale. You will manage backup strategies, PITR, upgrades, and high-availability with replication, RDS/EC2, and GCP.

Strong scripting in Shell or Python and solid collaboration with cross-functional teams are required. Ideal candidate will handle multi-terabyte production databases, optimize performance, and drive automation and reliability across