[Hiring] Database Administrator @Pluribus Digital

Role Description

The Database Administrator (DBA) is responsible for the availability, performance, security, and recoverability of the PostgreSQL and MySQL databases on AWS that support the CMS Health Insurance Oversight System (HIOS). This role works with increasing independence on daily operations, patching and upgrades, and backup and recovery, with guidance from senior technical staff on major changes. The DBA also contributes to ETL development and data modeling as a secondary responsibility, alongside the data architecture team.

• Administer PostgreSQL and MySQL databases on Amazon RDS across Dev, Test, Impl, and Prod environments, including daily health checks, capacity and storage management, log review, and lock and connection troubleshooting.
• Plan and execute minor and major version upgrades and quarterly operating system patching in AWS, including blue/green deployments, pre-cutover validation, rollback planning, and retirement of the old environment.
• Own backup and recovery: AWS Backup plans, snapshots, point-in-time recovery, and scheduled restore tests with retained evidence.
• Monitor and tune database performance using pg_stat_statements, Performance Insights, query plans, indexes, and vacuum and bloat management; maintain parameter baselines under change control.
• Manage database access and security, including role-based and time-bound access, IAM authentication support, and audit trails (pgaudit) that support compliance evidence.
• Support application deployments by reviewing and running Liquibase changes, monitoring the database during releases, and executing rollback plans when needed.
• Build and maintain monitoring, alarms, and automation using CloudWatch, SNS, pg_cron, Ansible, and Jenkins.
• Contribute to ETL development and data modeling alongside the data architect, using tools such as Talend and Erwin Data Modeler.
• Write and maintain runbooks and technical documentation so that database operations can be shared and covered.
• Collaborate with developers, testers, DevOps engineers, and security staff, and participate in Agile planning, estimation, and on-call triage.

Qualifications

• Must be able to obtain and maintain a Public Trust clearance.
• Bachelor's degree in a related technical field or equivalent experience.
• Three years of experience administering production relational databases.
• Experience as a PostgreSQL DBA, including backup and recovery, replication, performance tuning, vacuum and bloat management, and parameter configuration.
• Hands-on experience with Amazon RDS for PostgreSQL.
• Strong SQL skills, including PL/pgSQL, and working knowledge of MySQL.
• Experience with on call / triage rotations.
• Understanding of change control and production change management practices.
• Strong problem-solving and communication skills.

Requirements

• Experience performing database upgrades in the AWS ecosystem (RDS or Aurora), including blue/green major version upgrades.
• Exposure to ETL development with Talend or a similar tool (for example Informatica, SSIS, or AWS Glue).
• Experience with Erwin Data Modeler or a similar data modeling tool.
• Experience with Amazon Aurora PostgreSQL, including read replicas and migration from RDS.
• Familiarity with Liquibase, pg_cron, pgaudit, and logical replication.
• Familiarity with CloudWatch, SNS, AWS Backup, and IAM database authentication.
• Familiarity with CI/CD pipelines, Ansible, Jenkins, and DevSecOps practices.
• Experience in a Scrum or SAFe Agile environment.
• Experience supporting federal government programs, including NIST 800-53 / FISMA controls.
• Relevant technical certifications (for example, AWS Certified Solutions Architect or a PostgreSQL certification).

Benefits

• Competitive salary based on experience and qualifications, with salary ranges aligned accordingly.
• Salary range for this specific role is from $110,000 to $127,000 depending on experience.
• Opportunity to earn annual bonus.
• Medical/dental/vision benefits.
• PTO.
• Company paid life insurance.
• A generous 401k match program.