Job Description
Company: Avance Consulting
Location: San Antonio, TX
Workplace Type: On-site
Employment Type: Full-time
About the Role
Avance Consulting is seeking a PostgreSQL DBA for an on-site, permanent opportunity in San Antonio, TX (with an additional location in Irvine, CA). This role is responsible for administering, securing, and maintaining enterprise PostgreSQL databases.
What You’ll Do / Key Responsibilities
- Install, configure, manage, secure, monitor, and tune enterprise PostgreSQL databases.
- Manage database streaming replication, High Availability (HA), and disaster recovery configurations.
- Execute backup and recovery procedures to ensure data integrity and business continuity.
- Perform proactive database performance optimization and system tuning.
- Conduct routine database maintenance routines, including regular autovacuuming, vacuuming, and re-indexing.
- Support database scalability, operational stability, and high availability.
Requirements & Qualifications
- Hands-on operational experience as a PostgreSQL Database Administrator.
- Strong knowledge of PostgreSQL architecture, parameter tuning, and operational maintenance.
- Proven experience with PostgreSQL replication, backup/recovery workflows, and performance optimization.
- Ability to diagnose and resolve database performance bottlenecks and query issues.