Manhattan DFIO PL/SQL - Unix Batch Operations Analyst

Key Responsibilities

• Monitor and manage daily/overnight batch jobs (Unix shell + SQL/PLSQL steps); validate pre-/post-conditions and recover/rewind missed or skipped steps.
• Triage job failures, capture diagnostics, and execute reruns safely with appropriate approvals and documentation.
• Investigate failures by reviewing Unix logs, job runbooks, and database logs; pinpoint breaking step(s) and document the actual cause (e.g., data, logic, config, capacity).
• Produce a clear RCA and corrective & preventive actions (CAPA); drive closure.
• Analyze PL/SQL packages, procedures, and functions implicated in failures; identify defects, data issues, or edge cases.
• Diagnose long-running queries; obtain and interpret execution plans; coordinate with DBA for index, stats, and plan-stability actions.
• Maintain and leverage an up-to-date entity-relationship (ER) understanding of core tables and data flows across DFIO/SCM modules.
• For Manhattan UI configuration change requests, validate expected behavior in lower environments; create/execute test scenarios and capture evidence.
• For unclear or outlier behaviors, collaborate with the Manhattan product team to confirm product-level settings and recommended fixes.
• Publish daily open items and status across the team queue; prioritize by business criticality and SLAs; call out blockers and risks.
• Adhere to change/incident processes (e.g., ServiceNow: incidents, problems, change requests), maintain accurate runbooks and knowledge base articles.
• Create and execute system test plans for fixes and configuration changes; support release readiness and post-release validation.
• Partner with business users to understand impacts and timelines; provide clear, concise communication on incident status, ETAs, and next steps.

Must-Have Skills

• Oracle SQL & PL/SQL: Strong query writing, debugging, and package/procedure analysis.
• Unix/Linux: Proficient with shell scripting, log parsing (grep/awk/sed), and standard job orchestration (cron or enterprise schedulers).
• RCA & Troubleshooting: Demonstrated ability to read logs, trace data across tables, and isolate failure causes; produce actionable CAPA.
• Performance Tuning Basics: Reading execution plans, understanding indexing/statistics, and working closely with DBAs on remediation.
• SCM Functional Context: Working knowledge of Supply Chain, with exposure to Inventory planning and/or Demand forecasting processes (tool-agnostic).
• Process & Communication: Experience with incident/change management and structured status reporting to business/IT.
• Good-to-Have Experience: Supporting Manhattan DFIO application (including after-hours/incident support), understanding common processing/data errors; familiarity with cloud data warehouses such as Snowflake or BigQuery for downstream analytics/performance considerations; Retail domain exposure; Experience Range 6–8 years overall, with substantial time in PL/SQL, Unix batch operations, and production support.