
Roles & Responsibilities:
-
Responsible for Creating /modifying stored procedures, functions, triggers, views as per the business requirement.
-
Analyze the existing database objects and optimize it for better performance.
-
Responsible for bulk load / modifying the data from the back end.
-
Develop SSIS Package to load or export the data between different sources (Database to Database, Flat files to Database, Database to Excel/CSV/Text).
-
Develop SSRS Reports for the business requirement.
-
Responsible for creating/extracting the data for Qlik sense as per BI/data visualization requirement and supporting the business users to build the efficient Qlik sense reports.
-
Understand the bug/enhancement requirements and modify/develop TSQL objects as per the business requirement.
Requirements:
-
Good knowledge of Microsoft SQL Server 2012 with 8+ years of experience in SQL Server.
-
Good in DB design and DB Normalization.
-
Good knowledge of SQL including troubleshooting and tuning.
-
Good knowledge of SSIS, SSRS.
-
General SQL performance and tuning skills including server configuration and tracing facilities.
-
General working knowledge of job scheduling.
-
Strong sense of customer commitment, loyalty, and urgency.