via Career pages·Today
Oracle Core DBA and Golden Gate
Infosys
Full-timeOn-site
Location:Bangalore, IndiaType:Full-timePosted:Today
We are seeking an experienced Golden Gate, Core DBA consultant.
- GoldenGate (Key Requirement)
- Install, configure, and administer Oracle GoldenGate Classic & Microservices (OGG MA).
- Build and maintain:
o Uni-directional, bi-directional, active-active, and hub-and-spoke topologies.
- Handle:
o Cross-platform replication o Conflict detection & resolution o DDL replication strategies o Integrated Extract/Replicat
- Troubleshoot lag, checkpoints, trail file issues, and network performance.
- Core DBA
- Install, configure, upgrade, patch, and maintain Oracle 12c/19c/21c database environments.
- Perform backup/recovery using RMAN; validate restore scenarios regularly.
- Administer Oracle RAC, ASM, ACFS, and cluster components.
- Manage tablespaces, schema, user security, and resource allocation.
- Implement Data Guard for high availability and disaster recovery.
- Perform Capacity planning, database health checks, and proactive risk mitigation.
- Support migration and platform upgrades (AIX/Linux/OCI).
- Performance Tuning (Expert)
- Perform SQL Tuning using:
o AWR/ASH/ADDM o SQL Monitor & Real-Time SQL Tuning o TKPROF, SQL Trace o Execution plan analysis & plan stability techniques
- Optimize:
o SQL Queries o PL/SQL Logic o Index & partitioning strategies o RAC-aware workload distribution
- Address contention:
o Latches, locks, buffer busy waits, gc waits in RAC
- Implement SQL Baselines, SQL Profiles, SPO to prevent plan regression.
- Deep understanding of optimizer behavior, statistics, histograms, and cardinality estimates.
Don't want to miss the next one?
Subscribe to daily email alerts for roles matching your interests.