| Position || Oracle SCM || Atlanta ,GA - Onsite at Atlanta, Georgia, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3179577&uid=cc240d47cb04424e9391098e118b7848 From: Ankit Sharma, Sira Consulting [email protected] Reply to: [email protected] Share profiles at [email protected] Job Title: Oracle SCM with strong Oracle PL/SQL, Unix batch operations, RCA, and Manhattan UI configuration support. Location: Atlanta, GA Onsite Job Type: Contract Duration: 6 Months About the Role: Retail : Supply Chain Management Manhattan DFIO PL/SQL & Unix Batch Operations Analyst (68 Years) Refined JD Looking for a candidate with strong Oracle PL/SQL, Unix batch operations, RCA, and Manhattan UI configuration support. Role Summary 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 1. Batch Operations & Monitoring Monitor and manage daily/overnight batch jobs (Unix + 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. 2. 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. 3. 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. 4. 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. 5. 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. 6. Quality, Testing & Readiness Create and execute system test plans for fixes and configuration changes; support release readiness and post release validation. 7. 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 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 68 years overall, with substantial time in PL/SQL, Unix batch operations, and production support. Education Bachelors degree in Computer Science, Engineering, Information Systems, or equivalent practical experience. KPIs / Success Measures Reduction in repeat batch failures and mean time to resolve (MTTR). On time completion rates for critical jobs and adherence to SLA. Quality of RCAs/CAPAs and knowledge base contributions. Positive stakeholder feedback on communication and prioritization. Work Model & Availability Comfortable with shift coverage / on call rotation to support critical batch windows, as needed. Tools & Environment (Representative) Oracle DB, PL/SQL Developer/SQL*Plus or equivalent IDE; Unix/Linux ; ticketing (ServiceNow); job schedulers; monitoring/alerting dashboards. If this role aligns with experience and interest, please share the updated resume. Id be happy to connect and discuss the opportunity in more detail. Looking forward to hearing from you! Thanks & Regards Ankit Sharma Email: [email protected] 6363 Richmond Avenue, Ste 255, Houston, TX 77057 W: www.siraconsultinginc.com Keywords: user interface database information technology procedural language Georgia Texas Position || Oracle SCM || Atlanta ,GA - Onsite [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3179577&uid=cc240d47cb04424e9391098e118b7848 |
| [email protected] View All |
| 08:26 AM 03-Mar-26 |