Job Description

Location: Hyderabad or Bengaluru or Chennai (have to go 2-3 days to Ascendion office)

Job Title: Senior Oracle EBS Technical Application Support

Working Hours: Bangkok time zone (1.5 hours ahead of India)

Job Summary: Senior Oracle EBS Technical Application Support The ideal candidate will have in-depth expertise in PL/SQL, Oracle Forms, and Oracle E-Business Suite (EBS) modules. 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 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.

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, 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.