PostgreSQL DBA | AWS RDS + Public Sector Systems

Pluribus Digital; United States; Remote; USD 110,000 - 127,000; Full time

Benefits offered by this job

401k match

Medical/dental/vision benefits

Bonus eligibility

Job summary

Pluribus Digital is seeking a Database Administrator (DBA) to ensure the availability, performance, security, and recoverability of PostgreSQL and MySQL databases on AWS for the HIOS CMS. You will manage backups, upgrades, monitoring, and security, while collaborating with the data architecture team.

You will contribute to ETL development with Talend and Erwin Data Modeler, participate in Agile planning, and support deployments with Liquibase and CI/CD tooling in a Federal government context.

Qualifications

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

Responsibilities

• Administer PostgreSQL and MySQL databases on AWS RDS across Dev, Test, Impl, and Prod environments.
• Plan and execute minor and major version upgrades and quarterly OS patching in AWS.
• Own backup and recovery: AWS Backup, snapshots, PITR, and restore tests.
• Monitor and tune database performance using pg_stat_statements, Performance Insights, and vacuum/bloat management.
• Manage database access and security including IAM authentication and audit trails.
• Support deployments by reviewing Liquibase changes and executing rollback plans.
• Build and maintain monitoring/automation with CloudWatch, SNS, pg_cron, Ansible, Jenkins.
• Contribute to ETL development and data modeling with Talend and Erwin.
• Write and maintain runbooks and technical documentation.
• Collaborate with developers, testers, DevOps, and security in Agile planning and on-call triage.

Skills

PostgreSQL DBA

MySQL

Amazon RDS

SQL (PL/pgSQL)

On-call rotations

Education

Bachelor’s degree or equivalent experience

Tools

Talend

Erwin Data Modeler

Liquibase

pg_cron

pgaudit

AWS Console

CloudWatch

Job description

Pluribus Digital is seeking a Database Administrator (DBA) to ensure the availability, performance, security, and recoverability of PostgreSQL and MySQL databases on AWS for the HIOS CMS. You will manage backups, upgrades, monitoring, and security, while collaborating with the data architecture team.

You will contribute to ETL development with Talend and Erwin Data Modeler, participate in Agile planning, and support deployments with Liquibase and CI/CD tooling in a Federal government context.