Engineer Software IT Sr SQL

Job Description

Overview

We are seeking highly skilled and motivated individuals to join our company.

About Clean Harbors:

Clean Harbors Inc. (www.cleanharbors.com) is a NYSE listed US based $4.8 billion company. Clean Harbors was founded in 1980 near Boston by Mr. Alan S. McKim, who today remains the company’s Chairman and CEO.

Everywhere industry meets environment, Clean Harbors is on-site, providing premier environmental, energy and industrial services. Clean Harbors employs a dedicated workforce of 25,000 employees and has over 450 service locations across the U.S., Canada and Mexico. Beyond addressing the environmental needs of its more than 300,000 customers, the Company has been on the front lines of addressing some of the largest emergency response events in North America of the past several decades including the BP Oil Spill in the Gulf of Mexico, the anthrax attacks in New York, the 2015 avian flu outbreak that devastated the poultry industry, Hurricanes Katrina, Rita and Sandy, and the oil pipeline breaks that affected the Yellowstone and Kalamazoo rivers, along with other major chemical releases into the environment.

Clean Harbors India has been strategically established as the Global Capability Center (GCC) to serve our parent company. We take pride in serving some of the most tech savvy business stakeholders at Clean Harbors. The GCC employees form part of our globally integrated teams that provide cutting-edge IT solutions and production support across platforms. Our shared services teams work seamlessly with their global counterparts in providing critical 24x7 support in various functions including Finance, HR, Procurement, IT and Operations. Our aggressive growth plans open significant career advancement opportunities for our employees.

We are operating from Skyview, Hitech City Hyderabad (http://www.theskyview.in/) And Smartworks Baner, Pune and Bangalore. Clean Harbors has substantially invested in the GCC to support its growth plans. The Company is celebrating its 43^rd anniversary and is counting on the GCC to be a part of extending that track record of success.

Title: Sr SQL Developer with SSIS

Location: Hyderabad - Hybrid

Working Hours: 12.00pm to 9.00pm

Responsibilities

• Create database objects such as tables, views, stored procedures, Triggers, Functions etc.
• Good in performance tuning especially tuning complex queries, procedure and indexing strategies Experience in Data Modelling, Database design and well versed with SQL Server best practices.
• Review code and suggest necessary changes wherever needed.
• Create Entity Relationship (ER) Diagrams to the proposed database.
• May participate in multiple projects simultaneously as a senior development team member.
• Communicate with DBA Team to find the root cause of problem in production environment & provide the fixes.
• Communicate with other members of the team and the product team effectively.

Qualifications

• Min 5 - 10 years of experience in SQL Server programming.
• Must have Strong experience with SSIS for min 4+ years.
• Experience in designing scalable data models.
• Good understanding of normalization principles
• Able to read and write advanced TSQL code.
• Experience in using performance tuning tools like SQL plan explorer & Tuning Wizard.
• Experience tuning indices.
• Good understanding of transaction management.
• Excellent Problem-Solving skills.
• Experience with multiple SQL server versions (2012.2017) and awareness of new functionality offered.