IMPORTANT REQUIREMENT: Sr. Oracle DBA || Remote Oakland, CA || Client: UCOP || GC, USC & TN Only…
Role: Sr. Oracle DBA
Location: Oakland, CA (Remote)
Duration: 12+ Month
MOI: skype
Client – UCOP
Visa: GC, USC & TN Only
My Direct client UCOP (University of California Office of the President has a Senior Oracle DBA. I had a candidate that can’t start due to visa issues. They need someone who can start ASAP please.
Please include a summary with the must haves. No summary, no response.
Must Have:
• LinkedIn
• Must have extensive background in tuning processes running on Oracle database
• 7+ 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
We need someone who can start a project asap. This project can be worked remotely, however, candidates living in Northern California are preferred.