Senior SQL Developer (5-8 yrs)

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.

Required 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