Job ID: JOB_ID_3619
Job Title
Manhattan DFIO PL/SQL & Unix Batch Operations Analyst
Location
Atlanta, GA (Onsite)
Role Description
We are seeking a hands-on analyst/engineer who is strong in Oracle PL/SQL and Unix/Linux to own daily batch job monitoring, perform root-cause analysis (RCA) for failures and performance issues, and ensure end-to-end stability of data processing in a Manhattan (DFIO/SCM) ecosystem. The role includes publishing daily open items, prioritizing work by business impact, and collaborating with DBAs and the Manhattan product team to resolve outliers and configuration issues.
Key Responsibilities
- Batch Operations & Monitoring: 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.
- Root Cause Analysis (RCA): 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). For each failure/performance incident, produce a clear RCA and corrective & preventive actions (CAPA); drive closure.
- Database Analysis (PL/SQL & Performance): 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.
- Manhattan UI & Configuration Support: 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.
- Daily Operations Governance: 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.
- Quality, Testing & Readiness: Create and execute system test plans for fixes and configuration changes; support release readiness and post-release validation.
- Stakeholder Management: 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 Skills
- Experience supporting Manhattan DFIO application (including afterhours/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.
Employment Type
Onsite
Special Requirements
Onsite
Compensation & Location
Salary: $90,000 – $130,000 per year (Estimated)
Location: Atlanta, GA
Recruiter / Company – Contact Information
Recruiter / Employer: Teamware Solutions
Email: h.b@twsol.com
Recruiter Notice:
To remove this job posting, please send an email from
h.b@twsol.com with the subject:
DELETE_JOB_ID_3619