Senior Database Administrator

About the role

Vimo is a national leader in state-based health insurance exchanges and safety-net transformations. We partner with state agencies to expand access to affordable health coverage and modernize essential human services. Our SaaS platforms power mission-critical systems serving millions of people daily. We seek a Senior PostgreSQL Database Administrator to join our team.

Responsibilities

• Design, deploy, and maintain PostgreSQL database clusters in production, staging, and development environments.
• Ensure high availability and disaster recovery through replication, failover strategies, and backup/restore procedures.
• Maintain database performance, identify bottlenecks, and implement query optimization, indexing strategies, and configuration tuning.
• Implement best practices of database 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, and audit logging.
• Automate routine DBA tasks using scripting and infrastructure-as-code tools.
• Collaborate with application development teams on schema design, data modeling, and query performance reviews.
• Manage PostgreSQL in cloud environments (AWS RDS, Aurora PostgreSQL).
• Establish and maintain database standards, documentation, and operational runbooks.
• Evaluate and implement PostgreSQL extensions 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.
• Strong experience with performance tuning, query optimization, and EXPLAIN/ANALYZE interpretation.
• Proficiency in backup and recovery tools.
• Experience with high-availability architectures.
• Solid Linux/Unix administration skills.
• Scripting proficiency in Bash, Python, or similar languages for automation.
• Experience with cloud-hosted PostgreSQL.
• Strong understanding of database security, compliance, and access management.

Bonus Skills

• Experience supporting databases in regulated industries.
• Familiarity with HIPAA, FedRAMP, or SOC 2 compliance requirements.
• Experience with database CI/CD pipelines and schema migration tools.
• Knowledge of containerized deployments.
• Experience with monitoring and observability tools.
• Experience with infrastructure-as-code tools.
• PostgreSQL certification or contributions to the PostgreSQL community.
• Experience with data warehousing, ETL pipelines, or analytical workloads.
• Familiarity with other database systems.

Benefits

• Comprehensive benefits package including health, dental, life, disability, and vision insurance.
• Health care spending or reimbursement accounts.
• Retirement benefits (401k).
• Paid time off.
• Education assistance or tuition reimbursement.
• Employee discounts for gym memberships and commuting/travel assistance.
• Information Security & Data Protection.