Oracle EBS Tech Analyst – PL/SQL & Data Integrations

SMX; Salt Lake City (UT); On-site; USD 73,000 - 122,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications in Salt Lake City, UT. You will write PL/SQL scripts, configure modules, support business processes, and assist with data migration and integrations.

Required are SQL/PLSQL proficiency, Oracle EBS knowledge, and experience with Oracle Forms/Reports/OAF. A bachelor’s degree and a minimum of 5 years’ related work experience are expected.

Qualifications

• Active clearance or public trust required.
• Proficiency in SQL and PL/SQL with experience in Oracle EBS development tools and understanding of EBS architecture.
• Development and customization using PL/SQL, Oracle Forms, Reports, and OAF.
• Exposure to Projects, Purchasing, and budgeting within Oracle EBS.
• Familiarity with Oracle R12.2.x schema and ability to create queries.
• Strong analytical and communication skills; translate business needs to technical requirements.
• Bachelor's degree in computer science, information technology, or related field.
• Minimum of 5 years’ experience; postgraduate study may substitute for experience (3 credit hours per 3 months).
• Exposure to technical documentation creation.
• Oracle APEX experience (or similar report writer).

Responsibilities

• Develop and customize Oracle EBS applications, reports, extensions, and workflows.
• Build and maintain data migration/integration interfaces (XML Publisher/APIs).
• Provide day-to-day support, troubleshooting, and root cause analysis for Oracle EBS.
• Perform system analysis, upgrades, and monitor performance and data integrity.
• Conduct functional testing and debug of RICE components.
• Create and maintain detailed development documentation.

Skills

SQL/PLSQL

Oracle EBS tools

Oracle Forms

Reports

OAF

XML Publisher

Data migration

Interfaces

Clearance

R12.2.x schema

Communication

Education

Bachelor's degree in CS/IT or related field

Tools

PL/SQL

Oracle Forms

Reports

OAF

XML Publisher

Job description

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications in Salt Lake City, UT. You will write PL/SQL scripts, configure modules, support business processes, and assist with data migration and integrations.

Required are SQL/PLSQL proficiency, Oracle EBS knowledge, and experience with Oracle Forms/Reports/OAF. A bachelor’s degree and a minimum of 5 years’ related work experience are expected.