Project Manager

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

Job summary

Valiant Technologies LLC is seeking a senior PostgreSQL Database Administrator to own and optimize our high-transaction production databases in Madison, WI. The role emphasizes deep expertise in PostgreSQL internals, backups with PITR, version upgrades, replication, HA, and performance tuning across on-prem and cloud deployments (AWS/GCP).

You will design and implement scalable, multi-terabyte database infrastructures, automate maintenance with scripts, collaborate across teams, and contribute

Qualifications

• Deep expertise in PostgreSQL architecture and internals.
• Experience with PITR backups and disaster recovery.
• Proven ability to manage replication and high-availability setups.
• Strong performance troubleshooting and query tuning.
• Hands-on experience with cloud PostgreSQL deployments (AWS/GCP).
• Familiarity with Kubernetes and containerized environments.
• Scripting skills for automation (Shell/Python).
• Experience with maintenance tasks: vacuum, analyze, reindex, patching.

Responsibilities

• Own day-to-day database operations, monitoring, and performance tuning.
• Design and implement high-availability and replication strategies.
• Plan and perform PostgreSQL upgrades (minor/major).
• Automate maintenance tasks and monitoring with scripts.
• Manage multi-terabyte, high-performance production databases.
• Collaborate with teams on architecture and incident response.
• Support cloud deployments (AWS RDS/EC2, GCP).
• Adopt new technologies and optimize infrastructure.

Skills

PostgreSQL architecture & internals

Backup/Recovery (PITR)

Replication & HA

Performance troubleshooting

Cloud deployments (AWS/GCP)

Containerization/Kubernetes

Automation scripting (Shell/Python)

Maintenance (VACUUM/ANALYZE/REINDEX)

Version upgrades (minor/major)

High-volume production DBs

Learning new technologies

Cross-team communication

Tools

PgBackRest

Repmgr

Pgpool

Kubernetes

AWS/RDS/EC2

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.