postgres DBA

TOPSYS IT; Alpharetta (GA); On-site; USD 120,000 - 180,000; Full time

Job summary

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

Responsibilities include managing installations, tuning queries, implementing HA/DR with Patroni or streaming replication, and automating backups with Python or Shell scripting. Experience in financial services or cloud environments is a big plus.

Qualifications

• 5+ years of PostgreSQL DBA experience in enterprise environments.
• Strong Linux, query tuning, and database internals expertise.
• Hands-on experience with replication, clustering, and backup tools.

Responsibilities

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

Skills

PostgreSQL DBA

Linux (RHEL/Windows)

Query tuning

Replication & clustering

Patroni

Backup tools (pgBackRest/Barman)

Scripting (Python/Bash)

Cloud environments (AWS/Azure)

Tools

Patroni

pgBackRest

Barman

Job description

Morgan Stanley is looking for a skilled PostgreSQL DBA to manage, optimize, and secure our enterprise databases in Alpharetta, GA. You will work closely with engineering teams to ensure high availability, performance tuning, and robust disaster recovery.

What You’ll Do

• Manage PostgreSQL installations, upgrades, patching, and migrations.
• Optimize slow queries, index usage, and server parameters for peak performance.
• Set up and maintain High Availability (HA) and Disaster Recovery (DR) using tools like Patroni or streaming replication.
• Automate backups, restores, and routine maintenance using scripting (Python/Shell).
• Troubleshoot production incidents and participate in an on-call rotation.

What You Need

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