PostgreSQL Database Administrator (Postgres DBA)

Galaxy i technologies Inc; Austin (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Galaxy i technologies Inc. is seeking a PostgreSQL Database Administrator contractor in Austin, TX, to own and optimize a multi-terabyte production PostgreSQL environment.

The role focuses on performance tuning, backup/restore, PITR, and high-availability setups across cloud deployments. The ideal candidate brings 6–8 years of experience, hands-on experience with Repmgr/Pgpool/PgBackRest, and strong scripting skills to automate maintenance tasks.

Qualifications

• Strong understanding of PostgreSQL architecture and internal components.
• Hands-on experience with PITR and backup/restore strategies.
• Experience with upgrades and replication/high-availability solutions.
• Experience with cloud deployments (AWS RDS/EC2, GCP).
• Scripting skills in Shell and/or Python for automation.

Responsibilities

• Manage day-to-day PostgreSQL operations and monitoring.
• Perform database maintenance and performance troubleshooting.
• Implement and support HA/DR tooling and disaster recovery strategies.
• Coordinate upgrades and patching across multi-terabyte production databases.
• Collaborate with cross-functional teams to optimize infrastructure.

Skills

PostgreSQL DBA

SQL tuning

Shell scripting

Python scripting

High-availability

Tools

PgBackRest

Repmgr

Pgpool

Kubernetes

AWS/GCP

Job description

Immediate Requirement, 100% Closure position

****CONTRACT POSITION***CONTRACT POSITION****

Job Description:

Job Responsibility:

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 (CPU/load, 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 (RDS/EC2) and/or Google Cloud Platform (GCP).

Strong experience with HA/DR tools such as Repmgr, Pgpool, and pgBackRest.

Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.

Strong scripting skills in Shell and/or 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.

Keyword:

Experience Required: 6-8

** All submissions must have LinkedIn ID of Candidate**