SRBS
Location
Bihar | India
Job description
Position: SE/ SSE / Tech Lead
Key Skills: MS SQL Server
MS SQLTSQLSSIS
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 TSQL 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 multitasking and problemsolving skills.
sse,sql,tuning
Job tags
Salary
