Description

You will manage and optimize Oracle database environments, focusing heavily on performance tuning and replication stability.

Responsibilities

• Tune Oracle database processes to resolve performance bottlenecks across CPU, IO, Memory, and Network.
• Analyze Oracle session wait events to identify and resolve root causes of system issues.
• Generate and interpret AWR, ASH, V$ views, and SQL tracing for real-time monitoring and troubleshooting.
• Optimize SQL code performance through index management, hints, and table reorganizations.
• Manage Oracle GoldenGate configurations, including resyncing replicated tables and troubleshooting synchronization issues.
• Monitor SQL execution history to analyze changes in execution plans, statistics, and data growth.
• Implement table partitioning, statistics collection, and data archiving strategies.

Required Skills

• 7+ years of experience working with Oracle databases.
• Proven experience managing Oracle databases on AWS RDS instances.
• Expertise in Oracle GoldenGate (GG) configuration and troubleshooting.
• Deep understanding of SQL tuning, including execution plans and statistics.
• Proficiency with Oracle tuning tools such as AWR, ASH, and V$ views.
• Strong ability to identify system bottlenecks in CPU, IO, Memory, and Network.
• Experience with table partitioning and archiving partitioned/non-partitioned tables.
• Any Graduate degree.

Key Skills

Education

Any Graduate