- Must have extensive background in tuning processes running on Oracle database
- 8+ years working on Oracle databases
- Know how to manage Oracle database on AWS RDS instance
We are looking for a candidate with an extensive background in tuning processes running on Oracle database for a long-term contract.
Experience needed:
- Know how to manage Oracle database on AWS RDS instance
- Be familiar with Oracle session wait events and be able to use the information from the wait event to find the cause of the performance issue.
- Identify system bottlenecks - CPU, IO, Memory, Network or processes.
- Be able to generate and interpret Oracle tuning tools - AWR, ASH, V$ views, SQL tracing and real-time monitoring
- Be able to understand the logic of SQL code and provide recommendations for improving their performance– Indexes, hints, table reorg, index rebuilt, etc.
- Know how to get information on the execution history of SQL queries in the database and analyze the performance of past and current executions – change of execution plan, stale statistics, data growth, etc.
- Be familiar with Table partitioning and stats collection on partitioned tables, archiving old data from partitioned and non-partitioned tables.
- Has experience with Oracle Golden Gate (GG) configuration, how to resync GG replicated tables and troubleshoot replication issues casing sync issues