Oracle DBA, Oracle Golden Gate Professional

Clifyx Technology

3 - 7 years

6 - 10 Lacs

bengaluru

Posted:1 week ago| Platform:

Apply

Skills Required

performance tuning ticketing data migration debugging disaster recovery schema oracle dba downstream testing sql

Work Mode

Work from Office

Job Type

Full Time

Job Description

Administer and optimize Oracle databases (including schemas: AGP, SQD, Matrix, AR Admin, BMP Ticketing, WMS) in Azure cloud environments.
Monitor performance, troubleshoot issues (slow processing, space limitations, etc. ), and implement solutions.
Maintain and tune indexes, triggers, and business logic for optimal query and transaction performance.
Manage data retention and purging policies, ensuring compliance and consistency across schemas.

2. Golden Gate Replication

Install, configure, and maintain Oracle Golden Gate for unidirectional and bidirectional data replication.
Manage replication processes (extract, pump, replicate), address lag issues, and perform upgrades and patching.
Implement supplemental logging and support performance tuning (e. g. , parallelism, splitting processes).
Coordinate with interfacing application teams for minimal service disruption during patching and DR activities.
Monitor replication via scripts, automate alerts, and maintain file retention policies.

3. Data Migration Testing

Perform data migrations using Oracle Data Pump (EXPDP), SQL Loader, and other tools for UAT and production environments.
Ensure CAB approvals and compliance with internal processes for all data transfers.
Support testing, debugging, and validation of schema changes and replication compatibility.

4. Disaster Recovery High Availability

Plan and execute DR exercises, including DR switchovers, ET rollovers, and coordination with downstream teams.
Document high-level DR steps, workflows, and points of contact.
Maintain backup and retention policies for database environments.

More Jobs at Clifyx Technology

EBS Tech Professional

Bengaluru

3 - 5 yrs

INR 5 - 7 Lacs

Business Analyst/process mapping

Bengaluru

1 - 3 yrs

INR 3 - 5 Lacs

Oracle Service Cloud Professional

Bengaluru

8 - 10 yrs

INR 25 - 30 Lacs

SAP GTS Offshore Professional

Bengaluru

8 - 12 yrs

INR 25 - 30 Lacs

SAP EWM Professional

Bengaluru

8 - 12 yrs

INR 25 - 30 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.