SQL Server Developer_TCG_SHIVAM

Job Position: SQL Server Developer Relevant Experience :3+Years Location :Kolkata/remote Notice Period: immediate To 30 days Client :TCG Digital Job description :  Working experience on SQL Server 2019/2016/2014/2012 versions.  Extensive experience in Creating Tables, Views, Synonyms, Constraints, Temp Tables, Table Variables and writing code in Dynamic SQL.  Master in writing complex queries to retrieve data using Joins, Sub Queries, Aggregate Functions, String Functions, Union, UnionAll, Pivot, UnPivot, Ranking and RowNumber Functions.  Experience in creating and using Recursive CTE’s in complex requirements.  Extensive experience and expertise in scripting Stored Procedures, User Defined Functions.  Good experience in creating and using Cursors.  Experience in handling exceptions using Try…, Catch.  Good experience in writing DML Triggers to log data changes in audit tables.  Extensive Experience on troubleshooting production issues.  Knowledge on Query Optimization by creating Indexes.  Experience on writing and using While Loop and IF statements.  Involved in all Database related discussions in the internal project.  Knowledge on using SQL Profiler to debug the issues.  Having good knowledge on creating and scheduling of T-SQL jobs.  Always provideed first response to reported production incidents followed by resolution.  Root Cause Analysis done for many production issues and implimented permanent fixes and deployed in production.  Worked with multiple teams across units to identify business needs and solution options.  Experience in administration including adding database logins, granting permissions, profiler tracing and taking backups.  Experience in identifying potential problems and recommended alternative solutions.  Quick learner, excellent problem solving and analytical skills and to address the business problems with sound technical solution.  Strong inclination for finishing tasks before deadline. Strong ability and experience in seeking solutions effectively in challenging environment.  Excellent understanding of project issues, Ability to work on critical requirements.