What are the responsibilities and job description for the Oracle PL-SQL Lead Developer(Manufacturing/ Logistic/ Retail) - Rosemont, IL - Fulltime opportunity position at Zodiac Solutions?
Job Role: PL-SQL Lead/Senior Developer (Retail/ Manufacturing/ Logistics/ Distribution domain)
Location: Rosemont, IL
Employment Type: Long term contract / Full Time
Experience: 10 – 14 Years
_ (Looking for a candidate from Retail/ Manufacturing/ Logistics/ Distribution domain)_
Role Overview
We 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 Responsibilities
- Design, 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 Skills
- Databases: Oracle 11g/12c , MS SQL Server
- Programming: PL/SQL, SQL, ETL methodologies
- Tools: SQL Developer, TOAD, SQL Plus, SSRS
- Operating System: Windows
- Other: Performance Tuning, Data Modeling, Error Handling, Job Scheduling
- Experience working with Manufacturing, Distribution or Logistics industries
Education
Bachelor’s Degree in Computer Science, Information Technology, or related discipline.
Preferred Attributes
- Strong 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 Kumar
sanjay.kumar@zodiac-solutions.com
Job Type: Contract
Pay: $110,000.00 - $130,000.00 per year
Work Location: In person
Salary : $110,000 - $130,000