Oracle EBS Tech Analyst | PL/SQL, Integrations & Migrations

SMX; City of Albany (NY); 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. You will write PL/SQL scripts, configure modules, and troubleshoot issues to support client requirements.

Responsibilities include building interfaces for data migration and integration, providing technical support, and ensuring system performance and data integrity while collaborating with cross-functional teams.

Qualifications

• Active clearance or public trust based on sponsor.
• Proficiency in SQL and PL/SQL, AME, and Oracle EBS.
• Design, develop, and maintain custom solutions using PL/SQL, Oracle Forms, Reports, and OAF.
• Experience in iProcurement, Purchasing, and CLM.
• Strong LOA configuration knowledge.
• Familiarity with Oracle 12.2.x schema and ability to create queries.
• Excellent analytical, problem-solving, and communication skills.
• Ability to translate business needs into technical requirements.
• Experience with requirements gathering, testing, and solution design.
• Bachelor's degree in computer science, information technology, or related field.

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 XML Publisher or APIs.
• Technical support: Provide day-to-day support, troubleshoot issues, and perform root cause analysis.
• System administration: Perform system analysis, conduct upgrades, and ensure performance, stability, and data integrity.
• Testing: Conduct functional testing and debugging of RICE components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Skills

SQL

PL/SQL

Oracle EBS

AME

Oracle Forms

Reports

OAF

Data migration

Interfacing

Analytical

Communication

Education

Bachelor's degree in computer science or related field

10+ years’ experience

Tools

XML Publisher

APIs

Oracle APEX

Oracle Reports

PL/SQL

Job description

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications. You will write PL/SQL scripts, configure modules, and troubleshoot issues to support client requirements.

Responsibilities include building interfaces for data migration and integration, providing technical support, and ensuring system performance and data integrity while collaborating with cross-functional teams.