Oracle EBS Technical Consultant

Prominds Business Consulting Inc; San Diego (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

Prominds Business Consulting Inc. in San Diego, CA is seeking an experienced Oracle EBS Technical Consultant to support development, customization, integrations, and production support for Oracle E-Business Suite.

The role emphasizes hands-on PL/SQL, Forms, and Reports work, along with API usage, interfaces, and RICEW objects. Collaboration with business users and functional consultants is essential for successful delivery.

Qualifications

• Experience implementing Oracle EBS modules and extensions.
• Strong PL/SQL development and performance tuning.
• Experience with Forms, Reports, and RICEW objects.
• Ability to collaborate with functional teams and business users.
• Experience with production support and deployments.

Responsibilities

• Develop and maintain complex PL/SQL packages, procedures, functions, triggers, and SQL queries.
• Design, develop, customize, and support Oracle Forms and Oracle Reports.
• Develop and support RICEW objects including Reports, Interfaces, Conversions, Extensions, and Workflows.
• Work with Oracle EBS APIs, Open Interface tables, Concurrent Programs, Value Sets, and Flexfields.
• Troubleshoot production issues and perform root-cause analysis.
• Support integrations and inbound/outbound interfaces.
• Collaborate with functional consultants and business users to understand requirements and provide technical solutions.
• Perform SQL/PLSQL performance tuning and debugging.
• Prepare technical design documents, unit-test cases, deployment documents, and support documentation.
• Participate in testing, deployment, patching, and production support activities.

Skills

Oracle EBS

PL/SQL

Oracle Forms

Oracle Reports

APIs

Open Interface Tables

Concurrent Programs

Value Sets

Flexfields

Tools

Oracle EBS APIs

Open Interface Tables

Concurrent Programs

Value Sets

Job description

Job Summary

We are looking for an experienced

San Diego, CA

Contract / Long Term

Job Summary

We are looking for an experienced Oracle EBS Technical Consultant with strong hands-on expertise in Oracle PL/SQL, Forms, and Reports to support Oracle E-Business Suite development, customization, integrations, enhancements, and production support.

Key Responsibilities

• Develop and maintain complex PL/SQL packages, procedures, functions, triggers, and SQL queries.
• Design, develop, customize, and support Oracle Forms and Oracle Reports.
• Develop and support RICEW objects including Reports, Interfaces, Conversions, Extensions, and Workflows.
• Work with Oracle EBS APIs, Open Interface tables, Concurrent Programs, Value Sets, and Flexfields.
• Troubleshoot production issues and perform root-cause analysis.
• Support integrations and inbound/outbound interfaces.
• Collaborate with functional consultants and business users to understand requirements and provide technical solutions.
• Perform SQL/PLSQL performance tuning and debugging.
• Prepare technical design documents, unit-test cases, deployment documents, and support documentation.
• Participate in testing, deployment, patching, and production support activities.