Senior PostgreSQL DBA & Cloud Platform Engineer

Robotics Technologies LLC; Madison (WI); Presencial; USD 110.000 - 170.000; Jornada completa

Descripción de la vacante

Robotics Technologies LLC in Madison, WI seeks a highly skilled PostgreSQL Database Administrator to own performance, backup, and high-availability across multi-terabyte production databases. You will monitor, tune, and support large-scale deployments on-premises and in the cloud, collaborating with engineering and operations teams.

The role requires deep knowledge of PostgreSQL internals, experience with PITR, and proficiency with container orchestration (Kubernetes) and HA/DR tools such as

Formación

• Strong PostgreSQL architecture and internals knowledge.
• Experience with backup strategies and PITR.
• Proven HA/DR tooling experience (Repmgr, Pgpool, PgBackRest).
• Hands-on with cloud deployments (AWS/GCP) and container orchestration.
• Scripting skills for automation (Shell/Python).
• Experience administering multi-terabyte production databases.
• Excellent cross-team communication.

Responsabilidades

• Strong understanding of PostgreSQL architecture and internal components.
• Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR).
• Proven experience in performing minor and major PostgreSQL version upgrades.
• Extensive experience with database replication and high-availability solutions.
• Responsible for day-to-day database operations, monitoring, and performance troubleshooting (CPU/load, locks, blocking, long-running queries, etc..).
• Deep knowledge of PostgreSQL configuration parameters, system catalogs, and performance views.
• Experience with routine database maintenance activities (vacuum, analyze, reindex, patching).
• Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS/EC2) and/or Google Cloud Platform (GCP).
• Strong experience with HA/DR tools such as Repmgr, Pgpool, and pgBackRest.
• Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.
• Strong scripting skills in Shell and/or Python for automation and monitoring.
• Proven experience administering multi-terabyte, high-performance production databases.
• Ability to independently learn, adapt, and implement new technologies.
• Excellent communication skills with the ability to collaborate effectively across business and technical teams.
• Experience in designing and supporting large-scale, mission-critical database infrastructure with high transaction volumes.

Conocimientos

PostgreSQL expertise

High availability / HA

Performance tuning

Scripting (Shell/Python)

Backup & PITR

Herramientas

PgBackRest

Repmgr

Pgpool

Kubernetes

AWS (RDS/EC2)

GCP

Descripción del empleo

Robotics Technologies LLC in Madison, WI seeks a highly skilled PostgreSQL Database Administrator to own performance, backup, and high-availability across multi-terabyte production databases. You will monitor, tune, and support large-scale deployments on-premises and in the cloud, collaborating with engineering and operations teams.

The role requires deep knowledge of PostgreSQL internals, experience with PITR, and proficiency with container orchestration (Kubernetes) and HA/DR tools such as