Lead Consultant – Oracle DBA with Goldengate administration

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125000 people across 30 countries are driven by our innate curiosity entrepreneurial agility and desire to create lasting value for clients. Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises including the Fortune Global 500 with our deep business and industry knowledge digital operations services and expertise in data technology and AI.

Inviting applications for the role of Lead Consultant Oracle DBA with Goldengate administration

Responsibilities
This profile requires strong Oracle DBA & Goldengate administration experience with strong AWS cloud knowledge.
Oracle Database Administration:
o Install configure and maintain Oracle databases (12c/19c).
o Perform regular database maintenance activities: backups (RMAN) restores space management DB refresh and performance tuning
o Monitor database performance using OEM AWR ASH and resolve bottlenecks/performance issues proactively.
o Apply patches upgrades and security updates as needed.
o Ensure database security user access and auditing compliance.
o Regularly review & optimize existing indexes
o Design and implement effective indexing strategies to improve query performance and reduce disk I/O.
o Regularly review and optimize existing indexes for better overall system efficiency.
o Plan and execute database upgrades/migration in coordination with the systems and application teams.
o Collaborate with the security team to ensure that database systems comply with security policies and standards.
o Implement and manage access controls and encryption mechanisms as required.
Oracle Goldengate (OGG):
o Set up configure and support Oracle Goldengate for data replication across heterogeneous environments.
o Design and implement Goldengate topologies (unidirectional bidirectional etc.).
o Troubleshoot Goldengate replication lag conflicts and failures.
o Monitor and maintain replication processes including Extract Pump and Replicat.
Cloud & HA/DR Support:
o Working experience with Oracle databases on AWS cloud platform.
o Configure and manage Data Guard RAC or other highavailability solutions.
o Contribute to disaster recovery planning and testing.

Qualifications we seek in you!
Minimum Qualifications / Skills
Graduate in any stream
Excellent communication Interpersonal and organizational skills

Preferred Qualifications/ Skills
Preferred to have the relevant certification in Oracle Database & Goldengate administration.
PowerShell scripting.
Experience and knowledge of SQL Server Reporting Services and TSQL development.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race color religion or belief sex age national origin citizenship status marital status military/veteran status genetic information sexual orientation gender identity physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity customer focus and innovation. Get to know us at and on LinkedIn X YouTube and Facebook.
Furthermore please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit paying to apply or purchasing equipment or training.