Oracle EBS Tech Analyst: PL/SQL, Integrations & Upgrades

Socket.dev; United States; On-site; USD 150,000 - 210,000; Full time

Job summary

SMX is seeking an experienced Oracle E-Business Suite specialist to design, customize, and support EBS applications. The role emphasizes PL/SQL/SQL development, data integration, and ensuring alignment with business processes and financial modules.

Key duties include building interfaces, performing data migrations, troubleshooting, and contributing to SDLC activities. A strong background in GL, AP, AR, and related modules is preferred, along with Oracle APEX exposure.

Qualifications

• Active clearance or public trust (sponsor dependent).
• Strong SQL and PL/SQL with Oracle EBS development experience.
• Deep knowledge of Oracle EBS GL, AP, AR, Cash Management, and Treasury modules.
• Bachelor's degree in computer science, IT, or a related field.
• Minimum of 15 years’ experience; postgraduate study may substitute per policy.
• Oracle APEX experience or similar report writer.

Responsibilities

• Develop and customize Oracle EBS apps, reports, extensions, and workflows to meet business needs.
• Build and maintain interfaces for data migration and integration with other systems (XML Publisher, APIs).
• Provide day-to-day technical support and root-cause analysis for the Oracle EBS environment.
• Perform system analysis, upgrades, and ensure performance, stability, and data integrity.
• Test and debug RICE components (Reports, Interfaces, Conversions, Extensions).
• Create and maintain detailed documentation for development processes and solutions.

Skills

SQL

PL/SQL

Oracle EBS

Analytical thinking

SDLC

Financials knowledge

Oracle APEX

Education

Bachelor's degree in Computer Science/Information Technology

Tools

XML Publisher

APIs

EBS development tools

Job description

SMX is seeking an experienced Oracle E-Business Suite specialist to design, customize, and support EBS applications. The role emphasizes PL/SQL/SQL development, data integration, and ensuring alignment with business processes and financial modules.

Key duties include building interfaces, performing data migrations, troubleshooting, and contributing to SDLC activities. A strong background in GL, AP, AR, and related modules is preferred, along with Oracle APEX exposure.