Database Administrator - PostgreSQL; HIOS

Join us and do work that matters: use your skills to improve how your government serves the public! Pluribus Digital partners with our government customers to design, develop, and deliver useful and impactful digital products. We are a hands‑on digital services consultancy - part technologists, part change agents, and all heart. We employ modern best practices in all that we do as we work to solve problems in public health, financial industry regulation, granting citizenship and asylum, and identity and access management.

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 _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 Cloud Watch, SNS, , 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, Dev Ops engineers, and security staff, and participate in Agile planning, estimation, and on‑call triage.

• 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.

• 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…