14+ Years of experience in SQL Server Database Administration and Developer in SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL 2008(R2), SQL 2005 and SQL 2000 Expertise in TSQL Programming Strong in building SSIS Package and SSRS reports Built a tool in vb.net to migrate the data from various data sources dynamically into SQL Server Built a tool to export the data from the database into an excel sheet Strong in Data encryption technologies Strong in programming in MySQL Strong in recovering the data from the corrupted database Strong in setting up security model for Data and Users Have hands on experience in handling heterogeneous data in various formats. Liaise with 100+ clients for Data migration, Reports and DB administration tasks Built own DR model for our DB server as none of the existing options suit to our environment Automated most of the DB maintenance tasks Have gained knowledge in Mongo DB and Big data concepts Involved in preparing upgrade scripts for database Troubleshoot Performance problems, fine tuning of queries and Index Analysis Strong in Analyzing Execution plans and Performance Counters Hands on experience in integrating ‘R’ Programming with SQL Server Strong in Powershell programming and automated a few DB maintenance tasks using Powershell Implemented Database mirroring and Log shipping Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery and planning. Strong experience in mentoring Team members and technical assistance to R&D developers. Received most valuable person (MVP) award twice in ADP Passed 70-229 in MCDBA Examination with the score of 954 in 2005