Description
Professional Summary: * Over 7+ years of IT experience in SQL Server Database Administration and SQL Server development. * Experience in installation, configuration, upgrade and maintenance of different versions of SQL Servers (2016, 2014, 2012, 2008R2/2008/2005) in both OLTP and OLAP lower regions, Clustered/Geo Clustered/AlwaysON and Stand Alone Environments. * Implemented High Availability & Disaster Recovery techniques like AlwaysON Availability groups, Clustering (Both Active-Active and Active-Passive), Database Mirroring, Transactional Replication and Log Shipping. * Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012. * Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012 / 2014 new features. * Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance. * Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs. * Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon. * Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks. * Experience in Physical and logical data modeling using ERWIN & VISIO. * Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement. * Experience in developing and tuning SQL Server Integration Services (SSIS) packages and SSRS reports. * Configuring and maintaining Report Manager and Report Server for reporting services. * Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call. * Documenting procedures in run books. Technical Proficiency: * ETL Tools MS SSIS and DTS, TSQL, SQL Server bulk insert and BCP utilities tools IIS, SSIS, DTS, Lite Speed, Spotlight, Visual Studio 2003 / 2005, Team Foundation Server (TFS), Visio 2003, Enterprise manager, query analyser, Perfmon, SQL Profiler, Idera Foglight Red gate.
Accomplishments
Highlights:
Keywords
