Ashok Kumar

About Ashok Kumar

An assertive and dependable IT professional working actively as a SQL server Database Administrator. I have established myself as a key contributor in the products and architecture of applications supported, building new servers and implementing High-Availability options.Specialties- Hands on Experience in installing, configuring, creating, managing, monitoring, and troubleshooting SQL Server 2005, 2008, 2008R2,2012, 2014 and 2016 databases in both Physical and Virtual environments, Implemented and maintaining Always ON, Windows clustering, SQL server clustering, Mirroring, log shipping, Replication High-Availability options. 50 servers downgraded from Enterprise to standard, versions 2008R2,2012,2014. Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes and table partitioning.Administer security- roles, logins & access and manipulating schemas, tables, views and indexes, managing core operations with automated routine tasks, Plans and perform backups and recovery along with monitoring and tuning performance.

Experience

1. Sql Server Database Administrator (Technical Specialist)

   NTT DATA North America

   Dec 2013 — Present

   I am Working as a Infrastructure Database administrator and SQL Server Database Administration experience in PRD,ACC,INT and DEV environments Hands on Experience in installing, configuring, creating, managing, monitoring, and troubleshooting SQL Server 2005, 2008, 2008R2,2012, 2014,2016 and 2017 databases in both Physical and Virtual environments. Good exposure with SQL Server High Availability and Planning Disaster Recovery strategies Implemented windows clustering on Windows servers 2008,2008R2. 2012,2012R2 and 2016 implemented SQL server Alwayon on SQL servers versions 2012,2014 and 2016. Also, Added SSISDB to Availability group in SQL Server 2016 Good experience with implementing DR solution, High Availability of database servers using Database mirroring, Replications and Log Shipping. Experience in applying SQL server service packs, Cumulative Update and security update in standard alone servers, cluster servers, Alwayon and High availability configured servers to keep the database at current patch level. 50 servers downgraded from Enterprise to standard, version 2008R2,2012,2014. Experience in using Performance Monitor, SQL Profiler, extended events, activity monitor and optimizing the queries, tracing long running queries, blocking and deadlocks. Worked on SQL Server 2017, 2016,2014 migration from SQL Server 2005,2008,2008R2 and 2012. Worked on SQL server 2016,2014, 2012 in-place upgradation from SQL Server 2005,2008,2008R2 and 2012. Having Experience on handling Huge databases(VLDB). Experience for handling tickets related to blocking, deadlock and critical performance issues. Refreshing the Test,Dev,int and Acc environments with production data whenever required Very good experience in third-party tool configuration Idera, redgate, commvault and sitescope Having very good knowledge on Supporting SAP application\\SharePoint (SAP CRM, SAP Basis and SAP ABAP)

Education

• Lowry Memorial College, No 1603, Dooravani Nagar, Bangalore-16

  Lowry Memorial College

  2006 — 2009

Skills

• Microsoft Sql Server
• Sql Server Integration Services (Ssis)
• Sql Server Reporting Services (Ssrs)
• Ssas
• Windows Clustering
• Sql Server Clustering
• Sql Server 2016 Always on
• Sql Server 2016 (Standard Version) Alwayson
• Mirroring
• Logshipping
• Replication
• Sql Dignostics Manager (Idera)
• Commvault
• Sql Server Performance Turing
• Litespeed
• Sitescope
• Redgate
• Vmware
• Vmware Vsphere
• Sql Server Management Studio