Oracle APPS Consultant

TestingXperts; Dallas (TX); Presencial; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

TestingXperts is seeking an Oracle Apps Consultant to join on a 6 to 12 month engagement to optimize performance across Oracle Apps and related databases.

The role requires extensive tuning experience with SQL, PLSQL, Java, and SOAFusion, ASH/AWR expertise, 10046/10053 tracing, and strong knowledge of Oracle E-Business Suite R12 and Fusion Apps.

Formación

• Extensive experience with tuning applications using SQL, PLSQL, Java and SOAFusion.
• Expertise in ASH, AWR; 10046 and 10053 traces.
• Proficient with SQL Profiles, Baselines, v tables, xtables.
• Strong knowledge of Solaris and Linux OS and related tracing tools.
• Proficient with Oracle DB 11g RAC and Data Guard tuning.
• Experience in data warehousing tuning using STAR schemas.
• Oracle Apps tuning and app support for Oracle E-Business Suite R12.
• In-depth knowledge of Oracle Applications tech stack and architecture.
• Fusion Apps tuning and app support with architecture knowledge.
• Deep understanding of Oracle internals: blocks, latches, memory structures, locking, optimizer, stats.

Responsabilidades

• Perform performance tuning for Oracle Apps and databases.
• Research and understand internals of new products.
• Provide application support for Oracle E-Business Suite R12 and Fusion Apps.

Conocimientos

Performance tuning

SQL

PL/SQL

Java

SOA Fusion

ASH

AWR

Trace 10046

Trace 10053

SQL Profiles

Oracle Baselines

v tables

xtables

Solaris

Linux

truss

pmap

pfiles

netstat

vmstat

iostat

RAC

Data Guard

Star schemas

Oracle Apps

Fusion Apps

Herramientas

Solaris

Linux

Descripción del empleo

Greetings for the day!
My name is Sai from TestingXperts, we are a global staffing, consulting and technology solutions company, offering industry-specific solutions to our fortune 500 clients and worldwide corporations.

Job Description

Title: Oracle APPS Consultant

Duration: 6 to 12 months

Interview: Phone and Skype

• 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.
• 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 Data guard.
• Good understanding of tuning Data warehousing using STAR schemas.
• Oracle Apps Proficient with performance tuning and application support for Oracle eBusiness suite R12.
• In-depth knowledge of Oracle Applications technology stack, including architecture.
• Fusion Apps Proficient with performance tuning and application support for Fusion Applications.
• In-depth 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.

Additional Information

All your information will be kept confidential according to EEO guidelines.