Service Sql Server

PROFESSIONAL SYNOPSYS:

A dynamic professional with 10+ years experienced in multiple roles not limited to Database Administrator, Team Lead and Solution Design.

Robust experienced in managing complex and large environment on MS SQL, Oracle and MongoDB.

Heuristic expertise in Installation of database products [MS SQL, Oracle, MongoDb], Database Upgrade, Migration, Implementing High Availability [Clustering, AlwaysON Availability Group, Replication, Mirroring, standby], Disaster Recovery, Security Patch, service pack upgrade, implementing third party database solutions and performance troubleshooting.

Insightful knowledge of implementing the new tools to monitor the database environment, Backup, Server Cost Control, Revenue Maximization from technical solutions.

Strong knowledge of Lean Methodologies [Global Delivery Framework, adopted by IBM] including Incident & Problem Management, Change & configuration Management.

Ample experience in Quality Assurance program, documentation of Root Cause Analysis, Post Mortem Reports, Technical Deep Dive and Continuous Service Improvements.

CAREER RECITAL:

Organization

Role(s)

Location

From

(Mon-YYYY)

To

(Mon-YYYY)

IBM Canada

Database Team Lead

Project Delivery Lead

Solution Designer

Calgary, AB, Canada

Sep – 2014

Till Date

IBM India

Database Team Lead

Database Administrator

Bangalore, Karnataka, India

Mar – 2010

Aug - 2014

Accenture

Database Administrator

Bangalore, Karnataka, India

Nov – 2009

Feb - 2010

Hewlett Packard

Database Administrator

Gurugram, NCR, India

Feb - 2008

Jun - 2009

TECHNICAL SKILLS:

DATABASE

MS SQL [2016, 2014, 2012, 2008, 2005 and 2000], MongoDB, Oracle 9i, Oracle 10g and Oracle 12c.

DATABASE BACKUP TOOLs

Data Domain, DDBoost, SnapManager for SQL, SQL BackTrack, Business Continuance Volume (BCV).

MONITORING TOOLs

SCOM, OEM, DPA [Ignite], NetIQ, Tivoli and IDERA.

OPERATING SYSTEM

Windows (2012 / R2, 2008 /R2, 2003, 2000) and Unix.

TICKETING TOOLs

ServiceNow, SAP CRM, Clarify, Maximo, ManageNow, and Impact.

STORAGE

NetApp and EMC.

OTHERs

SSIS, SSRS, SCCM and Powershell

PROFESSIONAL EXPERIENCE:

Suncor Sep 2014 – Till Date

http://www.suncor.com/about-us

DBA (Lead), Project Delivery Lead and SD

Responsibilities:

Managing offshore team from client location for the Operation and Project delivery. Handles priority issues & escalations.

Assisting to client for Database Solution Design.

Installation and post configuration of SQL Server [2016, 2014, 2012] with service packs and hot fixes on standalone / clustered environment, MongoDB [3.0, 3.2, 3.4] and Oracle [10g, 11g & 12c ]

Upgrades database [MS SQL, MongoDB and Oracle] from lower version to higher.

Setup replication [Transactional, Snapshot, Merge] across different workgroup, heterogeneous technologies, troubleshooting replication issues, configure Oracle standby database and RAC.

Configured AlwaysON Availability Group, Mirroring and clustering.

Setup Database Monitoring using the SCOM, OEM and NetIQ.

Patched Database servers using the SCCM.

Trouble shooting Performance issues by finding out the Resource bottlenecks like CPU, Memory, Disk IO, tempdb configuration, slow running queries, Index tuning.

Perform capacity planning of databases.

Installation & configuration of third party backup tool like EMC DDBoost and Database Performance Analyzer.

Perform Technical Deep Dive, Defect Prevention Program and applied methodology to reduce the number of incoming tickets.

Developed Disaster Recovery procedures and Participated in more than 20 disaster recovery exercise.

Involved in Security Audit and Implemented security solutions according to the project standards, participate in external auditing.

Lead and motivate to team to deliver the best in quality service to client. .

Conducts technical sessions, prepares technical steps for the changes & review the implementation steps prepared by the team.

Defining and implementing Backup / Restore strategies.

Configured and used Redgate tool to migrate the database objects and compare in case database collation change required.

Review the SLA of the incident tickets and ensure that there is no SLA hit.

Adhere with SOX & PCI compliance requirement and face third party auditor every quarter and make sure that we are complaint as per company's policy.

Installation of SSRS, SSIS, scale-out SSRS deployment.

Work with vendors / support teams such as Backup, Storage, Wintel and various application teams in to smooth out the service delivery process. Consult with application support team in order to gather the requirement while working on the Solution Design and for data migration to cloud.

Tuning of SCOM Management packs, created custom monitor and alerts for effective monitoring and alerting.

Create collection of Device, Software Group and Deploy Patches with SCCM.

Developed PowerShell script and T-SQL to gather the information about the servers in our environment, Smart Script for Database restore on regular basis, Smart Index Rebuild, script to generate the database restore script.

Performed Technical Deep Dive and lead continues service improvement plan to ensure the best in quality service.

Lam Research Jan 2012 – Aug 2014

https://www.lamresearch.com/company/company-overview

Production DBA

Responsibilities:

Installation and configuration of SQL Server [2012, 2008/R2] with service packs and hot fixes on standalone / clustered environment.

Upgraded SQL Service Pack, Security Patch, and version of SQL server.

Performed Database Migration from one server to another across the different versions.

Installation & configuration of third party tool like SnapDrive, SnapManager for SQL, SQL Backtrack.

Setup SQL Server Maintenance Plans for Backup, Index Rebuilding, Update Statistics and Database Integrity Check.

Prepare RCA, PIR in case if there is any high priority incident reported or change failed and make action plan for remediation.

Prepare Disaster Recovery Plan and participated during Disaster Recovery exercise or Disaster Recovery.

Setup log shipping, replication and mirroring.

Troubleshooting using native tools like SQL Profiler, Perfmon, system stored procedures, dynamic management views, and custom stored procedures.

Developed SQL scripts to monitor/audit all SQL Servers and scripts for server-side traces.

Enabled the AWE on the SQL Server and PAE Switch in the boot.ini file which would allow more memory to SQL Server which would result in improving the performance of SQL Server.

Patriot Coal Mar 2010 – Dec 2011

Production DBA

Description:

Patriot Coal is a producer and marketer of coal in the eastern United States, with operations and coal reserves in Appalachia and the Illinois Basin.

Responsibilities:

Upgraded legacy version of the SQL server to newer version of the database and migrated database.

Monitored alerts and take appropriate action.

Create user and grant required permission, fix orphan user, migrate user from one server to another.

Backup of the database, refresh/restore the database.

Configuring database mirroring and troubleshooting mirror related issues.

Involved in internal and external Security Audit and addressed CIRATS.

Assisted during regular Windows patching.

Create database, setup maintenance plan and configure SQL server as per industry standard.

Performed capacity planning of databases, participated in Disaster Recovery exercise.

Hewlett Packard Feb 2008 – Jun 2009

http://www8.hp.com/ca/en/hp-information/index.html

Production DBA

Responsibilities:

Setup maintenance plan for Backup, Index Rebuild, Update Statistics, Database Integrity check and custom job.

Upgraded SQL service Packs, applied Security & Cumulative Updates, PSU patches.

Developed various scripts to ease the day to day DBA's work.

Take adhoc hot / cold backup of Oracle database manually and restore / refresh as per client's request, user creation and troubleshooting access issue.

Dealing with the space management issues for the Oracle databases, dealt with archive file, created restore point.

Cloning of database for test and development purposes.

Refreshing development/test database from production using Export/import

Perform regular processes (e.g. weekly data refreshes, run data fix scripts) in an accurate and timely manner.

Generated reports from the database using PL/SQL and SQL.

Created Oracle database on 9i R2, reorganization procedures, scripted database alerts, and monitored scripts.

Oracle database health check, Diagnose and monitoring alert log files.

Creating profiles, password check functions, roles, defining default storage parameters for the tablespace, checking the init.ora parameters.

EDUCATION:

MCA in 2006 IGNOU, Delhi, India.

BCA in 2003 MCRPV, Bhopal, India.

ACHIEVEMENTs & AWARDs:

Received Award for Client Value Recognition in IBM.

Received IBM Best Automation Award.

Received IBM Best Jazz Award for the individual contributor.

Implemented SCOM, Database Performance Analyzer in our environment.

Deployed Data Domain Boost for Database backup optimization.

Participated 20+ Disaster Recovery Exercise.

TRAININGs & CERTIFICATIONs:

MongoDB training in IBM.

ITIL V3 Foundation Certification.

Microsoft Certified IT Professional (MCITP).

Microsoft Certified Technologies Specialist (MCTS).

Oracle Certified Associate (OCA).

PERSONAL DOSSIER

Name: Gulab Chand Chauhan

Date of Birth: 20-Aug-1981

Eligible to work in Country: Canada [Permanent Residence], India

Address: Suite# 814, 815 4th AVENUE SOUTH WEST CALGARY ALBERTA CANADA T2P3G8

Email: **.*******@*****.**.**

Contact#: +1-403-***-****

Linkedin Profile: linkedin.com/in/gcchauhan

Contact this candidate