Oracle Support Engineer

Job Description

Job Description: Oracle ERP Production Support Analyst 

Position Summary 

We are seeking an experienced Oracle ERP Production Support Analyst to provide production support, operational troubleshooting, incident management, and application support for a highly customized Oracle ERP environment. 

The ideal candidate should have strong Oracle ERP functional knowledge, excellent Oracle SQL/PLSQL skills, and experience supporting business-critical ERP applications. The environment includes significant custom development built on top of Oracle E-Business Suite (11i/R12), requiring both technical troubleshooting and business process understanding. 

Key Responsibilities 

Production Support 

• Provide L2/L3 production support for Oracle ERP applications. 
• Investigate and resolve application, data, and interface issues. 
• Perform root cause analysis and implement corrective actions. 
• Support business users during critical incidents and escalations. 
• Monitor application health, concurrent programs, interfaces, and batch processes. 
• Coordinate with business users, infrastructure teams, vendors, and development teams. 

ERP Functional Support 

• Support day-to-day ERP operations across Order-to-Cash, Procurement, Inventory, and Finance processes. 
• Analyze business process issues and system impacts. 
• Troubleshoot transactional issues and data discrepancies. 
• Work closely with business SMEs and functional teams to resolve production issues. 
• Provide guidance on ERP functionality and process flows. 

Technical Support/Development 

• Develop and troubleshoot Oracle SQL and PL/SQL programs. 
• Support custom interfaces, reports, conversions, and enhancements. 
• Investigate data issues and perform approved data corrections. 
• Analyze performance issues and optimize SQL queries where required. 
• Support deployment and migration activities. 
• Defect fixes, performance tuning, and automation initiatives 
• Testing, deployment, and release support 

Functional Knowledge Required 

Strong Functional Knowledge 

Order-to-Cash (O2C) 

• Customer Orders 
• Shipping Execution 
• Inventory Transactions 
• Invoicing 
• Order Fulfillment Lifecycle 

Procurement 

• Requisitions 
• Purchase Orders 
• Receiving 
• Supplier Management 
• Procurement Workflows 

Inventory Management 

• Inventory Transactions 
• Item Master 
• Cycle Counting 
• Inventory Reconciliation 
• Material Movements 

Finance & Accounting 

• General Ledger (GL) 
• Accounts Payable (AP) 
• Accounts Receivable (AR) 
• Financial Period Close 
• Accounting and Financial Reporting 

Receiving 

• Receipt Processing 
• Receipt Corrections 
• Inventory Receiving Transactions 

Required Technical Skills 

• Oracle E-Business Suite 11i, R12, or higher 
• Strong Oracle SQL and PL/SQL development skills 
• Experience supporting highly customized Oracle ERP environments 
• Oracle Forms, Reports, Interfaces, and Concurrent Programs 
• Data analysis and troubleshooting 
• Incident and production support management 

Preferred Skills 

• Oracle Workflow knowledge 
• XML Publisher / BI Publisher 
• Unix/Linux shell scripting 
• Oracle ERP integrations and interfaces 
• ITIL / production support processes 
• ServiceNow or similar ticketing tools 

Qualifications

Qualifications 

• Bachelor's degree in computer science, information systems, accounting, finance, supply chain, or a related field. 
• 6+ years of Oracle ERP production support experience. 
• Strong Oracle ERP functional and technical troubleshooting experience. 
• Experience supporting business-critical ERP applications in a production environment. 

Key Success Factors 

• Strong understanding of Oracle ERP business processes. 
• Excellent Oracle SQL and PL/SQL troubleshooting skills. 
• Ability to diagnose both functional and technical issues. 
• Strong analytical and problem-solving capabilities. 
• Effective communication with business users and technical teams. 
• Ability to support critical production environments with minimal supervision. 

Technology Stack 

• Oracle E-Business Suite (11i / R12 or higher) 
• Oracle SQL 
• Oracle PL/SQL 
• Oracle Forms & Reports 
• XML Publisher / BI Publisher 
• Unix/Linux 
• ServiceNow