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