ery Urgent Position :: Senior Oracle DBA :: Remote :: Oakland, CA :: Only PST Candidate or NC Candidate :: Visa :: GC ,USC,H4 at Oakland, Oregon, USA |
Email: [email protected] |
From: Vinita Singh, Tek Inspirations [email protected] Reply to: [email protected] Represented will also workable Job Description - Title:: Senior Oracle DBA Location: Oakland, CA (Remote) Must work PST hours - NEED PST CANDIDATES ONLY ! Visa: GC or USC or H4 MOI: Video Type : 9 Month Contract (Can Be Extended) Client: Direct client UCOP (University of California Office of the President Please note : This is a Hybrid position; Candidate needs to be onsite for 2 days a week candidates living in Northern California are preferred. Important: Need project description Write-up Short resume 5 page Strong Communication Please include a summary with the must haves. No summary, no response MUST HAVES: 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. E: [email protected] Keywords: green card California ery Urgent Position :: Senior Oracle DBA :: Remote :: Oakland, CA :: Only PST Candidate or NC Candidate :: Visa :: GC ,USC,H4 [email protected] |
[email protected] View all |
Fri Sep 13 21:52:00 UTC 2024 |