Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
Hands-on development experience with T-SQL.
Strong experience on Database designing, normalization, optimization and performance tuning.
Experience in advanced SQL programming, problem-solving and analytical skills.
Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
Experience in Refactoring / troubleshooting existing databases as needed.
Deep understanding of referential integrity and indexing.
Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
Ability to estimate development tasks accurately and meet agreed upon deadlines.
Understanding of code promotion, version control and QA procedures.
Good Communication skills.
Technical Skills :
MS-SQL 2012 14, SQL Server Management Studio and SQL Server Profiler.
T-SQL, SSRS and SSIS
OS Environments : Windows XP / Windows 7, Windows Server 2003 / 2008
Advantage having knowledge in ASP and C# .NET