Job Description: SQL Server Developer

Education Qualification: Any Graduate

Minimum Years of Experience:2-3 Years

Key Skills: MS SQL Server

Type of Employment: Permanent

Requirement: Immediate or Max 15 days

Job Responsibilities:

• Responsible to work with development team to develop, implement, and manage data base

models for core product development.

• Responsible to write SQL database views, tables, and stored procedures to

support engineering product development.

• Responsible for designing and maintaining SSIS, T-SQL, and SQL jobs.

• Responsible for developing and maintaining complex stored procedures for loading data into

staging tables from OLTP, and other intermediary systems.

• Responsible for analysis, design specifications, development, implementation, and

maintenance of DB.

• Responsible for designing partitioning of DB for Archive data.

• Responsible to ensure that the best practices and standards established for the use of tools

like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated in Data Analytics

solutions design.

• Responsible for documenting complex processes, business requirements and specifications.

Technical Skills:

• Experience in database design, normalization, query design, performance tuning

• Proficient in writing complex Transact SQL code.

• Proficient in MS SQL Server query tuning.

• Experience in writing stored procedures, functions, views and triggers.

• Experience in Indexes, column store index, SQL server column storage, Query execution plan.

• Provide authentication and authorizations for Database.

• Develop best practices for database design and development activities.

• Experience in database migration activities.

• Strong analytical, multi-tasking and problem-solving skills.