Senior Oracle EBS Developer & Integration Analyst

SMX; City of Albany (NY); 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 in the United States. Responsibilities include writing PL/SQL scripts, configuring modules, integrating data, and troubleshooting issues to support client requirements.

The role requires strong SQL/PL/SQL skills, experience with Oracle EBS tools (Forms, Reports, OAF, XML Publisher), and the ability to translate business needs into technical solutions.

Qualifications

• Active clearance or public trust required.
• Proficiency in SQL and PL/SQL, AME with Oracle EBS development tools and a strong understanding of the EBS application architecture.
• Design, develop, and maintain custom solutions 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. Postgraduate study may substitute for experience.
• 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, 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 components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Skills

SQL

PL/SQL

Analytical thinking

Communication skills

Requirements gathering

Education

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

Tools

Oracle Forms

Reports

OAF

XML Publisher

Oracle EBS development tools

Job description

SMX is seeking accomplished Technical Associates to develop, customize, and maintain Oracle E-Business Suite applications in the United States. Responsibilities include writing PL/SQL scripts, configuring modules, integrating data, and troubleshooting issues to support client requirements.

The role requires strong SQL/PL/SQL skills, experience with Oracle EBS tools (Forms, Reports, OAF, XML Publisher), and the ability to translate business needs into technical solutions.