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: