Responsibilities :
1. 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. 2. 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). 3. 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. 4. Oracle Exadata
Manage and optimize workloads on Exadata DMA Activities
Patching, Upgrades & Lifecycle Management
Core DBA + RAC/ASM Administration
Performance Tuning (Exadata-Specific)
Exadata System Monitoring & Troubleshooting
Additional Responsibilities:
Ability to develop value-creating strategies and models that enable clients to innovate, drive growth and increase their business profitability
Good knowledge on software configuration management systems
Awareness of latest technologies and Industry trends
Logical thinking and problem solving skills along with an ability to collaborate
Understanding of the financial processes for various types of projects and the various pricing models available
Ability to assess the current processes, identify improvement areas and suggest the technology solutions
One or two industry domain knowledge
Client Interfacing skills
Project and Team management
