SSE Lead - Bihar, India - SRBS

Description

Position:
SE/ SSE / Tech Lead

Key Skills:
MS SQL Server

MS SQLTSQLSSIS
Job Responsibilities: Responsible to work with development team to develop implement andmanage data base models for core productdevelopment. Responsible to write SQLdatabase views tables and stored procedures tosupport engineering product development. Responsible for designing and maintainingSSIS TSQL and SQL jobs. Responsible fordeveloping and maintaining complex stored procedures for loadingdata into staging tables from OLTP and otherintermediary systems. Responsible foranalysis design specifications development implementation andmaintenance of DB. Responsible for designing partitioning of DB for Archive data. Responsible to ensure that the bestpractices and standards established for the use of toolslike SQL Server SSIS SSRS Excel PowerPivot/View/Map are incorporated in Data Analyticssolutions design. Responsible for documenting complex processes business requirementsand specifications.


Technical Skills:

Experience in database design normalization query designperformance tuning Proficient in writingcomplex Transact SQL code. Proficient in MSSQL Server query tuning. Experience inwriting stored procedures functions views and triggers. Experience in Indexes column store indexSQL server column storage Query execution plan. Provide authentication and authorizationsfor Database. Develop best practices fordatabase design and development activities. Experience in database migration activities. Strong analytical multitasking andproblemsolving skills.
sse,sql,tuning