• Creation and Administration of Instances, Databases, Bufferpools and Tablespace
• Configuring database backups to TSM
• Server/client environment setup, Catalogue instances & DB’s
• Resolving Transaction log file issues
• Resolving Dead lock issues
• Perform recycle process when database down/crash/Hung
• Backup and Restore of Table Spaces and Databases
• Recover data to a prior point in time using ROLLFORWARD command
• Performing data maintenance utilities like REORGCHECK, REORG and RUNSTATS
• Performing data movement utilities like EXPORT, IMPORT, LOAD and DB2LOOK
• Monitoring DB2 Activities using Db2pd, Snapshots & Event monitors
• Monitor databases and make adjustments to improve performance of databases or applications that use the data
• Monitor ongoing utility processes
• Setting various DB and DBM level configuration parameters
• Performing redirect restore between different servers
• Bring back various pending states like Roll forward pending, backup pending, Load Pending, Check pending & Reorg Pending States to normal
• Granting/Revoking privileges on DB2 objects
• Participated in application and database production releases
• Preparation of Design Specification Documents
• Performing Installation of DB2 , up-gradation (Fix-pack Installation) and configuration
• Create and modify databases and database objects as per application requirement
• Performing Database backup & recovery (offline & online backups – Full, Incremental & Delta Incremental)
• Database monitoring (free space in tablespaces, Snapshots, event monitor outputs etc.)
• Managing Database user privileges (granting & revoking permissions after proper Analysis & approval)
• Moving the data between servers by using EXPORT, IMPORT, LOAD, db2move utilities
• Updated the DBM and DB configuration parameter as per requirement
• Performed maintenance activities like REORG, REORGCHK, and RUNSTATS
• Performed database troubleshooting Using db2diag,db2top utilities
• Creation of Tables and Table Spaces, Views, Indexes.
• Managing the disk space capacity and space issues related with SMS & DMS Table spaces.
• Alter Tables and added Check Constraints and Referential Integrity to data in Tables.
• Granting / revoking various authorizations to different Users/Groups.
• Updating parameters of Databases using db2 commands like DB CFG, DBM CFG.
• Performance tuning on SQL queries access using Visual Explain.
• Monitoring and optimizing the performance of the database through Runstats and Reorgs.
• Backup and Recovering Database, Archival Logging, Circular Logging Backup database.
• Moving the data by using Export, Import and Load utilities.
• Monitoring the scheduled jobs like backups, data loads etc.
• Having good understanding on incident and change management
• Provided on call support as and when there is a need
• As a Support DBA, provided L2 support for database related issues
• Working knowledge on Global Service Desk (GSD), MKS versioning tool, IBM Rational Toolkit.
• Involved with the development team, and resolving problems related to the database privileges, etc
• Interacting with the Users and troubleshooting the problems
• DB2 on AIX/LINUX/WINDOWS Development/UAT/Pre-Production Support.
• Work with Application and DBA team.
• Database Change Requests Execution.
• Database monitoring and performance tuning.
• Day to day monitoring activities and support.
• DB2 Midrange ever greening i.e. migration and upgrades.
• Created Instances, DB2 databases, buffer pools, Table spaces as per client requirement.
• Generating data definition language using DB2LOOK command from existing database and creating the same objects in newly created databases.
• Provided the support for DB2 Movement Utilities like Export, Import and Load.
• Taking database Backups and recovering the database with Backup images.
• Had done so many redirect restores from source server to destination server.
• Generating data definition language using DB2LOOK command from existing database and creating the same objects in newly created databases.
• Involved with the development team, and resolving problems related to the database privileges, etc
• Interacting with the Users and troubleshooting the problems
• Participate in on-call DBA support rotation and provide off hours production deployment support
• Timely and accurate communication.
• Proactive defect tracking.
• Ability to work independently and as part of a team with minimal supervision.