Senior Oracle GoldenGate Database Administrator

$135,000 - $216,000/Yr

Peraton - Washington, DC

Full-time - Senior

Remote - Washington, DC

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

About the position

The Senior Oracle GoldenGate Database Administrator (OGG DBA) at Peraton will be responsible for implementing and optimizing database systems that support the Department of State's Consular Affairs operations. This role involves managing Oracle GoldenGate for bidirectional data replication, conducting performance tuning, ensuring database security and integrity, and overseeing database projects in a 24x7 global environment. The OGG DBA will also be involved in upgrading Oracle databases and implementing new technologies to enhance operational efficiency.

Responsibilities

• Implement and optimize computerized database systems for daily operations.
• Manage Oracle GoldenGate for bidirectional data replication in a 24x7 environment.
• Conduct performance tuning of indexes and databases.
• Review database design and integration of systems.
• Provide backup recovery and make recommendations for enhancements.
• Maintain security and integrity controls of databases.
• Formulate policies, procedures, and standards related to database management.
• Monitor transaction activity and utilization.
• Develop stored procedures and triggers using SQL and PL/SQL.
• Oversee scheduling of database projects and backups.
• Administer Oracle Exadata Engineering Systems and ZDLRA Engineering backup systems.
• Create, automate, and maintain high-level reporting systems using Oracle BI publisher.
• Research and implement new databases and online technology.
• Lead disaster recovery, performance analysis, and troubleshooting of critical incidents.

Requirements

• U.S. citizenship and an active SECRET government security clearance.
• At least seven years of experience in a similar role.
• Experience as an Oracle 12c, 19c, and 21c database administrator.
• Specific knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, and security patching.
• Experience upgrading and migrating Oracle databases from 19c to 21c or 23ai.
• Foundational knowledge of Agile/Scrum processes.
• Strong organizational and project management skills.
• Excellent verbal and written communication skills.

Nice-to-haves

• Experience supporting federal agency's Oracle Data Replication modernization initiatives.
• Experience with Oracle Cloud Computing or Oracle databases in AWS or Azure.
• Experience with Oracle Engineered Systems like Exadata and Sun Super Cluster.
• Oracle Certified Professional (OCP) certification.

Benefits

• Paid Time-Off and Holidays
• Retirement
• Life & Disability Insurance
• Career Development
• Tuition Assistance and Student Loan Financing
• Paid Parental Leave
• Medical, Dental, & Vision Care