Senior Oracle Consultant Full Time NEW

Since 2004, 2P has been a leader in Saudi Arabia’s ICT landscape, delivering integrated technology solutions that help organizations accelerate digital transformation and improve operational efficiency. With a strong foundation in innovation and service excellence, 2P continues to provide end-to-end solutions through its specialized business units and trusted market expertise. We are always looking to connect with talented professionals who are passionate about making an impact and growing within a dynamic, forward-looking environment.

Senior Oracle EBS Technical Consultant

Job Purpose

The Senior Oracle EBS Technical Consultant is responsible for designing, developing, enhancing, and supporting Oracle E-Business Suite technical solutions across implementation, rollout, enhancement, and support projects. The role requires strong hands-on technical expertise in Oracle EBS development tools, integrations, reporting, workflows, conversions, and system enhancements, while working closely with business users, functional consultants, and project teams to deliver reliable, scalable, and best-practice-based solutions.

Key Responsibilities

Oracle EBS Technical Development & Support

• Design, develop, enhance, and support Oracle E-Business Suite technical components across various business modules.
• Work on Oracle Forms, OAF, BI Publisher, Oracle Reports, Oracle Workflow, AME, SQL*Loader, Open Interfaces, Oracle APIs, AOL concepts, and Forms Personalization.
• Deliver technical solutions in line with Oracle EBS standards and project requirements.
• Ensure solutions are upgrade-safe, maintainable, and aligned with EBS best practices.
• Avoid direct base-table updates and utilize standard APIs and Open Interfaces wherever applicable.

Requirements Gathering & Solution Design

• Work independently with business users and functional consultants to gather and analyze business requirements.
• Translate functional requirements into technical designs, development specifications, and system solutions.
• Provide technical recommendations and solution options based on business needs and Oracle EBS capabilities.
• Collaborate with integrated project delivery teams to ensure alignment between business, functional, and technical workstreams.

End-to-End Delivery

• Manage the full technical delivery lifecycle, including:
• Technical design
• Development
• Unit testing
• SIT/UAT support
• Production deployment
• Post-go-live support
• Support project rollouts, enhancements, and production stabilization activities.
• Ensure timely and quality delivery of assigned technical tasks and deliverables.

Troubleshooting & Production Support

• Investigate and resolve production issues related to Oracle EBS technical components.
• Perform root-cause analysis, log analysis, debugging, performance tuning, and issue resolution.
• Support governed data fixes when required, following proper controls and approvals.
• Monitor and troubleshoot technical issues across workflows, interfaces, reports, forms, and OAF pages.
• Provide reliable post-go-live and operational support.

Reporting & BI Publisher

• Develop and support BI Publisher / XML Publisher reports, data extracts, layouts, and templates.
• Maintain and enhance legacy Oracle Reports where applicable.
• Ensure reports meet business requirements, performance standards, and data accuracy expectations.
• Support report troubleshooting, optimization, and deployment activities.

Interfaces & Integration

• Design, develop, and support inbound and outbound integrations using Oracle EBS standard approaches.
• Work with Open Interfaces, Oracle public APIs, service enablement, and controlled data exchange patterns.
• Support integrations with internal and external systems.
• Troubleshoot interface failures, data issues, and integration errors.

Data Conversion & Migration

• Perform data conversion and migration activities using SQL*Loader, staging tables, validation, and reconciliation processes.
• Load data through Open Interfaces and Oracle public APIs.
• Ensure migrated data accuracy, completeness, and compliance with business rules.
• Prepare conversion scripts, validation reports, and reconciliation outputs.

Enhancements & Customizations

• Deliver Oracle EBS enhancements using upgrade-safe approaches, including custom objects, extensions, and personalization where suitable.
• Implement proper logging, error handling, deployment discipline, and technical controls.
• Ensure custom developments are documented, tested, and aligned with Oracle EBS best practices.

Oracle Forms

• Develop, maintain, and troubleshoot Oracle Forms.
• Work with triggers, libraries, form compilation, deployment, and Forms Personalization.
• Support form-level customizations and issue resolution in line with business requirements.

Oracle Workflow & AME

• Build, extend, support, and troubleshoot Oracle Workflow components.
• Use Workflow Builder for workflow development and maintenance.
• Support notifications, monitoring, retries, and workflow issue resolution.
• Configure and support AME rules where applicable.

Oracle Application Framework (OAF)

• Develop and support OAF components using JDeveloper.
• Work on OAF personalization and extensions, including Controller, AM, and VO where applicable.
• Support diagnostics, logging, and troubleshooting for EBS self-service pages such as iProcurement and SSHR.
• Maintain and enhance OAF-based business solutions.

Integrated SOA Gateway (ISG)

• Expose and consume EBS services through ISG using REST and SOAP.
• Enable and publish service definitions for PL/SQL APIs.
• Manage security, grants, and access configuration for EBS services.
• Test services using tools such as Postman and SOAP UI.
• Troubleshoot service invocation, integration, and connectivity issues.

Documentation & Knowledge Transfer

• Prepare clear and complete technical documentation, including:
• Technical design documents
• Development specifications
• Deployment notes
• Test evidence
• Operational handover documents
• Maintain proper documentation discipline throughout the delivery lifecycle.
• Support knowledge transfer to business, functional, technical, and support teams.

Qualifications & Requirements

Education

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Computer Engineering, or a related field.

Experience

• Minimum 8+ years of experience in Oracle ERP / Oracle E-Business Suite technical consulting.
• Strong experience across Oracle EBS implementation, rollout, enhancement, and support projects.
• Proven experience delivering end-to-end technical solutions within Oracle EBS environments.
• Experience working directly with business users, functional consultants, technical teams, and project stakeholders.
• Strong production support and troubleshooting experience.

Technical Skills

• Strong hands-on experience in:
• Oracle Forms
• Oracle Application Framework (OAF)
• BI Publisher / XML Publisher
• Oracle Reports
• Oracle Workflow
• AME
• SQL*Loader
• Open Interfaces
• Oracle APIs
• AOL concepts
• Forms Personalization
• Strong knowledge of Oracle EBS technical architecture and development standards.
• Experience with inbound and outbound integrations.
• Experience with data migration, staging, validation, reconciliation, and conversion processes.
• Strong SQL and PL/SQL development skills.
• Experience with performance tuning, log analysis, debugging, and root-cause analysis.
• Experience with ISG, REST/SOAP services, Postman, and SOAP UI.
• Good understanding of EBS self-service modules such as iProcurement and SSHR is preferred.

Professional Skills

• Ability to work independently and manage assigned technical deliverables.
• Strong analytical and problem-solving skills.
• Strong communication skills in Arabic and English.
• Ability to work effectively within an integrated project delivery model.
• Strong documentation and handover discipline.
• Ability to manage technical priorities under pressure.
• Commitment to quality, governance, and Oracle EBS best practices.

Competencies

• Technical ownership and accountability.
• Analytical thinking.
• Problem-solving and troubleshooting.
• Communication and stakeholder management.
• Attention to detail.
• Team collaboration.
• Quality focus.
• Continuous improvement mindset.