Postgres DBA

Quantum Technologies. LLC; Sunnyvale (CA); On-site; USD 140,000 - 200,000; Full time

Job summary

Quantum Technologies. LLC in Sunnyvale seeks an experienced PostgreSQL Database Administrator to handle day-to-day operations, performance tuning, and robust backup/restore strategies including PITR. You will work with cloud deployments on AWS and GCP, implement high-availability with Repmgr, Pgpool, and pgBackRest, and containerize with Kubernetes.

The role requires strong scripting (Shell/Python), and excellent collaboration across teams to support large-scale production databases.

Qualifications

• Experience administering PostgreSQL with emphasis on backups, PITR, and upgrades.
• Strong knowledge of replication and high-availability configurations.
• Hands-on performance troubleshooting for large, multi-terabyte databases.
• Cloud deployments on AWS and/or GCP, with containerized setups using Kubernetes.
• Scripting in Shell or Python for automation and monitoring.
• Ability to learn new technologies and collaborate across teams.

Responsibilities

• Day-to-day database operations, monitoring, and performance tuning.
• Design, implement, and maintain backup/restore strategies (PITR).
• Plan and execute minor and major PostgreSQL upgrades.
• Manage HA/DR tooling (Repmgr, Pgpool, pgBackRest).
• Support cloud deployments and Kubernetes-based environments.

Skills

PostgreSQL

Backups (PITR)

Version Upgrades

Replication

HA/DR

Performance Tuning

VACUUM/ANALYZE

pgBackRest

Repmgr

Pgpool

Kubernetes

Shell Scripting

Python Scripting

Cloud: AWS/GCP

Automation

Large-scale DBs

Communication

Learning Agility

Tools

Repmgr

Pgpool

pgBackRest

Kubernetes

Job description

Job Description:

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

Good to Have:

Exposure to Kubernetes platforms such as GKE or EKS.

Desirable Skills:

Keyword:

Skills: PostgreSQL

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.