Postgres DBA

Austin, TX - USA

Monthly Salary: Not Disclosed

Posted on: 11 hours ago

Vacancies: 1 Vacancy

Job Summary

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 (CPUload 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 (RDSEC2) andor Google Cloud Platform (GCP).
Strong experience with HADR tools such as Repmgr Pgpool and pgBackRest.
Solid hands-on experience with containerization and orchestration technologies including Kubernetes.
Strong scripting skills in Shell andor 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.

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