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) will be part of the Department of State's Consular Affairs Enterprise Infrastructure Operations Program, providing IT Operations and Maintenance to modernize legacy systems. This role involves operational management of SQL and Oracle databases, ensuring their performance, security, and availability, while also supporting various database systems and collaborating with cross-functional teams.

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 Oracle GoldenGate replications.
• Manage Oracle Exadata Engineering systems and ZDLRA backup engineering systems.
• Perform database and software life-cycle activities to ensure the highest level of system performance and availability.

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 similar role.
• Experience as an Oracle 11g, 19c, 21c, and 23ai database administrator with knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, and Security.
• Experience upgrading/migrating Oracle 11g/12c to 19c RDBMS, and/or 19c to 21c.
• Foundational knowledge of Agile/Scrum processes.
• 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.
• 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.