Technical Summary:

• 6+ Year Experience in Database Administration, Design, Development and Support of MS SQL Server 2016/2014/ 2012/ 2008 R2/ 2008/ 2005 in Production, Test, Development Servers of Very Large, Multi-Terabyte and Complex Environments.
• Expertise in Installing, Configuring and Troubleshooting AlwaysOn Availability Groups.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Experience in implementing Merge replication, Snapshot and Transactional replication models.
• Implemented Database Mirroring and Configured Database Mirroring in both High Safety and High Performance.
• Implemented both In-Place and Side by Side Migrations of SQL Server Environments.
• Experience in supporting high transaction OLTP Databases in Production Environments.
• Experience in Setting up Log-Shipping.
• Expertise in Capacity Planning, MS SQL Server installation, configuration and installation of Service Packs, Hotfixes for SQL Server.
• Expertise in Creating and Managing User Permissions, Logins and Configuring Security Per Organizational Standards.
• Experience in Installation, Configuration and Maintenance of SQL Servers in BIZTalk, MicroStrategy and SharePoint Server Environments.
• Extensive Knowledge of SOX Compliant and HIPAA Compliant Database Environments and Experience in Working with Change Management Process.
• Expertise of Various Backups, Recovery Methods of SQL Server.
• Hands on Experience in Using Third Party Tools such as Idera SQL Diagnostic Manager, New Relic, Apex SQLDIFF.
• Expert Knowledge in Usage of Open Source Maintenance and Support Solutions Such as Ola Hallengren, Brent Ozar, Adam Machnic’s Who_is_Active and Active in Various SQL Server Communities and PASS.
• Extensive Knowledge in Performance Tuning and Analyzing Locks and Deadlocks in SQL Server
• Hands on Experience in Using SQL Server Native Tools and Options Such as Extended Events, SQL Server Profiler, Activity Monitor for Performance Analysis and Tuning.
• Expertise in Analyzing Index Usage, Fragmentation and Reorganize/Rebuild Indexes, Update Statistics for Better Performance.
• Expertise in Analysis of Query Execution Plans for Low Cost Execution Options and Providing Suggestions on the same.
• Experience in Database Consistency Checks using DBCC Utilities.
• Implemented Change Data Capture (CDC) in SQL Server.
• Extensive Knowledge of Installing SSIS, SSRS and SSAS in Various SQL Server Environments.
• Expertise in Installation and Configuration of Multiple Instances of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive Knowledge of Development, Troubleshooting and Deployment of SSIS Packages.
• Created Various Useful Reports using SSRS regarding Database Administration.
• Knowledge of Development and Deployment of OLAP Cubes in SSAS.
• Experience in Developing Basic PowerShell Scripts, VB Scripts for Automation.
• Expertise in Disaster recovery planning and participated in disaster recovery drills.
• Highly Committed, Motivated Individual and a team player with Strong Ability.
• 24/7 Production Support Experience.