Contact : +91-958*******

Shivam Mehrotra

Mail Id: aboaua@r.postjobfree.com

DB2 UDB DBA

Professional Summary:

Have 2 years and 2 months of experience as production support DB2 DBA on

AIX, Linux and Windows.

Part of production support team handling production databases for India's

largest telecom firm. We support both single and multi-partition databases.

Some have size of over 150TB.

Technical Skills:

. Rich experience with DB2 UDB 9.1, 9.5 and 9.7 Installations,

Configurations and Administration with strong database programming

skills.

. Expertise in using DB2 Movement Utilities like Export, Import and

Load.

. Good Experience on Restore the Backup images using Redirect Restore

method from source server to destination server.

. Experience in replication technology that uses Log-based Change Data

capture (CDC)

to enable the continuous movement of data with minimal impact to

mission critical systems.

. Expertise in applying PATCHES (Fix Packs) on db2 servers.

. Good experience on HADR and HACMP setup lying between primary and

standby servers .

. Expertise in version migration from lower to higher versions.

. Good experience on DPF environment.

. Good knowledge on preparing purging policies and backup policies.

. Scheduling database backups in Backup scripts using Cron Jobs and

Scheduled Jobs.

. Experience in DB2 UDB Command Line Utilities like db2icrt, db2advis,

db2ckbkp etc.

. Expertise in creating Instances, DB2 databases, bufferpools,

Tablespaces as per client requirement.

. Good experience on monitoring archive mount points and data mount

points .

. Expertise in running REORG and RUNSTATS for better performance of the

database.

. Expertise in scheduling compressions on big tables and monitoring the

reorgs and runstats.

. Good experience on maintaining Database Level (DB CFG) and Database

Manager Level (Instance) Parameters.

. Experience in design and maintenance of databases, performance tuning

and troubleshooting.

. Expertise in performance health check and improvement of parameters on

OS level and storage level using like iostat, vmstat, sar, tprof,

lsattr, nmon, topas etc.

. Highly motivated team player with strong communication, analytical and

inter-personal skills.

Project Details:

Jan '11 - Present

Client: Bharti Airtel, India, Srilanka

DB2 UDB DBA.

Responsibilities:

. Production support experience with DB2 UDB 9.5 and 9.7 Installations,

Configurations, migrations and Administration.

. Performance tuning of databases.

. HADR & HACMP setup lying between primary and standby servers

. Restoring the Backup images using Redirect Restore method from source

to destination.

. Applying PATCHES (FixPacks) on db2 servers.

. Automating mundane tasks through scripting.

. Applying GSD on databases as per policy.

. DB2 UDB Command Line Utilities like db2icrt, db2ckbk,db2advis etc.

. Creating Instances, DB2 databases, bufferpools, tablespaces as per

client requirement.

. Running REORG and RUNSTATS for better performance of the database.

. Scheduling compressions on big tables and monitoring the reorgs and

runstats.

. Maintaining Database Level (DB CFG) and Database Manager Level

(Instance) Parameters.

. Increasing and Decreasing tablespace sizes using alter tablespace

command. And also added new containers to existing tablespace.

. Actively involved in designing and implementation of Database objects.

. Migration of servers from older versions to higher versions like from

db2 V9.1 to V9.7.

. Followed SNAPSHOT processes on connected users.

. Involved with the development team, and resolving problems related to

the database privileges, etc.

. Working on Data replication technology that uses Log-based Change Data

capture (CDC)

to enable the continuous movement of data with minimal impact to

mission critical systems

. Troubleshooting for various real time issues.

. Monitoring archive mount points and data mount points .

. Generating data definition language using DB2LOOK command from

existing database and creating the same objects in newly created

databases.

. Mentoring new members of the team and always looking for something new

and challenging.

Educational Qualifications:

B.Tech from Uttar Pradesh Technical University, India.

CERTIFICATIONS:

Certified under brain bench as a DB2 UDB programmer

Technical Qualifications:

Database DB2 UDB v 9.1.x,9.5.x and 9.7.x,

Languages SQL, Shell Scripting.

Operating Systems Red Hat Linux, Windows NT/2003/XP

Personal Details:

Date of Birth 15th November 1988

Gender Male

Marital Status Unmarried

Current Working Location IBM India Pvt. Ltd, Noida, India.

IBM certification DB2 9.1 Family Fundamentals IBM

(000-730) Associates

IBM certification DB2 9.1 LUW DATABASE ADMINISTRATOR IBM

(000-731)

Contact this candidate