Postgres DBA

Ethereum Technologies; Sunnyvale (CA); Presencial; USD 140.000 - 210.000; Jornada completa

Descripción de la vacante

Ethereum Technologies is seeking a PostgreSQL Database Administrator to own and optimize a high-availability, multi-terabyte PostgreSQL infrastructure across cloud environments (AWS/GCP). You will lead backups, PITR, upgrades, replication, and performance tuning while automating tasks with Shell and Python.

Collaboration with cross-functional teams is essential. The role requires strong communication, proven experience with large-scale production databases, and a proactive approach to adopting

Formación

• Requires strong PostgreSQL expertise and architecture knowledge.
• Extensive experience with backup/restore (PITR) and upgrades.
• Demonstrated experience with replication and high availability.
• Hands-on DB operations, monitoring, and performance troubleshooting.
• Proficiency with cloud PostgreSQL deployments (AWS RDS/EC2, GCP).
• Familiarity with HA/DR tools: Repmgr, Pgpool, pgBackRest.
• Kubernetes containerization/orchestration exposure.
• Scripting skills in Shell and Python for automation.
• Experience managing multi-terabyte production databases.
• Strong communication and cross-team collaboration.

Responsabilidades

• Manage day-to-day database operations and monitoring.
• Implement and optimize backup, PITR, and upgrade strategies.
• Maintain HA/DR solutions and perform failover testing.
• Tune performance, analyze locks, long-running queries, and resource usage.
• Collaborate with devs and operations to design scalable PostgreSQL infra.
• Automate repetitive tasks with shell/Python scripts.

Conocimientos

PostgreSQL architecture

PITR backups

DB version upgrades

Replication & HA

Database operations

Performance tuning

Config parameters

Maintenance tasks

Cloud deployments

AWS RDS/EC2

GCP

HA/DR tools

Repmgr

Pgpool

pgBackRest

Kubernetes

Shell scripting

Python scripting

Multi-terabyte DBs

Learning ability

Communication skills

Large-scale infra

Herramientas

Kubernetes

pgBackRest

Repmgr

Pgpool

Descripción del empleo

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

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.

Good to Have:

• Exposure to Kubernetes platforms such as GKE or EKS.

Desirable Skills:

Keyword:

Skills: PostgreSQL

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.