Sql Server Information Technology

Deepak Kumar

SQL DBA Consultant [SQL ****/****- MCITP DBA & Dev Track, ITIL

-V3, SQL

****-*****]

Location

Dallas/Fort Worth Area

Industry

Information Technology and Services

.

Deepak Kumar

Contact Deepak Kumar directly

Deepak Kumar's Overview

Current

SQL DBA Specialist & Consultant at SQLKnowledge.com

Past

SQL DBA & Database Architect at IT company

Associate Manager - SQL DBA (Databases) at Kale Consultants Ltd

SQL DBA - Database Specialist at --

Education

Amity Business School

Delhi Vishwavidyalaya

NIIT

Delhi University

see less

see all

Recommendations

20 people have recommended Deepak

Connections

500+ connections

Websites

Personal Website

RSS feed

Portfolio

Deepak Kumar's Summary

Currently enjoying SQLized life working on some special, highly demanding & critical

database project(s) for most of SQL Server DBA related requirements. Open for more

challenges & projects that can force to deliver best out of me!

Got Something

? Contacts:

Phone: +1(858)NeedDBA, +1-858-***-****

Email me on: **********@*****.***; **@************.***

Profile: https://www.facebook.com/SQLServerDBA

Twitter: @deepakontheweb, @sqlwiki, @sqlknowledge

Having 11+ years experience in Microsoft SQL Server Database Administrator & Consultancy

on SQL Server 2012, 2008, 2005, 2000, 7.0, 6.5 versions; managing databases ranging from

GBs to TBs in size.

- MCITP - Microsoft SQL Server 2008 [DBA & Developer Track]

- MCITP - Microsoft SQL Server 2005 [DBA & Developer Track]

- MCDBA - Microsoft SQL Server 2000 [Certified since 2003]

- Microsoft SQL Server MVP: Year 2006-07

- Microsoft SQL Server MVP: Year

2005-06

- ITIL V3 Foundation Certified

- PMP Trained; PMI Member -Delhi Chapter

- MBA - IT from Amity University

- Oracle 9i DBA Track training for Fundamental 1 & 2

Specialties

. MS SQL 2012, 2008, 2005, 2000, 7.0 DBA on VLDB Environment

. Production Database Support, Troubleshooting and 24*7 oncall

. Performance tuning SQL profiler, Query Execution plan

. Finding & Tuning SQL Server hardware Bottlenecks

. Business Continuity Planning & DR Setup

. SQL Server HADR or Always On

. SQL Clustering, Replication, Log Shipping, Mirroring

. SQL Version upgrade, Server migration -InPlace/SideBySide

. SQL Server Consolidation & Virtualization

. SQL Server Remote DBA Expert

Deepak Kumar's Experience

SQL DBA Specialist & ConsultantSQLKnowledge.com

Information Technology and Services industry

October 2007Present (5 years)

SQL Server DBA 7.0; 2000; 2005; 2008; 2012 Production Support [24*7*365]

SQL HADR (installation, configure and maintenance)

SQL Server Clustering

SQL Server Log Shipping

SQL Server DB Mirroring

SQL Server Replication

SQL Server Virtuatlization & Consolidation

SQL Server Hardware sizing and bottleneck tuning

SQL Server Migration Expert for inPlace & Side By Side.

SQL Server Performance Tuning Execution plan, Profiler, Perfmon

SQL Server Backup/Restore & Disaster Recovery Setup

SQL Server Installation, Version Upgrade & Architect Setup

SQL Server Capacity Planning, Trouble Shooting, Maintenance

SQL Server Database Archiving, Testing & Consultation

SSIS, Business Intelligence Projects, SSRS - Reporting Services

SAN, NAS, 3rd Party backup and monitoring solution

Experienced in managing Routine Tasks for DB2 DBA, Oracle DBA, Sybase DBA & MySQL DBA

SQL DBA & Database ArchitectIT company

Public Company; 10,001+ employees; WNS; Outsourcing/Offshoring industry

October 2006October 2007 (1 year 1 month)

Worked as Database Architect for First Magnus Financial Corp at Tucson, (AZ) USA.

Managing DBA team and projects(s), worked onsite & offsite to meet project requirement:

SQL Server DBA Production Support - Finance Domain [24*7*365]

SQL Server Clustering, Log Shipping

SQL Server Replication & DB Mirroring

SQL Server Performance Tuning Extensively worked upon

SQL Server Business Intelligence OLAP

SQL Server Integration Services (SSIS)

SQL Server Backup/Restore & Disaster Recovery.

SQL Server Setup, Upgrade & Architect Setup

Team Management, Client interaction, Consulting & Reporting.

Associate Manager - SQL DBA

(Databases)

Kale Consultants Ltd

Public Company; 1001-5000 employees; Information Technology and Services industry

November 2004October 2006 (2 years)

Worked with Kale Consultants http://www.kaleconsultants.com as Associate Manager

Database Administration for European clients at BCD Travel (http://www.bcdtravel.com).

Managed DBA team and client projects(s), worked onsite & offsite to meet project

requirement:

As Database specialist:

Production database support for SQL 7.0; 2000; 2005 DB Servers

Implementing SQL Clustering, Log Shipping, SQL Database Mirroring, SQL Replication

Performance Tuning, Stress Testing & Capacity Planning

Backup/Restore & Disaster Recovery Setup

SQL Installation, Upgrade, Maintenance & Architect

Defining guidelines & implementing SQL DBA best practices

Creating and implementing security and patching policy

Providing support to high severity SQL incidents.

As Functional Consultant for various Projects:

Setting Server & Storage hardware benchmarking for new DB Servers & Projects.

SQL Server Upgrades/Migration from SQL Server

7.0/2000 to 2005

New Setup/Installation or database server migration & High availability Setup

Defining SQL Support SLA for new and upgraded SQL Servers.

Setting High/Mid/Low level SQL monitoring

SQL DBA - Database Specialist

--

October 2001August 2004 (2 years 11 months)

1. Worked with Wipro InfoTech - Gurgaon H.R - India

2. Worked with GE Countrywide - Delhi DL - India

3. Worked with NIIT Ltd. - Delhi DL - India

Database Monitoring & Daily production DBA Tasks (24*7*365)

T-SQL Development, Data Mining, Report creation

Monitoring SQL Servers performance

SQL Server Query optimization and performance tuning

Business Continuity planning and Disaster Recovery Implementation

Security Audit, Stress Testing & Growth planning of db's 400GB+

SQL Server Replication

Backup (SQL/Legato) and Restoration/Maintenance of Databases.

Responsible for managing high-end SQL database servers for Insurance, operations and

development databases.

Worked with high end IBM Blade Servers, X445/440/342 series Virtual server (VMware)

technology, SAN & NetApp NAS.

Deepak Kumar's Courses

masters, Master of Business Administration (MBA): Information Technology

Amity Business School

Master of Business Administration - Information Technology

Deepak Kumar's Honors and Awards

MVP (Most Valuable Professional) - Microsoft SQL Server

Microsoft

January 2005

Microsoft SQL Server MVP: Year 2005-06

MVP (Most Valuable Professional) - Microsoft SQL Server

Microsoft

January 2006

Microsoft SQL Server MVP: Year 2006-07

Deepak Kumar's Certifications

MCDBA - SQL Server 2000

Microsoft

MCITP - SQL Server 2005 (Development)

Microsoft

MCITP - SQL Server 2008 (Development)

Microsoft

MCITP - SQL Server 2008 (Administration)

Microsoft

MCITP - SQL Server 2005 (Administration)

Microsoft

ITIL - V3

Deepak Kumar's Skills & Expertise

SQL DBA

Microsoft SQL Server

SQL Server 2000-2008

SQL Server

Database Administration

Database Management

SQL Server 2005/2000

SQL database design

Performance Tuning

Performance Improvement

Disaster Recovery

Databases

Database Security

Log Shipping

Mirroring

SSIS

Clustering

Replication

Capacity Planning

Virtualization

SQL Profiler

SSRS

T-SQL

Database Design

ETL

SSAS

Data Modeling

Data Migration

Data Warehousing

High Availability

Relational Databases

Business Intelligence

Database Development

Stored Procedures

SQL

Sybase

OLAP

Analysis Services

RDBMS

SQL Tuning

Database Analysis

Software Consulting

Database Consulting

sql server 2012

sql server always on

sql server hadr

Query Optimization

Query Tuning

query execution plan

Data Mining

View All (50) Skills View Fewer Skills

Deepak Kumar's Education

Amity Business School

masters, Master of Business Administration (MBA): Information Technology

20092010

Major: Information Technology;

Minor: International BusinessActivities and Societies: www.amity.edu

Delhi Vishwavidyalaya

Certificate Course, Language: Persian

2000 2001

One year certificate course in Persian language

Activities and Societies: http://www.du.ac.in/

NIIT

Diploma, Software Engineering

20002001

18 months Advance Diploma in Software Engineering from NIIT Model Town 3, Delhi INDIA

Activities and Societies: http://www.niit.com

Delhi University

Degree, Economics, Pol Science

19941998

Arts Graduate from University of Delhi INDIA

Activities and Societies: http://www.du.ac.in/

Deepak Kumar's Additional Information

Websites:

Personal Website

RSS feed

Portfolio

Interests:

environment Performance Tuning, High Availability & DR Setup

Groups and Associations:

http://sqlknowledge.com Profile: https://www.facebook.com/SQLServerDBA

Microsoft Most Valuble Professionals

PASS Professional Association for SQL Server

SQLDBA

SQLKnowledge

SybaseGuru

Honors and Awards:

Microsoft SQL Server MVP: Year 2006-07

Microsoft SQL Server MVP: Year 2005-06

Contact Deepak for:

Contact this candidate