Senior PostgreSQL Database Administrator

Job Description

Company: Vimo
Location: Remote – Mountain View, CA
Workplace Type: On-site
Employment Type: Full-time

About the Role

Vimo is a national leader in state-based health insurance exchanges and safety-net transformations, powering mission-critical SaaS platforms for state agencies. We are seeking a Senior PostgreSQL Database Administrator to design, implement, manage, and optimize our PostgreSQL database environments.

What You’ll Do / Key Responsibilities

• Design, deploy, and maintain PostgreSQL database clusters across production, staging, and development environments.
• Ensure high availability and disaster recovery through replication (streaming, logical), failover strategies, and backup/restore procedures.
• Monitor database performance, identify bottlenecks, and implement query optimization, indexing strategies, and configuration tuning.
• Automate routine DBA tasks (backups, monitoring, alerting, provisioning) using Bash, Python, and Terraform.
• Manage PostgreSQL in cloud environments (AWS RDS, Aurora PostgreSQL, or equivalent) and enforce database security best practices.
• Participate in on-call rotation for production database incidents and lead root cause analysis.

Requirements & Qualifications

• 7+ years of hands-on experience as a PostgreSQL DBA in production environments.
• Deep expertise in PostgreSQL internals including MVCC, WAL, vacuum, replication, and connection pooling (PgBouncer).
• Strong experience with performance tuning, query optimization, and EXPLAIN/ANALYZE interpretation.
• Proficiency in backup and recovery tools (pg_dump, pg_basebackup, pgBackRest, Barman).
• Experience with high-availability architectures (Patroni, repmgr) and Disaster recovery across multiple AWS regions.
• Solid Linux/Unix administration skills and scripting proficiency in Bash, Python.
• Experience with cloud-hosted PostgreSQL (AWS RDS/Aurora, GCP Cloud SQL, or Azure Database for PostgreSQL).

Preferred / Bonus Qualifications (if applicable)

• Experience supporting databases in regulated industries (healthcare, government).
• Familiarity with HIPAA, FedRAMP, or SOC 2 compliance requirements.
• Experience with database CI/CD pipelines and schema migration tools (Flyway, Liquibase, or Alembic).
• Knowledge of containerized deployments (Docker, Kubernetes) for PostgreSQL.
• Hands-on experience with infrastructure-as-code tools such as Terraform or Ansible.

Benefits & Perks (if applicable)

• Comprehensive benefits package including Health, dental, life, disability, and vision insurance.
• Health care spending or reimbursement accounts (FSA).
• Retirement benefits (401k).
• Paid time off and Education assistance.

Information Security & Data Protection: This role may involve access to sensitive or regulated information. The candidate is expected to handle all data in accordance with company security, privacy, and data protection policies.