Oracle EBS Tech Analyst - PL/SQL & Integrations

SMX; Trenton (NJ); On-site; USD 73,000 - 122,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Job summary

SMX is seeking accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications. You'll write PL/SQL scripts, configure modules, and troubleshoot issues while supporting business processes and ensuring system functionality meets client requirements.

Collaborate with functional teams, perform data migration and integrations, and contribute to documentation. The role requires SQL/PLSQL proficiency, knowledge of EBS architecture, and the ability to

Qualifications

• Active clearance or public trust may be required.
• Strong SQL/PLSQL and Oracle EBS development experience.
• Experience with PL/SQL, Oracle Forms, Reports, and OAF.
• Experience in Projects, Purchasing, CLM and budgeting.
• Familiarity with Oracle 12.2.x schema and ability to create queries.
• Bachelor's degree in CS/IT or related field.
• 10+ years of experience; postgraduate study substitution policy.
• Experience creating technical documentation.
• Oracle APEX experience (or similar report writer).

Responsibilities

• Design and develop custom Oracle EBS apps, reports, and workflows within Oracle EBS to meet business needs.
• Build interfaces for data migration and integration with XML Publisher or APIs.
• Provide day-to-day support, troubleshoot, and perform root-cause analysis for the Oracle EBS environment.
• Perform system analysis, upgrades, and ensure system performance, stability, and data integrity.
• Perform functional testing and debugging of RICE components.
• Create and maintain detailed documentation for all development processes and solutions.

Skills

Active clearance / public trust

SQL & PL/SQL proficiency

Oracle EBS knowledge

Analytics & problem solving

Effective communication

Education

Bachelor's degree in computer science or information technology

Tools

Oracle Forms

Reports

OAF (Oracle Application Framework)

XML Publisher / APIs

Job description

SMX is seeking accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications. You'll write PL/SQL scripts, configure modules, and troubleshoot issues while supporting business processes and ensuring system functionality meets client requirements.

Collaborate with functional teams, perform data migration and integrations, and contribute to documentation. The role requires SQL/PLSQL proficiency, knowledge of EBS architecture, and the ability to