Sr Software Engineer - WMS Oracle

<h3>Job Description</h3><p>Job Description – AGWMS Production Support Analyst </p><p>Position Summary </p><p>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. </p><p>The ideal candidate should possess a strong combination of technical expertise and warehouse functional knowledge to effectively support business-critical supply chain operations. </p><p>AGWMS consists of: </p><ul><li><p>Oracle PL/SQL backend </p></li></ul><ul><li><p>Delphi front-end application (preferred but not mandatory) </p></li></ul><ul><li><p>SQR reporting and label printing </p></li></ul><ul><li><p>Unix/Linux shell scripts and daemon jobs </p></li></ul><ul><li><p>Warehouse operational interfaces and integrations </p></li></ul><p> </p><p>Key Responsibilities </p><p>Production &amp; Application Support </p><ul><li><p>Provide L2/L3 production support for AGWMS applications. </p></li></ul><ul><li><p>Investigate and resolve production incidents and operational issues. </p></li></ul><ul><li><p>Perform root cause analysis and implement corrective actions. </p></li></ul><ul><li><p>Monitor batch jobs, interfaces, and daemon processes. </p></li></ul><ul><li><p>Support warehouse operations during business-critical incidents and escalations. </p></li></ul><ul><li><p>Coordinate with business users, infrastructure teams, and vendors. </p></li></ul><ul><li><p>Oracle PL/SQL development and code fixes </p></li></ul><ul><li><p>AGWMS custom program, interface, report, and label enhancements </p></li></ul><p> </p><ul><li><p>Unix shell script and daemon job modifications </p></li></ul><p> </p><ul><li><p>Testing, deployment, and performance improvements </p></li></ul><p> </p><p>Functional Warehouse Support </p><ul><li><p>Support daily warehouse operations and troubleshoot process-related issues. </p></li></ul><ul><li><p>Analyze inventory discrepancies, shipment issues, receiving exceptions, and order processing problems. </p></li></ul><ul><li><p>Work closely with warehouse supervisors and business SMEs to resolve operational issues. </p></li></ul><ul><li><p>Understand and support warehouse execution processes and business workflows. </p></li></ul><ul><li><p>Provide guidance on system functionality and operational best practices. </p></li></ul><p>Oracle &amp; Technical Support </p><ul><li><p>Troubleshoot Oracle PL/SQL packages, procedures, functions, and triggers. </p></li></ul><ul><li><p>Perform data analysis and support data correction activities. </p></li></ul><ul><li><p>Investigate interface failures and integration issues. </p></li></ul><ul><li><p>Support deployment and release activities. </p></li></ul><ul><li><p>Troubleshoot Unix shell scripts and daemon jobs. </p></li></ul><p>Continuous Improvement </p><ul><li><p>Identify recurring issues and recommend permanent solutions. </p></li></ul><ul><li><p>Support operational improvement initiatives and system enhancements. </p></li></ul><ul><li><p>Contribute to process automation and support efficiency improvements. </p></li></ul><p> </p><p>Functional Knowledge Required </p><p>Strong understanding of warehouse management and supply chain processes, including: </p><p>Inventory Management </p><ul><li><p>Inventory adjustments </p></li></ul><ul><li><p>Cycle counting </p></li></ul><ul><li><p>Inventory reconciliation </p></li></ul><ul><li><p>Inventory transfers </p></li></ul><p>Inbound Operations </p><ul><li><p>ASN processing </p></li></ul><ul><li><p>Receiving </p></li></ul><ul><li><p>Putaway </p></li></ul><ul><li><p>Quality holds </p></li></ul><p>Outbound Operations </p><ul><li><p>Order management </p></li></ul><ul><li><p>Picking </p></li></ul><ul><li><p>Packing </p></li></ul><ul><li><p>Shipping </p></li></ul><ul><li><p>Manifest processing </p></li></ul><p>Warehouse Operations </p><ul><li><p>Replenishment </p></li></ul><ul><li><p>Slotting concepts </p></li></ul><ul><li><p>Label printing </p></li></ul><ul><li><p>RF device operations </p></li></ul><ul><li><p>Exception management </p></li></ul><p>Integrations </p><ul><li><p>ERP to WMS interfaces </p></li></ul><ul><li><p>Shipment and carrier integrations </p></li></ul><ul><li><p>Inventory synchronization processes </p></li></ul><p> </p><p>Required Technical Skills </p><ul><li><p>Strong Oracle SQL and PL/SQL experience </p></li></ul><ul><li><p>Oracle database troubleshooting and support </p></li></ul><ul><li><p>Unix/Linux shell scripting </p></li></ul><ul><li><p>Batch job monitoring and support </p></li></ul><ul><li><p>Incident management and production support experience </p></li></ul><ul><li><p>Data analysis and troubleshooting skills </p></li></ul><p> </p><p>Preferred Skills </p><ul><li><p>Delphi application support experience (preferred but not mandatory) </p></li></ul><ul><li><p>SQR reporting and la