Oracle EBS Tech Consultant: R12, PL/SQL & Integrations

First Advantage Global operating Centre; United States; Remote; USD 110,000 - 140,000; Full time

Job summary

First Advantage is seeking an Oracle Apps Technical Consultant to design, develop, customize, and support Oracle E‑Business Suite R12 applications. You will work with functional teams and business users to translate requirements into robust technical solutions, ensuring performance, scalability, and compliance with Oracle standards.

You will build interfaces, perform data migrations, and provide production support, including troubleshooting and tuning.

Qualifications

• Strong experience in Oracle E-Business Suite R12.
• Expertise in SQL, PL/SQL.
• Hands-on experience with Oracle Reports, BI Publisher (XML, RTF templates), Interfaces and APIs, Concurrent Programs.
• Good understanding of Oracle EBS architecture.
• Experience with Unix/Linux shell scripting.
• Knowledge of Oracle database objects and performance tuning.

Responsibilities

• Design, develop, customize, and maintain Oracle E‑Business Suite R12 components.
• Design interfaces between Oracle EBS and external systems.
• Perform data migration and conversion using SQL, PL/SQL, and Oracle tools.
• Provide production support, including issue analysis and bug fixes.
• Troubleshoot concurrent program failures and database errors.
• Tune SQL queries and PL/SQL programs for performance.

Skills

Oracle E-Business Suite R12

SQL

PL/SQL

Unix/Linux shell scripting

Oracle database objects

Tools

Oracle Reports

BI Publisher

Interfaces and APIs

Concurrent Programs

Forms

OAF

ADF components

Job description

First Advantage is seeking an Oracle Apps Technical Consultant to design, develop, customize, and support Oracle E‑Business Suite R12 applications. You will work with functional teams and business users to translate requirements into robust technical solutions, ensuring performance, scalability, and compliance with Oracle standards.

You will build interfaces, perform data migrations, and provide production support, including troubleshooting and tuning.