Senior Database Administrator
Vimo
- Raleigh, North Carolina, United States
- Raleigh, North Carolina, United States
About
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 GetInsured'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.
Responsibilities
Design, deploy, and maintain PostgreSQL database clusters in production, staging, and development environments.
Ensure high availability and disaster recovery through replication (streaming, logical), fail‑over 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.
Basic Qualifications/Skills
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.
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.
Preferred Qualifications/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.
Compensation and Benefits Competitive compensation - All In range of ($150,000-$200,000). (Please note that compensation will vary based on factors such as skills, relevant experience, performance and location.)
We offer a comprehensive benefits package, including but not limited to:
Health, Dental, Life, Disability, and Vision insurance
Healthcare spending or reimbursement accounts (HSA/FSA)
Retirement benefits (401k)
Paid time off
Holidays: 13 paid days per year
Education assistance or tuition reimbursement
Employee discounts for Gym memberships & commuting/travel assistance
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.