SQL Database Administrator

Agile Global Solutions, Inc; Austin (TX); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Agile Global Solutions, Inc. seeks a Senior PostgreSQL Database Engineer to lead enterprise PostgreSQL architecture, HA/DR, performance tuning, security, and automation. The role requires hands-on PostgreSQL administration in large-scale environments, with onsite hybrid work and a strong focus on reliability.

You will design standardized builds, implement backup and recovery, and oversee patching and upgrades while mentoring internal teams and developing runbooks for operations.

Qualifications

• 8–10+ years of database administration experience.
• 5+ years of production PostgreSQL administration.
• Strong knowledge of PostgreSQL internals.
• Hands-on experience with Patroni or an equivalent HA framework.
• Experience with enterprise backup tools, WAL archiving, PITR.
• Experience with PostgreSQL monitoring tools.
• Strong RHEL/Linux administration skills.
• Experience managing large-scale PostgreSQL environments.

Responsibilities

• Design and implement enterprise PostgreSQL architecture.
• Configure and manage HA solutions (Patroni, etcd/Consul, streaming replication, HAProxy, PgBouncer).
• Implement enterprise backup and recovery (pgBackRest, WAL archiving, PITR).
• Design, test, and maintain disaster recovery solutions, with RPO/RTO controls.
• Monitor and troubleshoot PostgreSQL performance, replication lag, and capacity.
• Optimize SQL queries, indexes, and configurations.
• Automate provisioning and operations (Ansible, Terraform, Git, Python/Shell, CI/CD).
• Develop architecture documents and runbooks; transfer knowledge to teams.

Skills

PostgreSQL expert

HA/DR design

Performance tuning

Automation scripting

CI/CD familiarity

Linux admin

Incident response

Knowledge transfer

Education

Bachelor’s degree in CS/IT/CE

Tools

Patroni

etcd/Consul

pgBackRest

WAL archiving

Prometheus

Grafana

Ansible

Terraform

Git

Kubernetes/OpenShift

Job description

Work Location: Hybrid – Onsite at least 2 days per week

NO C2C--ONLY W2

We are looking for a highly experienced Senior PostgreSQL Database Engineer to lead enterprise PostgreSQL architecture, high availability, disaster recovery, performance optimization, security, automation, and production operations.

The ideal candidate will have deep hands-on PostgreSQL administration experience in enterprise environments, with a strong focus on building resilient, secure, and highly available database platforms.

• Design and implement enterprise PostgreSQL architecture, standardized builds, and operational standards.
• Configure and manage HA solutions using Patroni, etcd/Consul, streaming replication, HAProxy, and PgBouncer.
• Implement enterprise backup and recovery using pgBackRest, WAL archiving, and Point-in-Time Recovery (PITR).
• Design, test, and maintain disaster recovery solutions, including failover/failback procedures and RPO/RTO controls.
• Monitor and troubleshoot PostgreSQL performance, replication lag, locking, vacuum, WAL, storage, and capacity issues.
• Optimize SQL queries, execution plans, indexes, and database configurations.
• Implement database security, access controls, TLS, auditing, and centralized logging.
• Lead PostgreSQL patching, major-version upgrades, migrations, and end-of-life remediation.
• Automate database provisioning and operations using Ansible, Terraform, Git, Python/Shell scripting, and CI/CD.
• Develop architecture documents, operational runbooks, and provide knowledge transfer to internal teams.
• Bachelor’s degree in Computer Science, IT, Computer Engineering, or a related technical field.
• 8–10+ years of database administration experience, preferably with 5+ years of substantial production PostgreSQL administration.
• Strong knowledge of PostgreSQL internals, including WAL, MVCC, VACUUM/autovacuum, XID wraparound, replication, indexing, partitioning, and query optimization.
• Hands‑on experience with Patroni or an equivalent HA framework, DCS quorum, failover/failback, and split‑brain prevention.
• Strong expertise in pgBackRest or equivalent enterprise backup tools, WAL archiving, PITR, and restore validation.
• Experience with PostgreSQL monitoring tools, pg_stat views, pg_stat_statements, Prometheus/Grafana, or equivalent platforms.
• Strong RHEL/Linux administration skills, including networking, storage, systemd, SELinux, and shell scripting.
• Experience with production incident response, root cause analysis, performance tuning, patching, and database upgrades.
• Hands‑on automation experience using Ansible, Git, Terraform, Python, or Shell scripting.
• Experience managing large-scale or multi‑terabyte PostgreSQL environments.
• PostgreSQL on Kubernetes/OpenShift or cloud and hybrid platforms.
• Experience with EDB, Percona, Crunchy Data, or upstream PostgreSQL.
• Enterprise IAM integration and regulated or critical‑infrastructure environments.

Warm Regards