🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
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 settings. 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 Valuable 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 .