Oracle EBS Tech Analyst: PL/SQL & Integrations

SMX; Helena (MT); On-site; USD 73,000 - 122,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Job summary

SMX seeks accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues, supporting business processes and data migration tasks.

You will collaborate with functional teams, design interfaces, perform testing, and document solutions, leveraging extensive Oracle EBS tools and your deep understanding of the architecture.

Qualifications

• Active clearance or public trust based on sponsor.
• Proficiency in SQL and PL/SQL, AME along with experience in Oracle EBS development tools and a strong understanding of the EBS application architecture.
• Development and customization using PL/SQL, Oracle Forms, Reports, and OAF.
• Experience in Projects, Purchasing, CLM and budgeting.
• Familiarity with Oracle 12.2.x application schema and able to create queries.
• Strong analytical, problem-solving, and communication skills.
• Ability to translate business needs into technical requirements.
• Experience with requirements gathering, testing, and solution design.
• A bachelor's degree in computer science, information technology, or a related field.
• Minimum of 10 years’ experience. Directly related postgraduate study may be substituted for experience at the rate of three credit hours for three months of experience up to 36 credit hours.
• Experience in creating technical documentation.
• Oracle APEX experience (or similar report writer).

Responsibilities

• Development and customization: Design, develop, and maintain custom solutions within Oracle EBS using PL/SQL, Oracle Forms, Reports, and OAF.
• Integration: Build and maintain interfaces for data migration and integration with other systems using 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 components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Skills

SQL

PL/SQL

AME

Oracle EBS

EBS architecture

Oracle Forms

Reports

OAF

Projects

Purchasing

CLM

Budgeting

Oracle 12.2

Queries

Analytical skills

Problem-solving

Communication

Requirements gathering

Testing

Solution design

10+ years experience

Technical documentation

Oracle APEX

Education

Bachelor's degree in computer science, information technology, or related field

Tools

Oracle Forms

Reports

OAF

XML Publisher

APIs

Job description

SMX seeks accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues, supporting business processes and data migration tasks.

You will collaborate with functional teams, design interfaces, perform testing, and document solutions, leveraging extensive Oracle EBS tools and your deep understanding of the architecture.