Randstad SQL Developer-ERP in Romeoville, Illinois

SQL Developer-ERP

job details:

  • location:Romeoville, IL

  • salary:$75,000 - $90,000 per year

  • date posted:Thursday, February 14, 2019

  • job type:Permanent

  • industry:Professional, Scientific, and Technical Services

  • reference:670977

job description

SQL Developer-ERP

job summary:

As part of the IT Services team and reporting to the Senior Director of IT Services, the SQL Developer will support our client's SQL environment including their warehouse management system (WMS), Manhattans Associate's SCALE and data warehouse. The SQL Developer will be an integral part of the client onboarding and implementation process. The SQL Developer will be responsible for configuring the WMS application as needed to meet the 3PL environment needs of our client and their clients. Working with all levels of the organization, provide level one support for questions/issues. The SQL Developer will be involved in numerous facets of the 3PL business including, order processing (picking, shipping, receiving, etc.), and will interact with customers. The SQL Developer will provide a reasonable assessment of the time and effort to complete a requested task.

location: Romeoville, Illinois

job type: Permanent

salary: $75,000 - 90,000 per year

work hours: 8am to 5pm

education: No Degree Required

responsibilities:

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

  • Create SQL tables, stored procedures, queries, SSRS reports and SSIS packages.

  • Analyze, troubleshoot and performance tune Microsoft SQL databases and clusters.

  • Proficiency with SQL, SQL SSRS and SSIS is required.

  • Provide support to internal and external customers for Manhattan SCALE WMS related issues.

  • Configuration and testing of Manhattan SCALE WMS software.

  • Works with software vendor support to identify and resolve issues.

  • Utilize help desk software, email and phone communication to track and report issues.

  • Work with users to troubleshoot identify bugs and resolve open issues.

  • Bridge the gap between technical and non-technical individuals to resolve issues.

  • Effectively communicate requirements and deliverables to all levels of the organization.

  • Responsible for measuring performance and recovery of system applications including Manhattan's SCALE WMS.

  • Exposure to .NET, Zebra label code, Tableau, data warehousing or other programming is helpful.

  • Knowledge of database design with concurrency optimization is helpful.

  • 24x7 on call.

qualifications:

EDUCATION and/or EXPERIENCE

A minimum of 3 years related experience with formal training or equivalent combination of education and experience. Bachelor's degree (B.A. or B.S) from a College or University or equivalent technical certification is desirable.

  • Hands on experience working with warehouse management systems from implementation to configuration is desirable.

  • Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.

  • Ability to write reports, business correspondence, and procedure manuals. Ability to communicate effectively with groups of managers, clients, and customers.

  • Ability to analyze complex issues related to performance, and efficiency.

  • Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions and deal with several abstract and concrete variables.

Direct Reports

None

TRAVEL REQUIREMENTS

Limited. Ability to travel if necessary.

skills: EDUCATION and/or EXPERIENCE

A minimum of 3 years related experience with formal training or equivalent combination of education and experience. Bachelor's degree (B.A. or B.S) from a College or University or equivalent technical certification is desirable.

  • Hands on experience working with warehouse management systems from implementation to configuration is desirable.

  • Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.

  • Ability to write reports, business correspondence, and procedure manuals. Ability to communicate effectively with groups of managers, clients, and customers.

  • Ability to analyze complex issues related to performance, and efficiency.

  • Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions and deal with several abstract and concrete variables.

Direct Reports

None

TRAVEL REQUIREMENTS

Limited. Ability to travel if necessary.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.