Azher Rehman

Experience

• 

  HSBC

  Feb 2013 - Dec 2017

  Assistant Manager

  * 4 years 10 month of experience in UDB DB2 Database Administration * Rich experience with DB2 UDB 9.7, 10.5 and 11.1 Installations. * Good experience with Infosphere Change Data Capture (CDC) and Infosphere Optim Performance Manager (OPM) Installation and Troubleshhoting. * Set up and installation of INFOSPHERE CDC to start replication between two databases. * Taking database Backups and recovering the database with Backup images. * Good experience of installation, setup and troubleshooting of DB2 Federation. * Good Experience on Restore the Backup images using Redirect Restore method from source server to destination server. * Expertise in applying PATCHES (Fix Packs) on db2 servers. * Experience in DB2 UDB Command Line Utilities like db2icrt, db2advis, db2ckbkp......etc. * Expertise in creating Instances, DB2 databases, bufferpools, Tablespaces as per client requirement * Experience in migrating DB2 UDB 9.7 to 10.5 and 11.1 Database and creating the same objects in newly created databases. * Having good knowledge in running REORG and RUNSTATS for better performance of the database. * Good experience on maintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters. * Motivated team player with strong communication, analytical and inter-personal skills. * Experience in raising PMRs and taking follow up with IBM team to help resolve the issues. Show less

• 

  Rolta India Limited

  Dec 2017 - Jan 2019

  Software Lead Engineer

  As a DB2 DBA, i am responsible for:Creating database design and architecture documentCreating an R&D setup for internal teams.Creating sizing document for all DB2 Servers.Installing, configuring and maintaining all DB2 servers in Test, Development and Production servers.Production Support for all DB2 related applications on 24X7 basisDesigned Implemented and supported databases as well as Custom developedDatabase Performance monitoring, tuning and capacity planningBackup Planning and RecoveryObject Creation/alteration and Granting accessObject / Data Migration from one DB2 subsystem to anotherRunning Offline/Online utilities for data maintenanceResync of Subsystems on two different machinesImparting training to the Application Development TeamConfiguring and maintaining a 2 node PowerHA cluster on DB2 Production servers.Coordinating with all teams for creation of deployment documentsHelping application teams in installing Installation Manager, Websphere, Portals, Mobililty, Collaboration and other application software.User creation on AIX servers for DB2 and applications.HADR creation for all Databases in all Database servers. Show less

• 

  Wipro

  Mar 2019 - now

  Team Lead