We provide IT Staff Augmentation Services!

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 DBS 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.

Hire Now