Job Description
Company: Vimo
Location: Mountain View, CA
Workplace Type: Remote
Employment Type: Full-time
About the Role
Vimo is a national leader in state-based health insurance exchanges and safety-net transformations, partnering with state agencies to modernize the delivery of essential human services. We are seeking a Senior PostgreSQL Database Administrator to join our team. In this role, you will be responsible for the design, implementation, management, and optimization of enterprise PostgreSQL database environments powering Vimo’s mission-critical SaaS platform.
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 streaming/logical replication, failover mechanisms, and backup/restore procedures.
- Monitor database performance, identify bottlenecks, and execute query optimization, indexing strategies, and engine configuration tuning.
- Plan and execute database upgrades, migrations, and major version transitions with minimal downtime.
- Enforce database security best practices, including role-based access control, encryption at rest and in transit, and audit logging.
- Automate routine DBA tasks (backups, monitoring, alerting, provisioning) using Bash, Python, and Infrastructure-as-Code tooling (Terraform).
- Collaborate with application development teams on schema design, data modeling, and query performance reviews.
- Manage cloud-hosted PostgreSQL instances on AWS RDS and Aurora PostgreSQL.
- Establish database operational standards, documentation, and runbooks while participating in production on-call rotations.
- Perform capacity planning and storage management to support scaling platform requirements.
Requirements & Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or equivalent practical experience.
- 7+ years of hands-on experience as a PostgreSQL DBA in production environments.
- Deep expertise in PostgreSQL internals including MVCC, WAL, vacuuming, replication, and connection pooling (PgBouncer, Pgpool-II).
- Strong experience with performance tuning, query optimization, and EXPLAIN/ANALYZE interpretation.
- Proficiency with backup and recovery tools including pg_dump, pg_basebackup, pgBackRest, and Barman.
- Experience with high-availability architectures (Patroni, repmgr) and multi-region disaster recovery on AWS.
- Solid Linux/Unix administration skills and automation scripting proficiency in Bash or Python.
- Practical experience with cloud-hosted PostgreSQL (AWS RDS/Aurora).
- Strong understanding of database security, compliance, and access governance.
Preferred / Bonus Qualifications
- Experience supporting databases in regulated industries (healthcare, government, or financial services).
- Familiarity with HIPAA, FedRAMP, or SOC 2 compliance requirements.
- Experience with database CI/CD pipelines and schema migration tools (Flyway, Liquibase, Alembic).
- Knowledge of containerized deployments (Docker, Kubernetes) for PostgreSQL.
- Experience with observability tools (Datadog, Prometheus, Grafana, pganalyze).
- PostgreSQL certification or contributions to the open-source PostgreSQL community.
- Familiarity with other database engines (MySQL, MongoDB, Redis).
Benefits & Perks
- Comprehensive health, dental, life, disability, and vision insurance.
- Health care spending or reimbursement accounts (FSA).
- 401(k) retirement plan.
- Generous paid time off.
- Education assistance and tuition reimbursement.
- Commuting/travel assistance and gym membership discounts.
This role may involve access to sensitive or regulated information. Compliance with security, privacy, and data protection policies is required. Learn more at vimo.com.