Position: SSE Education Qualification: Graduate (BE/B.Tech/B.Sc/M.Tech/MCA/BCA) Minimum Years of Experience: 2+ Years Key Skills: MS SQL Server 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. Requirements • 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.