Sr Software Engineer - WMS Oracle

Job Description

Job Description – AGWMS Production Support Analyst 

Position Summary 

We are seeking an experienced Production Support Analyst to support and maintain the AGWMS (Automated Global Warehouse Management System) platform. The role will be responsible for application support, incident management, root cause analysis, operational troubleshooting, and business support for warehouse operations. 

The ideal candidate should possess a strong combination of technical expertise and warehouse functional knowledge to effectively support business-critical supply chain operations. 

AGWMS consists of: 

• Oracle PL/SQL backend 

• Delphi front-end application (preferred but not mandatory) 

• SQR reporting and label printing 

• Unix/Linux shell scripts and daemon jobs 

• Warehouse operational interfaces and integrations 

Key Responsibilities 

Production & Application Support 

• Provide L2/L3 production support for AGWMS applications. 

• Investigate and resolve production incidents and operational issues. 

• Perform root cause analysis and implement corrective actions. 

• Monitor batch jobs, interfaces, and daemon processes. 

• Support warehouse operations during business-critical incidents and escalations. 

• Coordinate with business users, infrastructure teams, and vendors. 

• Oracle PL/SQL development and code fixes 

• AGWMS custom program, interface, report, and label enhancements 

• Unix shell script and daemon job modifications 

• Testing, deployment, and performance improvements 

Functional Warehouse Support 

• Support daily warehouse operations and troubleshoot process-related issues. 

• Analyze inventory discrepancies, shipment issues, receiving exceptions, and order processing problems. 

• Work closely with warehouse supervisors and business SMEs to resolve operational issues. 

• Understand and support warehouse execution processes and business workflows. 

• Provide guidance on system functionality and operational best practices. 

Oracle & Technical Support 

• Troubleshoot Oracle PL/SQL packages, procedures, functions, and triggers. 

• Perform data analysis and support data correction activities. 

• Investigate interface failures and integration issues. 

• Support deployment and release activities. 

• Troubleshoot Unix shell scripts and daemon jobs. 

Continuous Improvement 

• Identify recurring issues and recommend permanent solutions. 

• Support operational improvement initiatives and system enhancements. 

• Contribute to process automation and support efficiency improvements. 

Functional Knowledge Required 

Strong understanding of warehouse management and supply chain processes, including: 

Inventory Management 

• Inventory adjustments 

• Cycle counting 

• Inventory reconciliation 

• Inventory transfers 

Inbound Operations 

• ASN processing 

• Receiving 

• Putaway 

• Quality holds 

Outbound Operations 

• Order management 

• Picking 

• Packing 

• Shipping 

• Manifest processing 

Warehouse Operations 

• Replenishment 

• Slotting concepts 

• Label printing 

• RF device operations 

• Exception management 

Integrations 

• ERP to WMS interfaces 

• Shipment and carrier integrations 

• Inventory synchronization processes 

Required Technical Skills 

• Strong Oracle SQL and PL/SQL experience 

• Oracle database troubleshooting and support 

• Unix/Linux shell scripting 

• Batch job monitoring and support 

• Incident management and production support experience 

• Data analysis and troubleshooting skills 

Preferred Skills 

• Delphi application support experience (preferred but not mandatory) 

• SQR reporting and label generation experience 

• Warehouse Management System (WMS) support experience 

• ServiceNow or similar ticketing tools 

• Supply Chain or Logistics domain experience 

Qualifications

Qualifications 

• Bachelor's degree in Computer Science, Information Systems, Supply Chain, or related field. 

• 6+ years of application production support experience. 

• 5+ years of Oracle PL/SQL development/support experience. 

• Experience supporting warehouse, logistics, or supply chain applications. 

Key Success Factors 

• Strong technical troubleshooting skills. 

• Strong understanding of warehouse business processes. 

• Ability to bridge technical and operational teams. 

• Excellent communication and stakeholder management. 

• Ability to support business-critical warehouse operations in a fast-paced environment. 

Technology Stack 

• Oracle Database 

• Oracle PL/SQL 

• Delphi (Optional) 

• SQR Reporting & Label Printing 

• Unix/Linux Shell Scripting 

• Warehouse Management Systems 

• ServiceNow