Job Description :
Job Title:Oracle Core DBA
Location: Dallas, TX
No. of Positions: 2
Duration: 6 Months + Ext Possible
Client: Infosys

Years of experience: 8+ years

Mandatory Skills: Oracle Core DBA - Strong Performance Tuning

Job Description:
- Following Performance tuning skills are required.
- Extensive experience with tuning applications developed using SQL, PLSQL, Java and SOA Fusion.
- Expertise in ASH, AWR. In depth understanding of 10046 trace and 10053 traces.
- Well versed in SQL Profiles, Oracle Baselines, v tables, xtables, etc.
- Good knowledge on Solaris and Linux operating systems and very good with truss, pmap, pfiles, netstat, vmstat, iostat, etc.
- Proficient with performance tuning in Oracle database 11g with RAC and Dataguard.
- Good understanding of tuning Data warehousing using STAR schemas.
- Oracle Apps Proficient with performance tuning and application support for Oracle eBusiness suite R12.
- Indepth knowledge of Oracle Applications technology stack, including architecture.
- Fusion Apps Proficient with performance tuning and application support for Fusion Applications.
- Indepth knowledge of Fusion Applications technology stack, including architecture.
- Good understanding of Oracle internals Blocks, latches, memory structures, locking mechanism, optimizer cost calculations, optimizer rules, stats collections methodologies, etc.
- Ability to research and understand the internals of new products.

Mandatory Skills:

Following Performance tuning skills are required Extensive experience with tuning applications developed using SQL, PLSQL, Java and SOAFusion. Expertise in ASH, AWR. In depth understanding of 10046 trace and 10053 traces. Well versed in SQL Profiles, Oracle Baselines, v tables, xtables, etc. Indepth knowledge of Fusion Applications technology stack, including architecture.