DB2 UDB DBA

VYSAKH ANTO

PuthenPurakkal House,

Aikya Nagar, Nadathara P.O,

Thrissur-680751, Kerala

India

Tel : +91-944*******(Mob) / +91-963*******(Mob)

Email: acxdrl@r.postjobfree.com / acxdrl@r.postjobfree.com

OBJECTIVE

IBM Certified Database Administrator-DB2 for LUW, with SAP support background and working knowledge of HADR, TSA, HACMP, DR, DPF, TSM interested in working on DB2 Database Support Projects, with valid H1B Stamped Visa and 5 years of experience.

SUMMARY

Experienced in administering, implementing, upgrading, troubleshooting issues on IBM DB2 databases on UNIX, Linux and Windows(5 years) from both onshore and offshore.

Currently supporting offshore operations for one of the world’s leading Healthcare Provider(Client) with over 300 servers hosting single and multiple instances with 650+ DB2 LUW databases.

COMPUTER SKILLS

Operating System :

AIX, Linux, Windows

Tools :

DB2 for LUW V9.1/9.5/9.7/10.1/10.5

Infosphere OPM

Toad for DB2

Service-Now

TSRM

Borland StarTeam

HP Service Manager 7/9

SAP GUI

Foglight for DB2 (FMS & FPA)

IBM Database Encryption Expert(DEE)

MS Office

Languages :

Unix shell script (perl/shell), C, C++, Java

EDUCATION

CALICUT UNIVERSITY (JYOTHI ENGINEERING COLLEGE, Kerala, India)

Bachelor of Technology - COMPUTER SCIENCE AND ENGINEERING(2007 – 2011)

BHARATIYA VIDYA BHAVANS VIDYA MANDIR, Kerala, India

India Senior School Certificate Examination (Class XII)-(2007)

BHARATIYA VIDYA BHAVANS VIDYA MANDIR, Kerala, India

All India Secondary School Examination (Class X)-(2005)

TECHNICAL QUALIFICATION

Certifications:

ITIL (2011) Foundation Certified : Jan,2015

IBM Certified Database Administrator – DB2 10.1 for Linux, Unix, and Windows : Dec,2013

www.ibm.com/certify//profile?antov

IBM Certified Database Associate – DB2 9 Fundamentals : Dec,2012

Trainings:

IBM DB2 LUW Administration for SAP

IBM Innovation Center, Bangalore, India

IBM DB2 BLU

WORK EXPERIENCE

Designation Company Period

DB2 UDB DBA UST Global, Trivandrum April 2015 – Present

DB2 LUW DBA for SAP UST Global, Trivandrum October 2013 – April 2015

DB2 LUW DBA for SAP UST Global, Mexico July 2013 – October 2013

DB2 LUW DBA for SAP UST Global, Trivandrum December 2011 – June 2013

PROJECT HIGHLIGHTS

ANTHEM DATABASE SUPPORT (APR 2015 – PRESENT)

RESPONSIBILITIES :

Administer DB2 subsystems in Production, Perf, UAT, SIT and Development for both DPF and non-DPF environments

Oncall support (24 * 7) – Primary and Secondary

Create Database, instance, tablespace

Create Tables, indexes, triggers, stored procedures in dpf/non-dpf

Performance Monitoring and SQL tuning (db2explain, db2advis)

Review and carry out DB2 full backup (online/offline), DPF backup, tablespace backup using TSM

Backup and Restore Databases using TSM

SP migration to higher environments

Paging Space monitoring and troubleshooting

Grant/Revoke privileges at DB/Object level

Table/Tablespace/object-level consistency checks

Audit Remediation and report preparation

HACMP, HADR issue resolution

Monitor filesystems/mountpoints for data/log/temp and increase when needed.

DB2 Fixpack installations.

DB CFG, DBM CFG tuning.

Fenced ID changes

Data maintenance using LOAD,IMPORT,EXPORT,REORG,RUNSTATS

Unix patching support

Troubleshooting issues related to Database, CPU, IO, Memory

Create Change Tasks and Tickets (Normal/Emergency) as required (SNOW).

Create and Respond to tickets (SNOW) – assign and resolve within documented SLA times based on priority of the incident

Create and Respond to Work Orders through TSRM

Respond to emails – non-incident requests, non-incident alerts, alert updates, cross team communications, customer communications, vendor communications, follow up emails.

Tools :

DB2 for LUW V9.5/9.7/10.1/10.5

Infosphere OPM

Service-Now

TSRM

MS Office

PEPSICO DATABASE SUPPORT (DEC 2011 – APR 2015)

RESPONSIBILITIES :

Administer DB2 subsystems in Production, Pre-Prod, Quality, Development, Sandbox and TechSandbox

Oncall support – Primary and Secondary

Create Database, instance, tablespace

Review and carry out DB2 full backup (online/offline), volume group backup, archive log backup using native DB2 commands/NETBACKUP/TIMEFINDER.

Monitoring the tablespace utilization and preparing reports, increase maxsize.

Estimate tablespace savings and schedule/execute OTMs to recover space when needed.

Monitor filesystems/mountpoints and increase space when needed.

Vendor interface and problem solving using IBM PMR and SAP OSS Message.

Database copies –prod to Quality, Quality to Dev, Dev to Sandbox, etc

Standby database refresh – copy primary to standby for HADR.

Break HADR and Re-integrate HADR

DB2 Fixpack installations.

DB2 V10 upgrades.

Index Analysis and recommendation.

Schema Comparison using TOAD.

DB CFG, DBM CFG tuning.

Archival/Circular logging changes.

Data maintenance using LOAD,IMPORT,EXPORT,REORG,RUNSTATS

Support vendor software upgrades – SAP and Unix patching

Troubleshooting issues related to Database, CPU, IO, Memory

Disaster recovery testing

Create TABs and RFCs(SM9)as needed – attend various meetings to represent it.

Respond to tickets – assign and resolve within documented SLA times based on priority of the incident.

Respond to security violations - research and resolve.

Take care of Guardium Security failures and resolve from DB end.

Respond to emails – non-incident requests, non-incident alerts, alert updates, cross team communications, customer communications, vendor communications, follow up emails.

Tools :

DB2 for LUW V9.1/9.5/9.7/10.1

Toad for DB2

Borland StarTeam

HP Service Manager 7/9

SAP GUI

Foglight for DB2 (FMS & FPA)

IBM Database Encryption Expert(DEE)

MS Office

PERSONAL DETAILS

D.O.B : 27-11-1989

NATIONALITY : INDIAN

Contact this candidate