Senior Oracle Database Administrator

$112,000 - $179,000/Yr

Peraton - Sterling, VA

Full-time - Senior

Remote - Sterling, VA

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The Senior Oracle Database Administrator (DBA) at Peraton will play a crucial role in supporting the Department of State's Consular Affairs Enterprise Infrastructure Operations Program. This position involves managing and maintaining Oracle databases, ensuring their performance, security, and availability in a global 24x7 environment. The DBA will work closely with cross-functional teams to modernize legacy systems and provide operational support for various database systems, including Oracle and SQL Server.

Responsibilities

• Implement and maintain smooth operation and physical design of databases.
• Conduct performance tuning of indexes and databases.
• Review database design and integration of systems, provide backup recovery and make recommendations regarding enhancements and/or improvements.
• Maintain security and integrity controls.
• Develop stored procedures and/or triggers.
• Audit, modify, and amend data in systems using SQL and PL/SQL commands.
• Manage database and transaction log backups, notifications, and database replication between multiple Oracle RDBMS Servers and remote sites.
• Lead and maintain the integrity, security, and availability of a true global 24x7 OLTP database(s) environment.
• Participate in and facilitate the full life cycle implementation of Oracle 19c RDBMS and 19c Oracle GoldenGate data replication for production environments.
• Leverage experience with upgrading the Oracle RAC database from 19c to 21c/23ai, containerization of the 19c DB to CDB/PDB, and configuring the Oracle GoldenGate replications from 19c to 21c HUB.

Requirements

• U.S. citizenship and an active SECRET government security clearance with the ability to obtain Top Secret government security clearance.
• At least seven years of experience in a role with responsibilities similar to those defined for this position.
• Experience as an Oracle 11g, 19c, 21c, and 23ai database administrator with specific knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security.
• Experience upgrading/migrating Oracle 11g/12c to 19c RDBMS, and/or 19c to 21c.
• Foundational knowledge of/experience with Agile/Scrum processes.
• Ability to organize tasks for self and others, prioritize and balance tasks, and lead complex projects.
• Strong communication skills to communicate systems proposals to team leaders.

Nice-to-haves

• Experience as an Oracle DBA supporting a federal agency's Oracle migration initiatives following Agile Software Development Methodology (Agile or the Scaled Agile Framework (SAFe)).
• Experience with Oracle Cloud Computing (private or public).
• Experience with Oracle Engineered Systems, such as Exadata and Sun Super Cluster.
• Oracle Certified Professional.

Benefits

• Competitive salary range of $112,000 - $179,000 based on experience and other factors.