Unix Sql Jobs (NOW HIRING)

Job Summary:
VRK IT Vision Inc. is seeking a Manhattan DFIO PL/SQL & Unix Batch Operations Analyst to manage daily batch job monitoring and perform root-cause analysis for failures in a Manhattan ecosystem. The role requires strong skills in Oracle PL/SQL and Unix/Linux, with responsibilities including monitoring batch jobs, analyzing database performance, and collaborating with stakeholders to resolve issues.
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).
• For each failure/performance incident, 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.
Qualifications:
Required:
• 10+ years' experience required
• Strong Oracle PL/SQL
• Unix batch operations
• RCA
• Manhattan UI configuration support
• Oracle DB
• PL/SQL Developer/SQL*Plus or equivalent IDE
• Unix/Linux shell
• ticketing (ServiceNow)
• job schedulers
• monitoring/alerting dashboards
• Hands-on analyst/engineer
• Daily batch job monitoring
• Perform root-cause analysis (RCA) for failures and performance issues
• Ensure end-to-end stability of data processing in a Manhattan (DFIO/SCM) ecosystem
• Publishing daily open items
• Prioritizing work by business impact
• Collaborating with DBAs and the Manhattan product team to resolve outliers and configuration issues
• 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
• Validate expected behavior in lower environments for Manhattan UI configuration change requests
• Create/execute test scenarios and capture evidence
• 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
• Strong query writing, debugging, and package/procedure analysis
• Proficient with shell scripting, log parsing (grep/awk/sed), and standard job orchestration (cron or enterprise schedulers)
• Demonstrated ability to read logs, trace data across tables, and isolate failure causes; produce actionable CAPA
• Reading execution plans, understanding indexing/statistics, and working closely with DBAs on remediation
• Working knowledge of Supply Chain, with exposure to Inventory planning and/or Demand forecasting processes (tool-agnostic)
• Experience with incident/change management and structured status reporting to business/IT
• 6–8 years overall, with substantial time in PL/SQL, Unix batch operations, and production support
• Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent practical experience
• Comfortable with shift coverage / on-call rotation to support critical batch windows, as needed
Preferred:
• 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
Company:
VRK IT Vision Inc. Founded in , the company is headquartered in Princeton, USA, with a team of 201-500 employees. The company is currently Growth Stage.