MS SQL Server DBA

 13 Years of experience in Database Administration and Production Support SQL DBA with proficiency in SQL Server 2008,2008R2,2012 and 2014.
 Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
 Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
 Administering SQL Server High Availability and Disaster Recovery strategies.
 Worked on logical and physical data base modeling with UML and ERWIN tools.
 Experience in using DMV and dynamic management functions for finding out long running queries.
 Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
 Experience in Disaster Recovery Planning and Security Management operations.
 Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
 Having hands on experience in DR processes including Log shipping and Database Mirroring.
 Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
 Troubleshoot performance problems, fine-tuning of databases and index Analysis.
 Worked on SQL Server 2016 migration from SQL Server 2008R2, 2012 and 2014.
 Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
 Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
 Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
 Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also experience in SSIS, created DTS package for data transfer between the two environments.
 Working knowledge in Clustering and Always on.
 Strong experience in mentoring team members and writing documentation