Senior PostgreSQL DBA for Mission-Critical Public SaaS

Vimo; Mountain View (CA); Sur place; USD 140 000 - 190 000; Plein temps

Avantages offerts par ce poste

Health insurance

Dental insurance

401(k) retirement plan

Paid time off

Education assistance

Résumé du poste

Vimo is seeking a Senior PostgreSQL Database Administrator to design, implement, and optimize PostgreSQL environments powering state-based health insurance exchange platforms. You will ensure high availability, security, and scalable performance across production systems in partnership with DevOps and development teams.

You will lead upgrades, migrations, backups, and DR planning, while enforcing best practices and automating routine tasks with Bash, Python, and IaC tools.

Qualifications

• 7+ years of hands-on PostgreSQL DBA experience in production.
• Deep knowledge of PostgreSQL internals (MVCC, WAL, vacuum, replication).
• Experience with high-availability architectures (Patroni, repmgr).
• Strong Linux/Unix administration skills.
• Automation scripting in Bash or Python for DB tasks.

Responsabilités

• Design, deploy, and maintain PostgreSQL clusters in production and staging environments.
• Ensure high availability and disaster recovery with replication and backups.
• Monitor performance, optimize queries, indexing, and configuration.
• Plan upgrades and migrations with minimal downtime.
• Implement database security best practices including encryption and access control.
• Collaborate with development teams on schema design and data modeling.
• Manage PostgreSQL in cloud environments (AWS RDS/Aurora, etc.).

Connaissances

PostgreSQL DBA

MVCC

WAL

Replication

PgBouncer / Pgpool-II

Backup & Recovery

High Availability

Linux / Unix

Bash

Python

Terraform

Ansible

Formation

Bachelor’s degree in Computer Science / IT or equivalent

Outils

AWS RDS / Aurora PostgreSQL

GCP Cloud SQL

Azure Database for PostgreSQL

PostgreSQL extensions (PostGIS, pg_partman, Citus, pgvector)

Description du poste

Vimo is seeking a Senior PostgreSQL Database Administrator to design, implement, and optimize PostgreSQL environments powering state-based health insurance exchange platforms. You will ensure high availability, security, and scalable performance across production systems in partnership with DevOps and development teams.

You will lead upgrades, migrations, backups, and DR planning, while enforcing best practices and automating routine tasks with Bash, Python, and IaC tools.