Database Admin Mid

Description

This role (Mid-Level MySQL and PostgreSQL DBA) is responsible for ensuring the reliability, security, and optimal performance of database systems across open-source environments. The DBA supports application development teams, automates database operations, performs regular maintenance, and troubleshoots complex database issues. This role requires hands-on experience managing production databases, with a strong understanding of both MySQL and PostgreSQL ecosystems.

Job Description and Duties :

Position is required to be full-time onsite at DOT HQ, Washington DC.

Assist in driving, standardizing, and managing a unified Configuration Management database.

Install, configure, and manage Oracle, MySQL, and PostgreSQL databases on Linux, Windows, and AWS platforms.

Set up new databases, servers, and related infrastructure in both cloud and on-premises environments.

Manage replication, clustering, and high availability configurations to ensure reliability and uptime.

Perform database performance tuning, identify root causes of critical issues, and recommend optimization strategies.

Apply Quarterly Patch Set Updates (PSUs) for Oracle and MySQL on AWS EC2 and other supported platforms.

Plan and perform database upgrades, patches, migrations, and refreshes as needed.

Support database modernization and AWS DMS initiatives in collaboration with the development team.

Monitor database metrics and system performance, proactively addressing bottlenecks or failures.

Configure and verify database backups, ensuring successful completion within defined SLAs.

Support monthly SAFER baselines and SMS baseline activities, including instance snapshot creation.

Perform regular maintenance tasks such as index rebuilds, statistics updates, and integrity checks.

Troubleshoot database performance issues, slow-running queries, and deadlocks using native tools.

Manage user accounts, roles, and permissions, maintaining security and access controls across all environments.

Implement and monitor database security, including vulnerability remediation, encryption, and audit logging.

Participate in failover, disaster recovery (DR), and backup validation testing.

Provide on-call production support outside business hours (primarily for SFI-related incidents).

Conduct AWS R&D tasks for new initiatives and automation improvements.

Maintain comprehensive documentation for database environments, configurations, and maintenance activities.

Generate performance reports, growth trend analyses, and usage statistics.

Collaborate closely with application, infrastructure, and security teams to ensure smooth operations and system upgrades.

Qualifications

Required Education and Experience :

Must have a minimum of 6 years of related experience as a database administrator, specializing in supporting Oracle and SQL environment. Education with additional certifications may be considered in lieu of experience.

Certified in Oracle, MySQL, and PostgreSQL database administration.

Strong knowledge of AWS database services, including RDS, EC2-hosted databases, and related cloud concepts.

Expertise in managing Oracle, MySQL, and PostgreSQL databases on Linux and Windows platforms.

Proficiency in database installation, configuration, optimization, tuning, and maintenance.

Experience with database backup, restore, and disaster recovery strategies, including failover testing.

Ability to troubleshoot database performance issues, analyze execution plans, and optimize queries.

Knowledge of database security best practices, including encryption and access control.

Familiarity with monitoring tools and automating database maintenance tasks.

Experience supporting production databases with on-call responsibilities.

Strong collaboration and communication skills to work effectively with application, infrastructure, and operations teams.

Candidate must be a U.S. citizen or green card holder who has resided in the U.S. for at least 3 years and the ability to obtain a public trust.

Preferred Skills and Qualifications :

Install, configure, and manage Oracle, MySQL, and PostgreSQL databases on Linux and Windows platforms.

Deploy and manage databases on AWS (RDS, EC2) and on-premises environments.

Facilitate database migrations, upgrades, backups, and restores.

Administer user access and manage roles / permissions based on project requirements.

Monitor database health, proactively rebuild indexes, and perform routine maintenance tasks.

Troubleshoot performance issues, optimize SQL queries, and analyze execution plans for slow queries.

Configure database security measures, including encryption, user access policies, and compliance standards.

Participate in failover and disaster recovery testing, providing recommendations and solutions.

Support on-call duties to resolve production issues promptly.

Participate in monthly database maintenance, patching, and updates.

Collaborate with teams to ensure smooth deployments, system upgrades, and migrations.

Maintain proper documentation for database operations, maintenance activities, and incident reports.

Target salary range : $80,001 - $120,000. The estimate displayed represents the typical salary range for this position based on experience and other factors.

REQNUMBER : 2511247

SAIC is a premier technology integrator, solving our nation's most complex modernization and systems engineering challenges across the defense, space, federal civilian, and intelligence markets. Our robust portfolio of offerings includes high-end solutions in systems engineering and integration; enterprise IT, including cloud services; cyber; software; advanced analytics and simulation; and training. We are a team of 23,000 strong driven by mission, united purpose, and inspired by opportunity. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $6.5 billion. For more information, visit saic.com. For information on the benefits SAIC offers, see Working at SAIC. EOE AA M / F / Vet / Disability