Project Manager

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

Benefits offered by this job

Health insurance

Job summary

Quantum Technologies. LLC is seeking a PostgreSQL Database Administrator to manage high-performance, multi-terabyte databases in Madison, WI. You will oversee day-to-day operations, tuning, backups, PITR, and upgrades, with cloud exposure on AWS or GCP and containerized deployments using Kubernetes.

You will partner with engineers and IT teams to ensure reliability, performance, and scalable database infrastructure for mission-critical workloads.

Qualifications

• Proficient PostgreSQL expert with architecture knowledge.
• Experience with PITR, backups, upgrades, and high-availability.
• Strong SQL tuning, monitoring, and performance analysis.
• Hands-on with cloud PostgreSQL on AWS/GCP and containerization.

Responsibilities

• Take ownership of day-to-day PostgreSQL operations and monitoring.
• Troubleshoot performance issues, locks, and long-running queries.
• Implement backup/restore strategies and PITR plans.
• Plan and execute major/minor version upgrades and migrations.
• Collaborate with DevOps on Kubernetes-based deployments.

Skills

PostgreSQL architecture

Backup & PITR

Version upgrades

Replication & HA

Monitoring & performance

Config & system catalogs

Maintenance (vacuum/ analyze/ reindex)

Cloud deployments (AWS RDS/EC2, GCP)

HA/DR tools (Repmgr, Pgpool, pgBackRec

Kubernetes

Shell/Python scripting

Multi-terabyte production DBs

Learning agility

Communication across teams

Large-scale DB infrastructure

Tools

Kubernetes

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.