Oracle Goldengate Administrator

Amida Technology Solutions•Washington, DC

1d•Hybrid

About The Position

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.

Requirements

Bachelor's degree in computer science, Engineering, or a related field.
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
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

Nice To Haves

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

Responsibilities

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