Senior PostgreSQL DBA - Cloud, HA/DR & Automation

Valiant Technologies LLC; Sunnyvale (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

Valiant Technologies LLC in Sunnyvale, CA is seeking an experienced PostgreSQL Database Administrator to design, implement, and optimize high-volume production databases. You will own backup strategies, upgrades, replication, HA/DR tooling (Repmgr, Pgpool, pgBackRest) and cloud deployments on AWS/GCP, with strong scripting and collaboration across teams.

Applicants should have hands-on experience with multi-terabyte databases, Kubernetes, and proactive performance tuning, along with excellent

Qualifications

• Strong understanding of PostgreSQL architecture and internal components.
• Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR).
• Proven experience in performing minor and major PostgreSQL version upgrades.
• Extensive experience with database replication and high-availability solutions.
• Responsible for day-to-day database operations, monitoring, and performance troubleshooting (CPU/load, locks, blocking, long-running queries, etc.).
• Deep knowledge of PostgreSQL configuration parameters, system catalogs, and performance views.
• Experience with routine database maintenance activities (vacuum, analyze, reindex, patching).
• Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS/EC2) and/or Google Cloud Platform (GCP).
• Strong experience with HA/DR tools such as Repmgr, Pgpool, and pgBackRest.
• Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.
• Strong scripting skills in Shell and/or Python for automation and monitoring.
• Proven experience administering multi-terabyte, high-performance production databases.
• Ability to independently learn, adapt, and implement new technologies.
• Excellent communication skills with the ability to collaborate effectively across business and technical teams.
• Experience in designing and supporting large-scale, mission-critical database infrastructure with high transaction volumes.

Responsibilities

• Maintain day-to-day database operations and monitoring.
• Troubleshoot performance issues including CPU, memory, locks, and long-running queries.
• Plan and implement backup, PITR, and recovery strategies.
• Perform PostgreSQL upgrades and version migrations.
• Design and maintain high-availability solutions and replication setups.
• Tune database configurations and perform routine maintenance tasks.
• Collaborate with cloud and dev teams to optimize deployments on AWS or GCP.
• Automate operational tasks using Shell or Python scripts.
• Led design of large-scale, high-transaction databases and tooling.

Skills

PostgreSQL

Backup and PITR

Replication and HA

Performance troubleshooting

SQL tuning

Cloud deployments (AWS/GCP)

Kubernetes

Shell/Python scripting

Multi-terabyte databases

Team communication

Upgrades (major/minor)

Tools

pgBackRest

Repmgr

Pgpool

AWS RDS

AWS EC2

GCP

Job description

Valiant Technologies LLC in Sunnyvale, CA is seeking an experienced PostgreSQL Database Administrator to design, implement, and optimize high-volume production databases. You will own backup strategies, upgrades, replication, HA/DR tooling (Repmgr, Pgpool, pgBackRest) and cloud deployments on AWS/GCP, with strong scripting and collaboration across teams.

Applicants should have hands-on experience with multi-terabyte databases, Kubernetes, and proactive performance tuning, along with excellent