SQL Developer

THIS POSITION IS ONSITE ONLY IN BURNHAM, IL . REMOTE OR HYBRID WILL NOT BE ALLOWED. NO EXCEPTIONS!

Company Description

Mr. Bult’s, Inc. (MBI) is the largest provider of long-haul waste transportation in North America with a proven track record spanning over 30 years. Headquartered in Illinois, MBI operates nationwide with more than 240 locations, 49 terminals, and hauls over 80,000 tons of waste daily. The company boasts the most extensive fleet in the industry, including 1,300 tractors, 2,500 trailers, over 100 pieces of loading equipment, and 90 trailer tippers. MBI is committed to delivering unparalleled customer service through tailored waste transportation solutions designed to enhance operational efficiency and reduce costs.

Role Description

We are seeking a SQL Developer for a full-time, on-site role at our Burnham, IL. The SQL Developer will be responsible for designing, developing, and maintaining database solutions that support business operations. This includes performing data modeling, implementing ETL processes, creating efficient database designs, analyzing data to drive strategic decisions, and maintaining database security and performance. The role will also involve collaborating with cross-functional teams to support both current business requirements and future growth initiatives.

Qualifications and Responsibilities:

• Demonstrates leadership, self-motivation, problem-solving, and excellent written and verbal communication skills.
• Works independently as a self-starter as well as in collaboration with a team in a fast-paced environment.
• Designs and develops ETL pipelines to integrate various sources of data, including Excel, Flat Files and REST API sources into MSSQL Server using SQL Server Integration Services (SSIS).
• Utilizes critical thinking and creativity in coordination with stakeholders in the development of T-SQL Database Solutions to meet various business requirements.
• Creates and maintains reports using SQL Server Reporting Services (SSRS).
• Monitors SQL Server Agent jobs, diagnosing problems and implementing resolutions as needed.
• Improves and maintains existing database solutions.
• Provides operational support, investigating problems that arise in database solutions and business applications.
• Identifies new technologies and resources to improve the information and technology landscape.
• Maintains reference and standards documentation.
• Troubleshoots issues with Access Databases and Google forms.
• Knowledge in C#, XML and JSON.

Skills, Experience, and Education

• BS or MS in Computer Science or Information Systems, or comparable professional experience.
• 7+ years of experience in an MSSQL environment with strong working knowledge of Microsoft SQL Server 2017 and later.
• Proficient in T-SQL programming.
• Proficient in the use of MSSQL tools, including SQL Server Management Studio, SSIS, SSRS.
• PHP experience a plus.
• Working understanding of Microsoft Access and Microsoft VBA.
• Knowledge of API creation a plus.
• Familiarity in working with MySQL databases.
• Experience with Microsoft Azure a strong plus.
• Strong working knowledge of relational database design and best practices.

Job Type: Full-time

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Application Question(s):

• Experience in PHP?

Experience:

• SSIS: 7 years (Preferred)
• SQL Server Management Studio: 7 years (Preferred)
• SSRS: 7 years (Preferred)
• C#: 2 years (Preferred)
• XML: 2 years (Preferred)
• JSON: 2 years (Preferred)

Ability to Commute:

• Burnham, IL 60633 (Required)

Ability to Relocate:

• Burnham, IL 60633: Relocate before starting work (Required)

Work Location: In person