ROLE
– 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.
– Provide authentication and authorizations for Database.
– Develop best practices for database design and development activities.
– Experience in database migration activities.

REQUIREMENTS
– Experience in database design, normalisation, 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.
– Education Qualification: BE/B.Tech/MCA/M.Tech/B.Sc/MS
– Minimum Years of Experience: 3-6yrs of exp
– Key Skills: MS SQL Server
– Experience: 3 to 6 years
– Location: Bangalore