Project Manager

Robotics Technologies; 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

Job Description:

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

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.