• 8 + years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005, 2008, 2012,2016. • Expertise in writing T-SQL Queries using joins, Sub queries and Cursors • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility and SSIS services • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. • Reviewing query performance and optimizing code • Writing queries used for front-end applications (websites, desktop applications) • Designing and coding database tables to store the application’s data • Data modeling to visualize database structure • Working with application developers to create optimized queries • Creating database triggers for automation • Creating table indexes to improve database performance • Programming views, stored procedures, and functions • Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance. • Experience in performing regular Backups and Recovery. • Extensive experience in writing Distributed Queries between SQL Servers by creating link servers. • Good experience with implementing DR solution, High Availability of database servers using Database Replication. • Experience in creating Jobs, Alerts, SQL Mail Agent • Troubleshooting Index performance issues • Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users. • Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics. • Applying code fixes and creating the scripts for alerts. • Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently. And having on-site exposure. • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.