Job Type: Contract

Job Category: IT

Job Description

Job Title: PostgreSQL DBA

Location: Austin, TX (3 days/week onsite)
Duration: Long term Contract

Role Overview

We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, optimize, and support high-performance PostgreSQL environments. The ideal candidate will have deep expertise in PostgreSQL internals, high availability, disaster recovery, performance tuning, and cloud-based deployments, with hands-on experience supporting large-scale, mission-critical databases.

Essential Skills & Qualifications

• Strong understanding of PostgreSQL architecture and internal components
• Hands-on experience with backup, restore, and disaster recovery strategies
• Proven experience with PostgreSQL replication and HA solutions
• Deep knowledge of PostgreSQL performance tuning and configuration
• Experience with HADR tools such as Repmgr, Pgpool, and pgBackRest
• Hands-on exposure to cloud-based PostgreSQL on AWS (RDS, EC2) and/or Google Cloud Platform (GCP)
• Solid experience with containerization and orchestration, including Kubernetes
• Strong scripting skills in Shell and/or Python
• Excellent communication skills and ability to work cross-functionally
• Ability to independently learn, adapt, and implement new technologies

Key Responsibilities

• Manage day-to-day PostgreSQL database operations, monitoring, and performance troubleshooting
• Analyze and resolve performance issues related to CPU utilization, locks, blocking sessions, and long-running queries
• Implement and manage logical and physical backup and recovery strategies, including Point-in-Time Recovery (PITR)
• Perform minor and major PostgreSQL version upgrades with minimal downtime
• Design, implement, and maintain replication and high-availability (HA/DR) solutions
• Conduct routine database maintenance activities such as VACUUM, ANALYZE, REINDEX, and patching
• Monitor database health using PostgreSQL system catalogs, views, and configuration parameters
• Support and administer multi-terabyte, high-transaction production databases
• Automate monitoring, maintenance, and operational tasks using Shell and/or Python scripting
• Collaborate with application, infrastructure, and DevOps teams to ensure database reliability and scalability
• Design and support large-scale, mission-critical database infrastructure

Required Skills