Project Manager

Robotic Process Automation LLC; Madison (WI); On-site; USD 110,000 - 170,000; Full time

Job summary

Robotic Technologies Automation seeks a senior PostgreSQL DBA to manage high-availability production databases in Madison, WI. You will own backups, PITR, upgrades, replication, and performance tuning.

You will work with cloud deployments on AWS/GCP, Kubernetes, and automation scripts, collaborating with engineering and operations to sustain multi-terabyte systems.

Qualifications

• Strong PostgreSQL architecture knowledge and hands-on experience.
• PITR backups and point-in-time recovery proficiency.
• Experience upgrading PostgreSQL versions (minor/major).
• Extensive replication and high-availability expertise.
• DB ops, monitoring, and performance troubleshooting.
• Deep knowledge of configs, catalogs, and performance views.
• Routine maintenance: vacuum, analyze, reindex, patching.
• Cloud deployments on AWS (RDS/EC2) and/or GCP.
• Familiar with HA/DR tools like Repmgr, Pgpool, pgBackRest.
• Containerization with Kubernetes and automation scripting.
• Managing multi-terabyte production databases.

Responsibilities

• Oversee day-to-day database operations, monitoring, and health.
• Implement backups, PITR, and disaster recovery strategies.
• Perform upgrades and apply patches to maintain security and performance.
• Tune queries, monitor CPU/load, locks, and long-running queries.
• Collaborate with engineers to design scalable DB infrastructure.

Skills

PostgreSQL expertise

Backup and PITR

Upgrades

Replication/HA

Monitoring

Performance tuning

Cloud deployments

HA/DR tooling

Kubernetes

Scripting (Shell/Python)

Multi-terabyte DBs

Learning ability

Communication

Tools

PgBackRest

Repmgr

Pgpool

AWS

GCP

Job description

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.