Oracle Consultant

Job Summary: Senior Oracle EBS Technical Application Support/Development The ideal candidate will have in-depth expertise in PL/SQL, Oracle Forms, and Oracle E-Business Suite (EBS) modules. And good Exposure with ASCP (Advance supply chain Planning). The role involves providing advanced support, troubleshooting, and enhancements to Oracle EBS applications to ensure smooth business operations.

Key Responsibilities:

• Provide technical and functional support/development as techno-functional expert for Oracle EBS modules, including Order Management, Planning, Procurement, Finance and other relevant areas.
• Develop, maintain, and optimize PL/SQL scripts, stored procedures, and triggers for Oracle databases.
• Good Exp working with ASCP - Advance supply chain Planning
• Customize and troubleshoot Oracle Forms and Reports as per business requirements including Oracle SOA and APEX.
• Collaborate with business users and IT functional support team to identify issues, analyze root causes, and implement effective solutions.
• Provide Root Cause Analysis Report and Preventive action on Critical P1 and P2 issue when specified.
• Perform data analysis, migrations, and integrations between Oracle EBS and other enterprise applications.
• Ensure adherence to best practices in performance tuning, database optimization, and application security.
• Work closely with cross-functional teams, including developers, DBAs, and business analysts, to support system enhancements and upgrades.
• Manage and resolve service requests (SRs) with Oracle Support when needed.
• Document technical solutions, workflows, and user guides for reference and training purposes.

Required Skills & Experience:

• 8+ years of experience in Oracle EBS Application Support/development, with a focus on PL/SQL, Oracle Forms, and Reports.
• Strong expertise in Oracle EBS R12 modules such as Order Management & Planning modules
• In-depth knowledge of Oracle Database (11g/12c/19c), including performance tuning and debugging.
• Hands-on experience in customizing and developing Oracle Forms, Reports, and Workflows.
• Experience with Oracle APIs, Interfaces, and Concurrent Programs.
• Strong troubleshooting skills to resolve application issues efficiently.
• Strong Knowledge of Unix/Linux shell scripting
• Familiarity with Oracle Applications Framework (OAF), BI Publisher, and Web ADI is advantageous.
• Excellent communication and problem-solving skills with the ability to interact with business users and technical team