Peraton is seeking a Senior Oracle GoldenGate Database Administrator (“OGG DBA”) to join our team of qualified and diverse individuals. The Senior OGG DBA will be a member of the Department of State (DOS) Consular Affairs Enterprise Infrastructure Operations (CAEIO) Program for the Bureau of Consular Affairs (CA). The CAEIO Program provides IT Operations and Maintenance to modernize the legacy networks, applications, and databases supporting CA services globally.

Overview

The OGG DBA implements and optimizes the computerized database systems that support the client's ability to function daily. The OGG DBA also implements Oracle GoldenGate for Bidirectional Data replication to integrate on-prem Oracle databases in a 24x7 global operation; conducts performance tuning of indexes and databases in general; reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls; formulates policies, procedures, and standards related to database management, and monitors transaction activity and utilization. The OGG DBA may develop stored procedures and/or triggers, develop and enforce database administration, user standards and procedures, audit, modify, and amend data in systems using SQL and PL/SQL commands.

The OGG DBA will oversee scheduling database projects, database and transaction log backups, notifications, and database replication between multiple Oracle RDBMS Servers and remote sites, as well as administer the critical Oracle Exadata Engineering Systems, and ZDLRA Engineering backup systems. The OGG DBA will also review technical designs, reports, documentation, and other materials produced by staff, as well as create, automate, and maintain high-level reporting systems using products such as Oracle BI publisher with OMS and WebLogic; research and implement new databases and online technology.

CAEIO-Specific Responsibilities

• Leads and maintains the integrity, security, and availability of a true global 24x7 OLTP database(s) environment. Duties include disaster recovery, performance analysis and tuning, index maintenance, monitoring database health, and troubleshooting critical incidents.
• Performs upgrade from Oracle GoldenGate 19c to 21c Hub architecture and eventually to the Oracle GoldenGate 23ai with AI Vectors.
• Participates in and facilitates the full life cycle implementation of Oracle 19c RDBMS with CDB/PDB and 21c Oracle GoldenGate data replication for production environments.
• Leverages experience in:
• Managing Oracle GoldenGate 19c/21c/23ai in a multi-platform and multi-databases like Oracle, MS SQL, and Postgres data replication environment. Tasks include, but are not limited to, design, architect, engineer, and administer Oracle GoldenGate, including installation, configuration, integration, upgrades, patching, migration, capacity planning, performance tuning, and automate Conflict Detection and Resolution (CDR).
• Managing Oracle Exadata Engineering systems from X6-8 to X9M-8, Exadata Cloud Service on OCI, and ZDLRA RA23 backup engineering systems.
• Implementing Oracle GoldenGate for Big data in Azure or AWS to integrate an on-prem Oracle database with OGG Microservice.
• Upgrading the Oracle RAC database from 19c to 21c or 23ai, containerization of the 19c DB to CDB/PDB, configuring the Oracle GoldenGate replications from 19c to 21c Hub or 23ai, and deploying OEM 13.5 agents.
• Applies database administration skills to Oracle GoldenGate, Oracle Real Application Cluster and Data Guard installation, configuration, and troubleshooting production issues.
• Performs database and software life-cycle activities to ensure the highest level of system performance, availability and compliance with business requirements.
• Applies advanced methods, theories, and research techniques in the investigation and resolution of complex system requirements and issues.

Core Schedule Options: Wednesday – Sunday, 8:00 AM – 4:00 PM or 11:00 PM – 7:00 AM (all times ET)

Location: This position is hybrid with remote work and up to 1 day per week in the office in Sterling, VA or Washington, DC.

This position is hybrid after the individual completes a 1-week New Hire Training Program, during which the OGG DBA will work Monday through Friday from 7:30 AM to 4:00 PM in Sterling, VA. After completing the training program, the OGG DBA will work their assigned schedule, includng up to one day per week in Sterling or DC. The number of days the OGG DBA works onsite is subject to change based on government/program requirements (for example, surge support might require the individual to be in the office more than two days per week).

Required Qualifications

• U.S. citizenship and an active SECRET government security clearance with the ability to obtain Top Secret government security clearance.
• At least seven (7) years of experience in a role with the same or similar responsibilities as those defined for this position.
• Experience as an Oracle 12c, 19c, and 21c database administrator with specific knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, and remediating security vulnerabilities.
• Experience upgrading and migrating Oracle 19c to 21c or 23ai RDBMS.
• 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 verbal and written communication skills to communicate systems proposals to team leaders.

Desired Qualifications

• Experience as an Oracle OGG DBA supporting a federal agency’s Oracle Data Replication modernization initiatives following Agile Software Development Methodology (Agile or the Scaled Agile Framework (SAFe)).
• Experience with Oracle Cloud Computing (private or public), or Oracle database in AWS or Azure Cloud.
• Experience with Oracle Engineered Systems, such as Exadata and Sun Super Cluster.
• Oracle Certified Professional (OCP) certification.

Education and Experience Requirements: Minimum 16 years with HS diploma; Minimum 14 years with AS; Minimum of 12 years with BS/BA; Minimum of 10 years with MS/MA; Minimum of 7 years with Ph.D.