PostgreSQL Platform Manager - Cloud, HA & Automation

Machine Learning Technologies, LLC; Madison (WI); On-site; USD 120,000 - 170,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking a seasoned PostgreSQL Database Administrator to design, implement, and maintain multi-terabyte production databases. You will optimize performance, implement backup/restore with PITR, upgrade versions, and ensure high availability using Repmgr, Pgpool, and pgBackRest.

The role requires cloud deployments on AWS/GCP, containerization with Kubernetes, scripting in Shell or Python, and close collaboration with engineering and operations teams to support

Qualifications

• Deep PostgreSQL knowledge, architecture, and internal components.
• Experience with PITR, backup/restore strategies, and upgrades.
• Strong HA/DR implementation using Repmgr, Pgpool, pgBackRest.
• Proven performance tuning, monitoring, and troubleshooting skills.
• Cloud deployments on AWS and/or GCP with managed and self-managed DBs.
• Container orchestration with Kubernetes and automation scripting.
• Ability to learn new technologies and collaborate across teams.
• Experience administering multi-terabyte production databases.

Responsibilities

• Manage day-to-day PostgreSQL operations, monitoring, and tuning.
• Design and implement backup/restore strategies including PITR.
• Perform minor and major PostgreSQL version upgrades.
• Ensure high availability with HA/DR tooling.
• Optimize queries, configurations, and system catalogs for performance.
• Maintain routine maintenance (vacuum, analyze, reindex, patching).
• Support cloud deployments on AWS/GCP (RDS/EC2, etc.).
• Automate tasks with Shell/Python and monitor systems.
• Collaborate with engineering and operations across teams.

Skills

PostgreSQL expertise

Backup and PITR

DB upgrades

High availability

Performance troubleshooting

Automation scripting (Shell/Python)

Containerization (Kubernetes)

Cloud deployments (AWS/GCP)

Team collaboration

Tools

pgBackRest

Repmgr

Pgpool

Kubernetes

AWS

EC2

RDS

GCP

Shell

Python

Job description

Machine Learning Technologies, LLC is seeking a seasoned PostgreSQL Database Administrator to design, implement, and maintain multi-terabyte production databases. You will optimize performance, implement backup/restore with PITR, upgrade versions, and ensure high availability using Repmgr, Pgpool, and pgBackRest.

The role requires cloud deployments on AWS/GCP, containerization with Kubernetes, scripting in Shell or Python, and close collaboration with engineering and operations teams to support