Core DBA Consultant (Golden Gate Performance Tuning)

Job Description: - We are seeking an experienced Golden Gate Core DBA consultant Key Responsibilities: - 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 - 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 Preferred Skills: Technology->Oracle eBS Technical->Oracle Apps DBA Experience: 0.00-0.00 Years