Senior PostgreSQL DBA - HA, Cloud & Automation

Robotics Technologies LLC; 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

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.