MySQL & PostgreSQL Database Administrator

SAIC•Washington, DC

10d•Onsite

About The Position

Lead enterprise PostgreSQL and MySQL database environments as they migrate to AWS. The role supports mission-critical enterprise applications and is responsible for database security, availability, reliability, scalability, architecture, capacity planning, high availability, disaster recovery, and operational automation across on-premises and AWS environments. The administrator works independently and collaborates with application, infrastructure, cloud, and security teams to improve database reliability and streamline deployments. The role requires effective prioritization and multitasking in a fast-paced, high-urgency environment, including managing concurrent production incidents and working under tight deadlines. This is a full-time, on-site position at DOT Headquarters in Washington, DC. It requires in-person support several days per week and availability for either an early shift starting at 7:00 AM or a late shift ending at 7:00 PM, as needed. The administrator may participate in on-call rotations and must perform maintenance during scheduled maintenance windows. The candidate must have strong hands-on expertise in MySQL Cluster and PostgreSQL administration across hybrid environments, along with experience planning and executing cloud migrations. Candidates must be U.S. citizens or green card holders who have resided in the U.S. for at least three years and be able to obtain a public trust.

Requirements

Strong expertise in MySQL Cluster administration; the posting specifies this is non-negotiable.
Strong PostgreSQL and MySQL administration skills across on-premises and AWS cloud environments.
In-depth hands-on knowledge of PostgreSQL and MySQL installation, configuration, optimization, clustering, replication, backup and recovery, and ongoing maintenance.
Experience managing database environments across VMware, AWS EC2, Amazon RDS, Amazon Aurora, and on-premises infrastructure.
Experience with MySQL Cluster, replication technologies, failover configurations, and high-availability database architectures.
Ability to troubleshoot database performance issues, analyze execution plans, optimize SQL queries, and implement performance-tuning strategies.
Experience implementing database security, including encryption, IAM integration, SSL/TLS, and secure access controls.
Hands-on experience migrating PostgreSQL and MySQL clusters to AWS, including assessments, planning, and technical recommendations.
Experience with backup and recovery tools, monitoring solutions, automation scripting, and disaster recovery planning.
Demonstrated success managing enterprise PostgreSQL and MySQL environments in hybrid on-premises and AWS infrastructures.
Proven ability to plan and execute cloud migration projects with hands-on AWS experience.
Ability to multitask, manage competing priorities and concurrent production incidents, and perform under pressure in a high-urgency environment.
Strong verbal and written communication skills and ability to work with technical and non-technical stakeholders.
Excellent analytical, troubleshooting, and problem-solving skills in high-pressure production environments.
Ability to participate in on-call rotations and perform maintenance during scheduled maintenance windows.
Must be a U.S. citizen or green card holder, have resided in the U.S. for at least three years, and be able to obtain a public trust.

Nice To Haves

AWS certification is preferred.
Experience with Amazon Aurora PostgreSQL and Aurora MySQL is highly preferred.
Strong knowledge of AWS networking, storage, security, and infrastructure services supporting database environments.
Experience automating database administration using shell scripting and Python automation tools.
Familiarity with DevOps, Infrastructure as Code, CI/CD pipelines, and monitoring tools such as CloudWatch and Prometheus.
Experience supporting large-scale, mission-critical enterprise database environments with strict uptime and performance requirements.

Responsibilities

Install, configure, and maintain enterprise PostgreSQL and MySQL platforms and supporting infrastructure across on-premises and AWS environments.
Configure, manage, and optimize Amazon RDS for PostgreSQL, Amazon RDS for MySQL, Amazon Aurora, and MySQL Cluster environments.
Plan and execute PostgreSQL and MySQL migrations from on-premises environments to AWS IaaS and PaaS platforms.
Design, implement, and maintain MySQL clustering, replication, failover, and high-availability solutions.
Contribute to database architecture and capacity planning to ensure scalability, reliability, performance, and security.
Design, implement, and maintain disaster recovery strategies for PostgreSQL and MySQL environments on AWS.
Monitor database performance, integrity, and security; investigate anomalies and production incidents.
Perform routine maintenance, including index optimization, query tuning, statistics updates, backups, and consistency checks.
Plan and perform upgrades, patching, and migrations for standalone, clustered, and cloud-hosted database servers.
Oversee migration projects, including lift-and-shift, modernization, and re-platforming efforts to AWS.
Manage database accounts, roles, and permissions in accordance with least-privilege and compliance requirements.
Audit database activity and maintain logs of configuration and schema changes for compliance and forensic analysis.
Implement encryption, TLS/SSL secure connectivity, and other controls for data at rest and in transit.
Maintain detailed, version-controlled documentation, architecture diagrams, configurations, procedures, and runbooks.
Generate reports on database performance, capacity growth, availability, and usage trends for stakeholders.
Collaborate with development, infrastructure, cloud, and security teams to streamline deployments and resolve incidents.
Mentor junior DBAs and establish operational best practices for AWS database administration, automation, and cloud migrations.
Participate in on-call rotations and perform mandatory maintenance during scheduled maintenance windows.