Oracle EBS Tech Analyst — PL/SQL & Integrations

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

Job summary

SMX is seeking accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues from Salt Lake City, Utah.

Responsibilities include supporting business processes, ensuring system functionality meets client requirements, collaborating with functional teams, and performing data migration and integrations. A strong background in SQL/PL/SQL and Oracle EBS is essential for this role.

Qualifications

• Active clearance or public trust based on sponsor.
• Proficiency in SQL and PL/SQL with Oracle EBS development tools.
• Design, develop, and maintain Oracle EBS custom solutions (PL/SQL, Oracle Forms, Reports, OAF).
• Experience in Projects, Purchasing, CLM and budgeting.
• Familiarity with Oracle 12.2.x schema and querying.
• Strong analytical, problem-solving, and communication skills.
• Translate business needs into technical requirements.
• Experience with requirements gathering, testing, and solution design.
• Bachelor's degree in CS/IT or related field.
• 10+ years experience; postgraduate study may substitute for experience at 3 credit hours per 3 months up to 36 credit hours.
• Experience in creating technical documentation.
• Oracle APEX experience (or similar report writer).

Responsibilities

• Development and customization: Design and develop custom applications, reports, extensions, and workflows within Oracle EBS to meet business needs.
• Integration: Build and maintain interfaces for data migration and integration with other systems, often using tools like XML Publisher or APIs.
• Technical support: Provide day-to-day support, troubleshoot issues, and perform root cause analysis for the Oracle EBS environment.
• System administration: Perform system analysis, conduct upgrades, and ensure system performance, stability, and data integrity.
• Testing: Perform functional testing and debugging of RICE (Reports, Interfaces, Conversions, Extensions) components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Skills

SQL & PL/SQL

Oracle EBS

AME

Oracle Forms

Reports

OAF

Requirements gathering

Documentation

Analytical skills

Communication skills

Data migration

Education

Bachelor's degree in computer science / information technology / related field

Tools

Oracle Forms

Reports

OAF

XML Publisher

APIs

Job description

SMX is seeking accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues from Salt Lake City, Utah.

Responsibilities include supporting business processes, ensuring system functionality meets client requirements, collaborating with functional teams, and performing data migration and integrations. A strong background in SQL/PL/SQL and Oracle EBS is essential for this role.