SQL Server Developer

Greetings, Hope you are doing well. Please go through below Job description and lf you are comfort/available for the position then respond with latest/updated resume to srinivas@wavsols.com or 630-397-0596/140 Title: SQL Server Developer (Azure/SSIS) Location: Princeton, NJ (initially will be remote – need ability to work on-site in future if requested) Duration: Long Term Project (6 Month SOW’s) Interview Process: Technical Screening and/or Coderbyte Code Assessment (Apex given) then One and Done Video I/V with Deloitte What it is going to take to get a placement • Primary creating tables, no UI work, back-end database work. Views Triggers, Stored Procedures – Optimization, Troubleshooting, Maintenance, Azure piece, query performance. • ETL work using Azure Data Factory, SSIS • Experience SQL Server 2014, 2016 and some 2012 • Azure SQL – experience with pulling data from or to Azure Requirements: • Design and development of Microsoft SQL Server databases (MS SQL Server 2016/2014/2012). • Minimum X years of experience in software development using Microsoft SQL Server, Azure SQL, T-SQL and T-SQL language. • Creating stored procedures, views, Triggers, Functions and performance tuning of SQL queries. • Must have experience in troubleshooting and resolving database integrity issues, complex query performance optimizations, blocking and deadlocking issues, table partitioning, data replication/restore process • Experience in Database Maintenance plans for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes. • Experience in development of Azure Data factory/SSIS to Extract Data, Transform, Load (ETL) data into SQL Server from different source/environments; • Experience with Data Modeling tools to effectively design the data models • Understanding of API/UI components, json structure, web based application architecture • Ability to understand data and its business applicability • Must have experience working with DevOps and clarity in CI/CD process and experience with source control management like Git. • Working knowledge of BI Tools like Power BI.