"Alerted.org

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