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.
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.
|