Job Description :
Minimum 8+ years IT experience on MS Technology Application Development primarily on extensive SQL Server and SQL BI Technology
At least 5+ years’ experience in SQL DB Table Design and Development using latest SQL Server Editions / SQL PaaS
Certification on Microsoft Technology Solutions – SQL 2012 / 2016 or similar
Strong SQL ETL Design and Development Experience for Backend SQL Procedures, Views, Jobs etc.
Experienced on SQL Server DB 2012 / 2016 DB Modelling , DB Normalization and Complex Stored Procedure Development
Excellent Knowledge on T-SQL, SQL Stored Procedure, DB Schema, PowerShell or similar for designing .Net Applications.
Experience on SQL BI skills – SSIS ETL , SSAS , SSRS ( Reporting Solutions)
Experienced on Code Configuration Management Tools & Services viz. VSTS / VSO,
Minimum at least 2 + years in Technical Lead Profile with Full Scale Program that involved DB Logical Design , ERD and SQL Procedures Coding and Implementation Experience.
Ability to draft Technical Architecture / Design Documents for rollout of new solutions into Cloud and Data Center leveraging SQL Backend Storage
Knowledge on Application Troubleshooting, Performance Tuning for Production and Non Production Application Issues using Support Troubleshooting Tools.
Understanding on Authentication and Authorization using AD and SSO
Knowledge on Windows and Forms based Authentications.
Knowledge on Web based solution Development using Microsoft Web Technologies viz. MS.Net, Angular / Bootstrap, Typescripts, JavaScript, WCF, RESTAPI / WebAPI, SQL Server and related technologies.
Knowledge on SQL PaaS Essentials
Knowledge on SQL Traces and Query Optimization