Hi
My name is Rohit Chauhan, and I am a Staffing Specialist at Novia Infotech LLC. I am reaching out to you on an exciting job opportunity with one of our clients.
Job Title: Manhattan DFIO – PL/SQL & Unix Batch Operations Analyst
Location:
Atlanta, GA (Onsite)
Job Summary
We are seeking a hands-on PL/SQL & Unix Batch Operations Analyst with strong experience in Manhattan DFIO / SCM systems. The role involves monitoring batch jobs, performing root cause analysis (RCA), troubleshooting production issues, and ensuring stability of data pipelines in a retail supply chain environment.
The ideal candidate should have strong expertise in Oracle PL/SQL, Unix/Linux, and production support, along with the ability to work in a fast-paced, SLA-driven environment.
Key Responsibilities
Batch Monitoring & Operations
- Monitor and manage daily/overnight batch jobs using Unix shell scripts and PL/SQL
- Validate job execution, handle failures, and perform safe reruns
- Ensure timely completion of critical batch processes
Root Cause Analysis & Production Support
- Investigate job failures using Unix logs, database logs, and runbooks
- Identify root causes (data issues, code defects, configuration, or performance bottlenecks)
- Document RCA and implement corrective/preventive actions (CAPA)
Database & Performance Analysis
- Analyze and debug PL/SQL procedures, functions, and packages
- Diagnose slow queries and review execution plans
- Collaborate with DBAs for performance tuning (indexing, stats, query optimization)
- Understand data flow and relationships across SCM systems
Manhattan Application Support
- Support Manhattan DFIO UI configurations and functional issues
- Validate configuration changes in lower environments
- Work with product teams to resolve complex or outlier issues
Operations Governance & Reporting
- Track and publish daily status of open issues
- Prioritize tasks based on business impact and SLAs
- Manage incidents, problems, and changes using ServiceNow
- Maintain runbooks and knowledge base documentation
Testing & Release Support
- Create and execute test scenarios for fixes and enhancements
- Support release activities and post-deployment validation
Stakeholder Communication
- Provide regular updates to business and IT stakeholders
- Communicate risks, blockers, and resolution timelines clearly
Required Skills
- Strong experience in Oracle SQL & PL/SQL
- Proficiency in Unix/Linux and shell scripting
- Hands-on experience in batch job monitoring & scheduling
- Strong RCA and troubleshooting skills in production environments
- Knowledge of query performance tuning and execution plans
- Understanding of Supply Chain Management (SCM) processes
- Experience with incident/change management tools (ServiceNow)
Preferred Skills
- Experience with Manhattan DFIO / Manhattan SCM
- Exposure to Snowflake or BigQuery
- Retail domain experience
- Experience working in 24/7 support or on-call environments
|
Rohit Chauhan IT Recruiter A: 4421 Avenida Ln, McKinney, TX, 75070
|
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CAJ0-OE9dh%3Dw4LraSGskDxrs%2Bvtteyjmb-%2Bb-tkUUpU9j1PFLbQ%40mail.gmail.com.
No comments:
Post a Comment