Design, code and maintain new and existing complex T-SQL stored procedures, triggers and functions
Maintenance and administration of SQL Server databases along with SSIS packages
Enhance and tune existing stored procedures, tables, triggers and indexes based on business needs
Work with other engineers to troubleshoot databases stored procedures, functions to fix issues
Facilitate ad-hoc and scheduled loads of source files in SQL Database
Configuration Management and Deployment of Code in environments like SIT, UAT etc.
Identifying key areas for continuous Improvements in present system to enhance performance and reduce cost
Essential Skills:
Good experience in experience in
MS SQL Server 2014/2016
Business Intelligence in MS SQL - Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server
Azure ? Azure SQL, Azure Data Factory
- Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
- Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from different sources like SQL DB, Excel, XML and CSV
- Expertise in designing and deploying complex SQL Server Reporting Services (SSRS) reports using cascading parameters, Drill-Through Reports, Parameterized Reports and Sub reports
- Experience working in Agile Team and working with Europe/US customer