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: - Bachelor's 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.
Never miss an opportunity! Create an alert based on the job you applied for.