Core DBA Consultant (Golden Gate + Performance Tuning)

Job description

- 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 - 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