What are the responsibilities and job description for the PL-SQL Developer/Lead with WMS/Manufacturing/Logistic - Rosemont, IL - Fulltime opportunity position at Zodiac Solutions?
Job Role: PL-SQL Lead/Senior DeveloperLocation: Rosemont, IL Employment Type: Long term contract / Full TimeExperience: 10 – 14 Years WMS/ Manufacturing or Logistic domain experience is required Role OverviewWe are looking for a Senior PL-SQL Developer with extensive experience in Oracle PL/SQL, MS SQL Server, and Reporting Services like SSRS or other equivalent reporting tools to design, develop, and optimize data pipelines, database objects, and reports supporting enterprise-scale data platforms. The ideal candidate will have a strong background in performance tuning, database development, and reporting implementation.Key ResponsibilitiesDesign, develop, and maintain database objects (tables, views, materialized views, procedures, functions, packages, and triggers).Develop and optimize complex SQL queries, stored procedures, and ETL processes for data transformation and integration.Analyze and optimize database performance using indexes, query plans, and SQL hints.Collaborate with business analysts to translate requirements into technical solutions and ensure data quality and integrity.Provide L2 support and root-cause analysis for production issues; execute ad-hoc queries for business teams.Support change requests and bug fixes through SDLC processes.Lead a track of small offshore team members with similar skills Required SkillsDatabases: Oracle 11g/12c , MS SQL ServerProgramming: PL/SQL, SQL, ETL methodologiesTools: SQL Developer, TOAD, SQL Plus, SSRSOperating System: WindowsOther: Performance Tuning, Data Modeling, Error Handling, Job SchedulingExperience working with Manufacturing, Distribution or Logistics industriesEducationBachelor’s Degree in Computer Science, Information Technology, or related discipline.Preferred AttributesStrong problem-solving and analytical skills.Excellent communication and collaboration abilities across teams.Proven ability to work in fast-paced, client-facing projects.Experience with any WMS software like Manhattan WMS, Krober or any others. Thanks,Sanjay Kumarsanjay.kumar@zodiac-solutions.com