PostgreSQL DBA-1

Job Type: Contract Job Category: IT 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 SRE ENGINEER (SITE RELIABILITY/RESILIENCY)