# Oracle APPS Consultant — TestingXperts

- Location: Dallas, TX
- Posted: Sep 30, 2016
- Status: open (checked Nov 18, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/testingxperts/99270937
- Employer record: https://visajobs.io/company/testingxperts.md

## Sponsorship history
- Tier: Some history
- Occupation (SOC): Software Developers (15-1252)
- Employer's certified LCAs for this occupation in TX, FY2024–FY2026: 1
- …in the whole US: 4
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $84k / $106k

## Description
Job Description
Title: Oracle APPS Consultant
Location: Dallas, TX
Duration: 6 to 12 months
Interview: Phone and Skype
Job description:-
· 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.
· Domain: Telecom
Additional Information
All your information will be kept confidential according to EEO guidelines.

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
