Senior Database Administrator

Vimo; Mountain View (CA); Hybrid; USD 150,000 - 170,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401k retirement benefits

Paid time off

Tuition reimbursement

Job summary

Vimo is seeking a Senior PostgreSQL Database Administrator to own the design, deployment, and tuning of our PostgreSQL environments powering a state-focused SaaS platform.

You will ensure high availability, security, and scalable performance across production systems, collaborating with DevOps and engineering teams to support millions of users and complex data workloads.

Remote-friendly role with US-based teams, offering competitive compensation and comprehensive benefits.

Qualifications

• 7+ years of PostgreSQL DBA experience in production environments.
• Bachelor's degree or equivalent practical experience in CS/IT.
• Deep knowledge of MVCC, WAL, vacuum, replication, and connection pooling.

Responsibilities

• Design, deploy, and maintain PostgreSQL clusters in prod, staging, and dev.
• Ensure high availability with replication, failover, and DR procedures.
• Monitor performance, tune queries, and implement indexing strategies.
• Plan upgrades and migrations with minimal downtime.
• Collaborate with dev teams on schema and data modeling.

Skills

PostgreSQL DBA

Performance tuning

Backup and recovery

Security and access control

Cloud AWS RDS/Aurora

Automation scripting (Bash/Python)

IaC (Terraform/Ansible)

On-call incident handling

Data security/compliance

Education

Bachelor's degree in Computer Science or equivalent

Tools

pg_dump

pg_basebackup

pgBackRest

Patroni

PgBouncer

Job description

Job Details

Job Location: Remote - Mountain View, CA

Salary Range: $150,000.00 - $170,000.00 Salary/year

About Vimo:

Vimo is a national leader in state-based health insurance exchanges and safety-net transformations. We partner with state agencies across the country to expand access to affordable health coverage and modernize the delivery of essential human services, including Medicaid, SNAP, TANF, child care, child support, child welfare, and unemployment insurance. Our enterprise-grade SaaS platforms power mission-critical systems that serve millions of people every day. By combining cutting-edge technology with process optimization, we help states deliver vital public benefits efficiently, securely, and at scale.

At Vimo, we create practical, real-world solutions that make a measurable difference in people’s lives. If you’re driven by meaningful, high-impact work at the intersection of technology and public service, Vimo may be the place for you.

We are looking for a Senior PostgreSQL Database Administrator to join our Vimo team.

About The Role:

As a Senior PostgreSQL Database Administrator, you will be responsible for the design, implementation, management, and optimization of our PostgreSQL database environments that power Vimo's mission-critical SaaS platform. You will serve as the subject matter expert for all things PostgreSQL, ensuring high availability, performance, security, and scalability of our database infrastructure. You will work closely with development, DevOps, and infrastructure teams to support production systems that serve millions of users across state government health and human services programs.

What You’ll Do:

• Design, deploy, and maintain PostgreSQL database clusters in 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. Implement best practices of DB maintenance.
• Plan and execute database upgrades, migrations, and major version transitions with minimal downtime.
• Implement and 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 scripting (Bash, Python) and infrastructure-as-code tools (Terraform, Jenkins, GitActions or similar).
• Collaborate with application development teams on schema design, data modeling, and query performance reviews.
• Manage PostgreSQL in cloud environments (AWS RDS, Aurora PostgreSQL, or equivalent).
• Establish and maintain database standards, documentation, and operational runbooks.
• Participate in on-call rotation for production database incidents and lead root cause analysis for database-related outages.
• Evaluate and implement PostgreSQL extensions (e.g. PostGIS, pg_partman, Citus, pgvector, etc.) as needed.
• Capacity planning and storage management to support business growth.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field, 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, vacuum, replication, and connection pooling (PgBouncer, Pgpool-II or similar).
• 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, or equivalent).
• Strong fundamentals of Disaster recovery scenarios and maintaining DR databases across multiple AWS regions.
• Solid Linux/Unix administration skills.
• Scripting proficiency in Bash, Python, or similar languages for automation.
• Experience with cloud-hosted PostgreSQL (AWS RDS/Aurora, GCP Cloud SQL, or Azure Database for PostgreSQL).
• Strong understanding of database security, compliance, and access management.

Bonus Skills:

• Experience supporting databases in regulated industries (healthcare, government, or financial services).
• Familiarity with HIPAA, FedRAMP, or SOC 2 compliance requirements as they pertain to data management.
• Experience with database CI/CD pipelines and schema migration tools (Flyway, Liquibase, or Alembic).
• Knowledge of containerized deployments (Docker, Kubernetes) for PostgreSQL.
• Experience with monitoring and observability tools (Datadog, Prometheus/Grafana, pganalyze, pg_stat_statements).
• Hands‑on experience with infrastructure-as-code tools such as Terraform or Ansible.
• PostgreSQL certification or contributions to the PostgreSQL community.
• Experience with data warehousing, ETL pipelines, or analytical workloads on PostgreSQL.
• Familiarity with other database systems (MySQL, MongoDB, Redis) is a plus.

Benefits:

Our comprehensive benefits package includes:

• Health, dental, life, disability, and vision insurance
• Health care spending or reimbursement accounts (FSA)
• Retirement benefits (401k)
• Paid time off
• Education assistance or tuition reimbursement
• Employee discounts for gym memberships and commuting/travel 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.

Compliance with access control, data classification, and applicable legal and regulatory requirements is required.

Learn more at vimo.com.