Mudhasi Rehaman

Possessing around 5.5 years of experience with DB2 Database Administration. Proven ability in Analysis, Design and Performance tuning using DB2. Capable of working with various versions of DB2 UDB.

 Work experience of 5+ years on DB2 UDB Environment for various

clients providing all levels of support.

 Experience on HADR Failover and Failback activity and SAP

System refresh

 Experience with DB2 UDB 9.x and 10.x Installation, Configuration

and administration of databases.

 Migration from V9.7 and V10.1 to V10.5 of UDB databases.

 Installed and Configured HADR with TSAMP on Linux and AIX.

 Setup HADR among 4 servers( 1 Primary and 3 Standby systems).

 Worked on Fail over and Fail back tests in multi standby systems.

 Worked in Process-driven environment, by following processes

like problem management and Change Management

 Having an experience in handling production databases up to

12TB in partitioned environment.

 Experience on fix pack installation and un-installations.

 Experience on creating Instances, Databases and Database objects.

 Taking database Backups and recovering the database with Backup images.

 Good knowledge on SQL Performance tuning of SQL Queries and monitoring of database.

 SQL Tuning using db2advisor and db2explain tools.

 Configure and working on HADR environments. .

 Installed the db2client s/w binaries on application server and catalog the remote databases.

 Working with user group for any application change or maintenance or release.

 Raising PMRs and coordinating with IBM support team to resolve various database issues.