> Markdown version of [/jobs/ext/3841072-senior-postgresql-dba](https://www.wearedevelopers.com/jobs/ext/3841072-senior-postgresql-dba). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior PostgreSQL DBA - **Company:** SGS Consulting - **Location:** Taylor, TX, United States - **Experience:** Expert - **Contract:** Contract - **Skills:** Cloud Computing, Information Systems, Databases, Computer Engineering, Continuous Integration, Data Recovery, Linux, File Systems, Failover, HAProxy, Monitoring of Systems, Identity and Access Management, Python (Programming Language), PostgreSQL, Logical Volume Manager, OpenShift, Oracle (Applications), Quorum, Red Hat Enterprise Linux, Ansible, Shell Script, Security Information and Event Management, SQL Databases, Data Streaming, Virtualization Technology, Data Logging, Concurrency, Indexer, Firewalls (Computer Science), Git, Selinux, Kubernetes, Infrastructure Automation Frameworks, Information Technology, Data Management, Terraform, Vmware - **Published:** October 20, 2026 - **Apply:** https://www.dice.com/job-detail/7c03170c-299e-4dd5-be8a-105662e718ce ## About the Role * Minimum: Bachelor s degree in Computer Science, Information Technology, Information Systems, Computer Engineering, or a closely related technical field. Experience * 8-10+ years in database administration with preferably 5+ years of substantial production PostgreSQL administration in enterprise environments. PostgreSQL * Strong hands-on expertise with architecture, configuration, WAL, MVCC, VACUUM/autovacuum, XID wraparound, locking, query plans, indexing, partitioning, statistics, extensions, replication, upgrades, migration, and troubleshooting. HA * Hands-on Patroni or equivalent HA framework; etcd/Consul; streaming replication; HAProxy; PgBouncer; quorum, fencing, split-brain prevention, failover and failback. Backup/Recovery * pgBackRest; WAL archiving; PITR; full/differential/incremental backup; encryption; retention; large-database recovery and restore testing. Monitoring * pg_stat* views, pg_stat_statements, exporters/PrometheGrafana or enterprise monitoring, alerting, centralized logging and SIEM integration. Linux * Strong RHEL/Linux skills including systemd, filesystem/LVM, networking, SELinux, firewall, kernel/sysctl, ulimits, storage/I/O diagnostics and shell scripting. Automation * Ansible, Git, Terraform, Python and/or shell, CI/CD, Infrastructure as Code, and automated database builds. Operations * Demonstrated 24x7 production troubleshooting, incident response, RCA, change management, performance analysis, patching and upgrade experience. 3. Preferred Qualifications * Large enterprise or multi-TB PostgreSQL estates. * Mission-critical / 24x7 database services. * VMware or enterprise virtualization and enterprise storage. * OpenShift/Kubernetes PostgreSQL experience. * Oracle-to-PostgreSQL migration experience. * Active Directory / enterprise IAM integration. * Regulated or critical-infrastructure environments. * Experience with EDB, Percona, Crunchy Data, or upstream PostgreSQL. * Cloud PostgreSQL services and hybrid architectures. * PostgreSQL community contributions or relevant certifications., * Design resilient PostgreSQL services across compute, storage, network, HA, backup and DR layers., * Work effectively with DBAs, infrastructure, application, security, management and vendor support teams. ## Description Hands-on senior PostgreSQL contractor responsible for establishing enterprise database architecture, operational standards, HA/DR, backup/recovery, monitoring, performance, security, automation, lifecycle management, and knowledge transfer., * Assess and remediate enterprise PostgreSQL environments across DEV, TEST, PROD, and DR. * Design and implement PostgreSQL reference architectures and standardized database builds. * Engineer and test HA using streaming replication, Patroni or equivalent, DCS quorum, HAProxy/service endpoints, PgBouncer, fencing, and failover/failback. * Implement pgBackRest or equivalent enterprise backup, WAL archiving, PITR, retention, encryption, and automated restore validation. * Design and test DR architectures, promotion/failback procedures, and RPO/RTO controls. * Implement monitoring and alerting for PostgreSQL, replication, WAL, autovacuum/XID, queries, locks, storage, backup, HA/DCS, DR, OS, and capacity. * Diagnose and tune SQL, execution plans, indexes, vacuum/bloat, memory, checkpoints, WAL, I/O, and concurrency. * Establish security/IAM, TLS, pg_hba, role/privilege, secrets, logging, pgAudit, and SIEM integration standards. * Lead minor patching and major-version upgrade planning/execution, including EOL remediation. * Automate builds and operations with Git, Ansible, Terraform, Python/shell, and CI/CD. * Create runbooks, architecture diagrams, standards, operational procedures, and conduct knowledge transfer., * Diagnose failures across PostgreSQL, Linux, virtualization, storage and network boundaries. Performance * Use PostgreSQL statistics and EXPLAIN (ANALYZE, BUFFERS) to identify and remediate bottlenecks. Recovery * Recover to latest state or precise PITR target and produce recovery evidence. Automation * Turn manual build/operations procedures into repeatable version-controlled automation. Documentation * Produce clear architecture, standards, runbooks, diagrams and operational handoff materials.