Oracle Goldengate Administrator

Amida Technology Solutions is a DC-based technology company focused on data interoperability integrity governance and security. We create solutions that collect reconcile transform and standardize data for business intelligence advanced analytics decision support and user transactions. We specialize in taking data from inception to impact.

Our team is composed of creative forward-looking thinkers who are passionate about using cutting-edge technology to improve lives and generate a positive impact on our country. We offer an entrepreneurial high-growth environment that values fresh ideas candid conversations and authentic teamwork.

Amida Technology Solutions is seeking an Oracle Goldengate Administrator. The successful candidate will coordinate and manage the use of Oracle Goldengate software on various platforms. This role will report to the CTO. The ideal candidate will be motivated by the opportunity to support public agencies nonprofit organizations and private companies in transforming their data into actionable insights. Preference will be given to candidates able to work a hybrid schedule in our offices in DC or Richmond VA.

What you will do:

• Install and configure Oracle Goldengate software on various platforms (Unix Linux Windows)
• Set up and configure Goldengate processes (Extract Replicat Pump etc.) for different data replication scenarios
• Administer and maintain Oracle Goldengate environments ensuring they are running efficiently and securely
• Monitor Goldengate processes and resolve any issues that arise including performance tuning and troubleshooting
• Manage and maintain Goldengate configurations including parameter files trail files and checkpoints
• Ensure that data and trail file archival processes are implemented
• Design and implement data replication strategies using Oracle Goldengate including real-time data replication bi-directional replication and data integration
• Ensure data consistency and integrity across source and target databases
• Perform schema changes and data migrations using Goldengate
• Set up monitoring tools and scripts to continuously monitor Goldengate processes and data flows
• Analyze and troubleshoot Goldengate-related issues including lag data conflicts and replication errors
• Work on root cause analysis for Goldengate-related incidents and implement corrective actions
• Set up alerting and notification in the event of issues within the Goldengate environment
• Assist in monitoring OGG Linux / UNIX systems
• Optimize Goldengate performance by tuning parameter settings managing trail files and ensuring efficient resource utilization
• Collaborate with DBAs to ensure the overall performance of the database systems involved in replication
• Recommend tuning parameters to system administrators
• Implement security best practices for Goldengate environments including access controls encryption and auditing
• Ensure compliance with organizational policies and industry regulations regarding data replication and integration
• Ensure Oracle databases comply with the DoD Security Technical Implementation Guide (STIG)
• Create and maintain detailed documentation for Goldengate configurations processes and procedures
• Generate reports on replication status performance metrics and incident resolutions
• Work closely with application developers DBAs and infrastructure teams to design and implement effective data replication solutions
• Provide technical support and expertise to project teams and end-users regarding Goldengate-related issues
• Mentor team members and provide training when required
• Plan and execute upgrades and patching of Oracle Goldengate environments including patching the supporting Oracle databases
• Ensure minimal downtime and disruption during upgrades and maintenance activities
• Other duties as assigned

Required Education:

• Bachelors degree in computer science Engineering or a related field.

Required Experience:

• At least 8 years of experience as a core DBA with Standby and Goldengate
• Hands-on work experience as a core Oracle DBA doing activities such as database upgrade patching tuning etc.
• Experience working across multiple operating systems along with familiarity in additional programming languages
• Experience supporting at least two projects within a large organization with responsibilities that include administering operating maintaining and securing large-scale database environments
• Experience in analyzing existing SQL Server and Azure SQL Database and Oracle Database in Azure/AWS Cloud Environments and workloads

Required Skills:

• Expert with enterprise Oracle database software and application products
• Ability to design new or complementary solutions for transformed environments implement solutions and troubleshoot any residual issues after transformation

Preferred Skills:

• Exposure to supporting Goldengate Replication Setup across different releases of Oracle Database and different releases of Goldengate
• Linux/UNIX systems administration knowledge and skill
• BASH (or other shell) scripting experience

Success at Amida

Communication is the key to success at Amida. Our people are known for their can-do attitude and their ability to work effectively with both internal and client teams. We pride ourselves on having a collegial multidisciplinary team with diverse backgrounds and experience. Our best team members pay intense attention to detail in all aspects of their work have great initiative are opinionated about the best ways of doing things and align quickly to decisions. A sense of humor is an asset at Amida.

Full-time regular employees at Amida enjoy a robust benefits package that includes a generous 401(k) match with immediate vesting 4 weeks of PTO paid parental leave medical insurance dental insurance vision insurance life/AD&D insurance and short-term disability. We also offer tuition/training assistance and team building opportunities to encourage professional growth and collaboration.

All qualified applicants will receive consideration without regard to race color religion sex sexual orientation gender identity national origin disability protected veteran status or any other characteristic protected by law.

Required Experience:

Unclear Seniority