Job Description

**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

Job Tags

Full time,

Similar Jobs