Project Manager

Ethereum Technologies; Madison (WI); On-site; USD 120,000 - 180,000; Full time

Job summary

Ethereum Technologies in Madison is seeking a senior PostgreSQL DBA to own and operate large-scale production databases. You will manage replication, HA/DR, PITR, and performance tuning while partnering with infra and development teams to deliver reliable data services.

The role requires deep PostgreSQL configuration expertise, cloud deployments (AWS RDS/EC2, GCP), and containerized environments with Kubernetes.

Qualifications

• Extensive PostgreSQL experience in production environments.
• Proficient with PITR, backups, and recovery strategies.
• Experience with cloud deployments (AWS/GCP) and RDS/EC2.
• Strong in performance tuning and capacity planning.

Responsibilities

• Oversee day-to-day PostgreSQL operations and monitoring.
• Plan and execute upgrades and patching with minimal downtime.
• Design and maintain high-availability database architectures.
• Automate maintenance tasks using Shell/Python scripts.
• Collaborate with engineering teams on performance improvements.

Skills

PostgreSQL architecture

PITR backups

Upgrades

Replication/HA

Performance troubleshooting

PostgreSQL configs

Maintenance tasks

Cloud PostgreSQL

HA/DR tools

Kubernetes

Shell scripting

Python scripting

Large-scale DBs

Learning ability

Cross-team communication

High throughput workloads

Tools

PostgreSQL

AWS RDS/EC2

GCP

pgBackRest

Repmgr

Pgpool

Kubernetes

Shell

Python

Monitoring tools

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Description:

• 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.

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.