Pardeep Kumar Email & Phone Number

Microsoft Certified Professional around 8 years of experience in SQL Database Administration, Development and Support with track record of successful implementationsTechnical Expertise/Specialties: Installation, Configuration, Upgrade and Migration of SQL Server 2005, 2008, 2008R2, 2012, 2014 and 2016. High Availability & Disaster Recovery Strategies (Clustering, Always On, Log Shipping, Replication & Mirroring) Maintenance Plan and SQL Agent Jobs Strategies (Backups, Index Rebuild and Reorganize, Purge Criteria Setup, Database Email and Alerts) Proactively monitor all database server such as SQL Jobs, Blocking, Deadlocks, Disk, CPU, Memory and take the necessary action if required. Extensively implemented and worked on latest techniques in SQL Server such as ColumnStore Index, Query Store, In Memory OLTP. Query Optimization and Performance Tuning with help of Execution Plan, Extended Events, SQL Profiler, Performance Monitor and DBCC Commands. T-SQL Programing (Creation, Modification, Migration of Tables, Stored Procedures, Views, Indexes, Triggers and Functions). Data movement from one server to another with Import/Export Tool, SSIS Packages and BCP Commands. Resolve the performance issues either by Query Tuning, Proper Indexing, Table Partitioning OR server upgrade RAM, CPU, Disk. Capacity planning for migration or new database projects in terms of batter performance and cost effective environment. Managing SQL Security and Object permissions like database authentication modes, creation of users, configuring permissions and assigning roles to users. Creation of proper RCA (Root Cause Analysis) of various Incidents/Problems and their solutions. Complete understanding of ITIL tools used for Incidents, Change Request & Problem Management to resolve tickets based on priorities to meet the tight SLA. 24/7 on calls and weekend support for production servers.

Listed skills include Requirements Analysis, Sql Dba, Disaster Recovery, High Availability, and 12 others.