PostgreSQL Platform Manager - HA & Cloud DB Ops

Valiant Technologies LLC; Madison (WI); On-site; USD 120,000 - 190,000; Full time

Job summary

Valiant Technologies LLC is seeking a senior PostgreSQL Database Administrator to own and optimize our high-transaction production databases in Madison, WI. The role emphasizes deep expertise in PostgreSQL internals, backups with PITR, version upgrades, replication, HA, and performance tuning across on-prem and cloud deployments (AWS/GCP).

You will design and implement scalable, multi-terabyte database infrastructures, automate maintenance with scripts, collaborate across teams, and contribute

Qualifications

• Deep expertise in PostgreSQL architecture and internals.
• Experience with PITR backups and disaster recovery.
• Proven ability to manage replication and high-availability setups.
• Strong performance troubleshooting and query tuning.
• Hands-on experience with cloud PostgreSQL deployments (AWS/GCP).
• Familiarity with Kubernetes and containerized environments.
• Scripting skills for automation (Shell/Python).
• Experience with maintenance tasks: vacuum, analyze, reindex, patching.

Responsibilities

• Own day-to-day database operations, monitoring, and performance tuning.
• Design and implement high-availability and replication strategies.
• Plan and perform PostgreSQL upgrades (minor/major).
• Automate maintenance tasks and monitoring with scripts.
• Manage multi-terabyte, high-performance production databases.
• Collaborate with teams on architecture and incident response.
• Support cloud deployments (AWS RDS/EC2, GCP).
• Adopt new technologies and optimize infrastructure.

Skills

PostgreSQL architecture & internals

Backup/Recovery (PITR)

Replication & HA

Performance troubleshooting

Cloud deployments (AWS/GCP)

Containerization/Kubernetes

Automation scripting (Shell/Python)

Maintenance (VACUUM/ANALYZE/REINDEX)

Version upgrades (minor/major)

High-volume production DBs

Learning new technologies

Cross-team communication

Tools

PgBackRest

Repmgr

Pgpool

Kubernetes

AWS/RDS/EC2

GCP

Job description

Valiant Technologies LLC is seeking a senior PostgreSQL Database Administrator to own and optimize our high-transaction production databases in Madison, WI. The role emphasizes deep expertise in PostgreSQL internals, backups with PITR, version upgrades, replication, HA, and performance tuning across on-prem and cloud deployments (AWS/GCP).

You will design and implement scalable, multi-terabyte database infrastructures, automate maintenance with scripts, collaborate across teams, and contribute