Clearance: Active Secret
Location: Arlington, VA
Bachelor’s degree, possess a Security+ certification and be available to support the potential of 50% on-site work at time of hire and 100% on site work at the governments discretion
Duties and Responsibilities:
- Developing and documenting technical and conceptual specifications in support of the overall usage of GoldenGate;
- Supporting the ongoing design, development and operations of all IPPS-A environments and associated GoldenGate utilizations;
- Setup, integration and maintenance of multiple GoldenGate installations with various components of the IPPS-A system, (i.e. Kafka, OBIEE);
- Supporting development, testing and CM teams for Functional/Security and Performance Testing, code packaging and code migration to various Test and Production environments;
- Working closely with DBAs. application administrators, development teams, and test teams to define requirements, develop creative solutions to complex problems, ensure data quality, and improve/streamline performance;
- Provide rotational on-call, 24/7 support for production environment, providing SME-level support as needed;
- Working closely with developers, SMEs, and Testers using Agile sessions;
- Working to identify, prioritize, and execute tasks to meet program goals and deliverable objectives;
- Other tasks and activities as assigned or directed by the Infrastructure Manager.
Required Qualifications:
- BA/BS degree and 7+ years of related experience;
- Current Secret Clearance required; SSBI preferred;
- Must have a current DOD 8570.01-M IAT Level II – Security+ (minimum);
- 3+ years hands-on experience using and supporting GoldenGate 12c and higher;
- 3+ years hands-on experience installing, configuring, troubleshooting, and supporting GoldenGate on Oracle RAC in a Unix environment;
- 3+ years hands-on experience configuring GoldenGate to support ongoing replication of large Oracle databases, preferably within a complex architecture;
- 3+ years hands-on experience configuring GoldenGate downstream mining and integrated components for active-active replication;
- 4+ years hands-on Oracle DBA experience in Solaris/Linux;
- 2+ years’ experience with Unix shell scripting, SQL Scripting and PL/SQL experience;
- Solid understanding of Oracle databases, Exadata, and Solaris;
- Experience with High-Availability and Disaster Recovery architecture and configuration;
- Experience supporting reporting and other business processes using high-volume data sources across SDLC environments (Dev, Test, UAT, Prod).
Desired qualifications:
- Hands-on experience performing GoldenGate upgrades, replication, error resolution, and restarts without data loss;
- Experience configuring GoldenGate adapters and connectors (e.g., JMS, Kafka);
- Experience installing, configuring, upgrading, and tuning Oracle 12c/19c on Solaris & Linux;
- Knowledge of GoldenGate High Availability using Oracle DBFS and Data Guard;
- Knowledge of GoldenGate Studio or integrating with Oracle Enterprise Manager;
- Knowledge of GoldenGate Microservices installations and implementations;
- Experience in detecting and resolving errors in GoldenGate active-active replication environments;
- Experience with GoldenGate Big Data or GoldenGate JMS is a big plus;
- Experience with DoD and/or GSA database security requirements;
- Experience with Oracle Enterprise Manager (OEM) 12c and Oracle Recovery Manager (RMAN);
- Proven mastery of troubleshooting techniques and the ability to solve problems quickly;
- Ability to work collaboratively in a team environment with a strong focus on customer service and solution ownership;
- Ability to communicate in a clear and concise manner, demonstrate strong problem-solving skills and is successful when working in Integrated Product Teams;
- Ability to manage time, meet deadlines and coordinate multiple, often competing priorities.