Sr Developer/DBA

Vidya K Nagaraj

IBM Certified, DB* UDB Database Administrator

(Mobile: 91-962*******, email: *****.***@*****.***)

Career Summary

________________________________________

Have total experience of 4+ years specifically on database administration including UDB on midrange servers.

Currently working as DBA with IBM Bangalore. My role includes database administration support and performing business as usual changes as per the requirements on production, development, model and QA environments.

Education and Certification________________________________________

Bachelor of Engineering [Information Science]

IBM Certified DB2 UDB V8 Database Administrator for Linux-Unix-Windows

Work Experience

________________________________________

DB2 UDB Database Administrator, IBM ITD-GD India Pvt. Ltd., Bangalore, Jul 2007 – till date.

Technical Expertise

________________________________________

Hardware:

IBM eServer pSeries, RS/6000, POWER, SPARC, S390

Operating Systems:

OS390, IBM AIX 5.x, SuSE Linux, Windows

Databases:

DB2 UDB V7/8/9/9.5 (Linux, Unix, Windows)

DBA Tools:

CA – Platinum tool

Autosys – Scheduling tool

BMC ProActiveNet – Monitoring tool

Storage:

Tivoli Storage Manager – Backup/Archive (BA) Client

ITSM Tools:

Service-Now

Peregrine Change Management tool

ARS Remedy User V 4.00.03

PVCS – Version control tools

ManageNow R1

CPMA V1.R2.M1

Conceptual knowledge:

DB2 UDB Data Partitioning Feature (DPF)

ETL Tools - Datastage

Application Server – Web sphere Application Server V6.x

Technical Experience

________________________________________

Patching - Fixpak installation .

Communication – DB2 UDB Server Client communication configuration both by db2ca, manual and export/import of profiles.

Instance management – Starting, stopping, creating, dropping instances.

Security – Setting authentication, authorization and granting/revoking privileges on database objects to users/groups.

Table space management – Adding, dropping, extending, reducing and resizing table space containers.

Performance Tuning – Buffer pool tuning, configuration parameters tuning for optimal functionality.

Index Tuning – DB2 Design Advisor.

DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS, REBIND.

DB2 Explain Facility.

Troubleshooting Tools – db2diag, db2trace, db2dart, db2inspect, db2support, db2pd.

Database Monitoring – Snapshot monitors and Event monitors.

Database Cloning – Across same platform using Redirected Restore, different platform using db2look and db2move.

Data movement utilities – Export, Import and Load.

Logging Strategy – Configure database logging for performing hot/cold backups.

Storage – Setting up TSM Backup-Archive (BA) client for database backup’s and log archive.

Backup – Hot/Cold database, table space, full/incremental backups to disk or TSM.

Recovery – Full database recovery and roll forward recovery to end of logs for no transaction loss or to specific point in time recovery.

Problem/Change Management using ManageNow R1, CPMA and Remedy User tools

Application Server Administration – Starting, stopping and user administration.

Project Summary

________________________________________

1. IBM e-Business Hosting Services (Arcadia, Debenhams, O2)

Environment : AIX V5.x, DB2 UDB ESE V8.2, AIX HACMP 4.3/V5.1

IBM Tools : IBM ManageNow R1, CPMA V1.R2.M1-Problem/Change Management

2.IBM Paloma (RSA, BBG Group)

Environment : Windows2003/AIX V5.x, DB2 UDB ESE V8.2, DB2 Connect

IBM Tools : ARS Remedy User V 4.00.03 – Problem/Change Management

Roles Performed as a DB2 UDB Database Administrator in IBM:

Performing business as usual changes as per the change request raised by teams.

Handling problem tickets and meeting the SLA’s.

GSD331 health checks on database and tracking down APARS and CIRATS opened for the same by health checking team.

Database daily checks and backup checks using recovery history file and backup logs.

Database Trend analysis.

Table space capacity planning and monitoring.

Performance tuning – Executing REORG and RUNSTATS scripts supplied by AMS team.

HACMP fail over testing for Database and applications availability – rotating resource group cluster.

Deadlock monitoring and forcing down application.

Mainframe connectivity checks on DB2 Enterprise Connect.

Monitoring buffer pool hit ratio.

Documentation - Create and maintain documentation for standard procedures.

Accomplishments

________________________________________

Service Improvement Activity - GSD331 Health check automation and Daily check’s automation using korn shell scripting.

Corporate Trainings

________________________________________

• IBM Corporate Training on AIX System Administration basics, DB2 UDB Enterprise Server Edition Administration on Linux, Unix, Windows, Nov 2005 – Mar 2006

• IBM Corporate Training on DB2 Partioning Aug 2009

Spoken Languages

________________________________________

Kannada – Mother tongue

English – Fluent

Contact this candidate