Senior PostgreSQL DBA: HA/DR, Tuning & Automation

Topsys IT; Alpharetta (GA); On-site; USD 120,000 - 150,000; Full time

Job summary

Topsys IT is seeking a skilled PostgreSQL DBA in Alpharetta, GA to manage and optimize enterprise databases. You will ensure high availability, performance tuning, and robust disaster recovery in collaboration with engineering teams.

Responsibilities include upgrades, migrations, backup automation, on-call incident support, and maintaining replication/clustering with Patroni or streaming replication. Strong Linux experience and Python/Bash scripting are essential.

Qualifications

• 5+ years of PostgreSQL DBA experience in enterprise environments.
• Strong Linux (RHEL/Windows) expertise, query tuning, and database internals.
• Hands-on with replication, clustering (Patroni), and backup tools (pgBackRest/Barman).
• Scripting skills in Python or Bash or similar.
• Experience in financial services or cloud environments (AWS/Azure) is a plus.

Responsibilities

• Manage PostgreSQL installations, upgrades, patching, and migrations.
• Optimize slow queries, index usage, and server parameters for peak performance.
• Set up and maintain HA and DR using Patroni or streaming replication.
• Automate backups, restores, and routine maintenance with scripting.
• Troubleshoot production incidents and participate in an on-call rotation.

Skills

PostgreSQL DBA

Linux administration

Query tuning

Scripting (Python/Bash)

Replication & clustering (Patroni)

Backup tools (pgBackRest/Barman)

On-call / incident response

Tools

Patroni

pgBackRest

Barman

Streaming replication

Job description

Topsys IT is seeking a skilled PostgreSQL DBA in Alpharetta, GA to manage and optimize enterprise databases. You will ensure high availability, performance tuning, and robust disaster recovery in collaboration with engineering teams.

Responsibilities include upgrades, migrations, backup automation, on-call incident support, and maintaining replication/clustering with Patroni or streaming replication. Strong Linux experience and Python/Bash scripting are essential.