Develop high performance code using T-SQL and C# in SQL Server 2017 environment, including writing stored procedure, functions, triggers, and SSIS packages.Advanced knowledge of T-SQL, SSIS, SSRS, and ETL processing, including the ability to remediate issues with complex SQL queries.Development and implementation of new and existing database solutions Create SSIS projects and packages to perform ETL related tasks and prepare SSIS projects for deploymentDesign database import / export processes used to generate client data warehouse deliverablesCreate and maintain conceptual, logical, and physical database models Managing and versioning database projects using Azure DevOpsAnalyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configurationDatawarehouse design principles Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming. Participates in integrating activities with other IT departments for successful implementation and support of project efforts
Skills3 Years of experience in Windows1 year of experience in Powershell3 years of experience in Visual Studio/C#/VB3 years of experience in SSIS3-5 years of experience in TSQL / SQL Server5 years of experience in MS SQL Server 2012-20173 years of experience in SQL Server Management Studio (SSMS)3 years of experience in Visual Studio 2012-2019 (WIth SSDT) - AZURE DEV OPS (Source Control Management)2 years of experience in .NET Framework2 years of experience in Waterfal Model2 years of experience in Agile/SCRUM3 years of experience in AZURE DEV OPS - Running Unit Tests, Task Management (TFS)1 year of experience in MQ Series