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.