DBA Resume

PROFESSIONAL SUMMARY:

Having 4 years of IT experience as DBA on DB2 LUW.
Good experience working on DB2 UDB 9.x, 10.xInstallation, Configuration and Administration well versed working with production.
Expertise creating and maintaining of Tablespaces.
Worked heavily with data movement utilities Export, Import, Load and Db2move.
Good expertise in configuring Online/Offline backups for database as required storage expertise on DB2Backup/Recovery strategies.
Hands - on Expertise in Recovering the DB’S usingRestore/Redirect Restoreand cross node recovery.
Troubleshooting database issues using db2diag, db2pd, db2mtrk along with Snapshot and Eventmonitoring tools.
Expertise in using Run stats,Reorgchkand Reorgs to enhance application performance.
Granting/Revoking various authorizations to different users/groups, Handling incident/problems tickets and meeting the SLA’S.
Hadling experience in shell scripting and query management.
I can work individually and in a team, posse’s good verbal and written communication and interpersonal skills.

TECHNICAL SKILLS:

Database: DB2 LUW V9.x, V10.x.

Operating System: UNIX, Linux, Windows 2003/NT.

Languages: UNIX, Sql.

EXPERIENCE SUMMARY:

Confidential

Environment: DB2 UDB V9.7/10.1

DBA

Responsibilities:

Worked on setting IBM DB2 LUW V9.7, V10.1 installations and cataloging the database.
Tablespace management adding, resizing, dropping, extending and reducing the tablespace containers.
Scheduling the backup and database restores including stage development environment as per user request.
Used RUNSTATS,REORGCHK and REORG to enhance application performance monitoring buffer pool hit ratio. Extensively used data movement utilities like export, import and load.
Configured HADR setup lying between primary and standby servers.
Applied PATCHES (Fix Packs) on db2 servers.

Confidential

Environment: DB2 UDB V 9.5/9.7/10.1

DBA

Responsibilities:

Worked on setting IBM DB2 UDB ESE V9.5, V9.7 and V10.1Installations and cataloging the databases for client people.
Table space management includes Adding, Dropping, Extending, Reducing and resizing table space containers.
Online and offline backup of database and Table spaces level Backup.
Database restores including redirected Restores production, stage and development environment as per user request.
Scheduling backups used contab.
Used RUNSTATS,REORGCHK and REORG to enhance application performance monitoring buffer pool hit ratio. Extensively used data movement utilities like export, import and load.
Applied PATCHES (Fix Packs) on db2 servers.
Configured HADR setup lying between primary and standby servers.
Finding log running SQL’S and tuning them with the help of application team.
Maintaining ticketing queue and responding to user’s requests.

Confidential

Environment: DB2 UDB V 9.7/10.1/10.5

DBA

Responsibilities:

Worked on setting IBM DB2 UDB ESE V9.5, V9.7 and V10.1Installations and cataloging the databases for client people.
Provided the support for DB2 Movement Utilities like Export, Import and Load.
Taking database Backups and recovering the database with Backup images.
Had done somany redirect restores from source server to destination server.
Applied PATCHES (Fix Packs) on db2 servers.
Configured HADR setup lying between primary and standby servers.
Monitoring DPF systems like paging, table spaces, compressions, loads.
Prepared so many scripts for purging policies and backup policies.
Involved in Retribution Activities on so many databases.
Created Instances, DB2 databases, buffer pools, Table spaces as per client requirement.
Provided good support for better performance of the database using REORGS and RUNSTATS.
Scheduling compressions on big tables and monitoring the reorgs and Run stats.
Involved with the development team, and resolving problems related to the database privileges, etc.