Postgres DBA

Robotics Technologies; Sunnyvale (CA); On-site; USD 120,000 - 170,000; Full time

Job summary

Robotics Technologies LLC is seeking a PostgreSQL Database Administrator to oversee large-scale production databases. You will manage day-to-day operations, perform backups, and optimize performance across on-prem and cloud deployments. Strong focus on PITR, upgrades, and high availability.

You will collaborate with cross-functional teams and drive automation using Shell and Python. Office-based role in Sunnyvale, CA with opportunities for advanced DB tooling.

Qualifications

• Expert understanding of PostgreSQL architecture and internals.
• Hands-on PITR backup and recovery experience.
• Proven upgrades experience for PostgreSQL versions.
• Extensive experience with replication and high-availability.
• Experience with maintenance tasks: vacuum, analyze, reindex.
• Cloud deployments on AWS (RDS/EC2) and/or GCP.
• Proficiency with HA/DR tools: Repmgr, Pgpool, pgBackRest.
• Containerization and orchestration with Kubernetes.
• Scripting in Shell and/or Python for automation.
• Experience with multi-terabyte production databases.

Responsibilities

• Maintain day-to-day PostgreSQL operations and monitoring.
• Implement backup/restore strategies including PITR.
• Perform minor and major PostgreSQL upgrades.
• Tune performance, troubleshoot CPU, locks, long queries.
• Configure and manage HA/DR with RepMgr, Pgpool, pgBackRest.
• Manage cloud deployments on AWS and GCP.
• Automate tasks using Shell or Python.

Skills

PostgreSQL arch

PITR recovery

Version upgrades

Replication

HA/DR

Performance tuning

Cloud deployment

Kubernetes

Shell scripting

Python scripting

Multi-terabyte DBs

Automation

Communication

Tools

Kubernetes

pgBackRest

Repmgr

Pgpool

AWS (RDS/EC2)

GCP

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.