Senior PostgreSQL DBA

Job Summary

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.

1. Key Responsibilities

• 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.

2. Required Qualifications:

Education

• 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.

4. Core Technical Competencies

Architecture

• Design resilient PostgreSQL services across compute, storage, network, HA, backup and DR layers.

Troubleshooting

• 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.

Communication

• Work effectively with DBAs, infrastructure, application, security, management and vendor support teams.