Sr Engineer - DB
Job Description
Clean Harbors Inc. (www.cleanharbors.com) is a NYSE listed US based $6.5 billion company. Clean Harbors was founded in 1980 near Boston by Mr. Alan S. McKim, 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 750 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.
Job Title: Sr SQL Developer
Experience: 8- 12 Years
Location: Hyderabad
Working Hours: 12:00pm to 9.00pm IST
Required Skills: Microsoft SQL Server, SSIS, SSRS & SSAS, C# scripting will be added advantage
- Develop, manage, and maintain SQL Server databases.
- Design of database structures and optimizations of existing databases
- Development and maintenance of stored procedures, functions and triggers
- Should be strong in Optimization and performance tuning of database structures and queries
- Should be able to create ER diagrams, perform normalization, and design schemas.
- Should be able to write efficient and well-documented SQL and C# code.
- Implement indexing strategies to enhance database performance.
- Strong knowledge in database design (tables, views, indexes)
- Must have very strong knowledge in debugging & writing stored procedures, functions and triggers
- Good knowledge in Optimize queries to ensure high performance.
- Implement indexing strategies, partitioning, and load balancing techniques.
- Must have experience in SQL Server Integration (SSIS)
- Should be able to develop and maintain ETL processes using SSIS.
- Design and implement data warehousing solutions.
- Should have the capability to work with SSRS and SSAS for reporting and analysis.
- Work with Azure services such as SQL Database.
- Implement data encryption, user access control, and auditing.
- Must have knowledge in source code repository tools such as Git, TFS, etc…
- Excellent problem-solving and analytical skills.
- Strong communication and teamwork abilities.
- Attention to detail and a commitment to quality.
Education:
- UG: B.Tech/B.E. in Production/Industrial
- PG: MCA in Computers, Any Postgraduate