SUMMARY

• Having 7+ years of extensive IT experience as a DB2 UDB DBA.
• IBM DB2 Certified Advanced Database Associate.
• Worked on installation of different versions of DB2 UDB on AIX 6 & 7.
• Implemented database restores, performance tuning of the applications and backups.
• Implemented application performance tuning to improve query performance optimization using DB2’s Explain, Visual Explain and advises tools.
• Performed installs of DB2 software and builds of new instances; set up High Availability Disaster Recovery environment (HADR) for DB2 applications.
• Provided assistance and mentored new Database Administrators by preparing documentation, training plans and performing knowledge transfer.
• Having strong experience in Unix shell scripts, New Korn and awk shell scripts, developed automated scripts using Unix Shell for performing runstats, reorg, rebind, backup, load, export, import, load, auto - load, backup, restore/recover database utilities and other related database activities like complete HADR setup.
• Created multiple schema’s over the database based upon the requirement from the application team.
• Complete knowledge of design concepts of MQTs, MDCs, Range-Partitioned tables, Range-Clustered tables, and distribution keys.
• Experience in writing shell scripts for monitoring and performing day to day and weekly tasks. Developed automated system for production BACKUPS, REORGS, RUNSTATS.
• Worked on monitoring the tablespace utilization on the production database using scripts.
• Worked on Database Partition Features (DPF) comprising both physical and logical partitions, formerly known as EEE.
• Database backup and recovery experience with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
• Complete knowledge of design concepts of MQTs, MDCs, Range-Partitioned tables, Range-Clustered tables, and distribution keys.
• Experience in Root Cause Analysis of Production Defects and have been the go to person for all issues within the team.
• Quick learner & a good team player who is flexible and enjoys mastering new job assignments.
• Possess excellent communication skills & leadership abilities and loyal work ethics.
• Successful in meeting new technical challenges and finding solutions to meet the needs of the customer.
• Provided DB2 support during every quarterly release.
• Migrated DB2 from v9.7 to v10.5 FP5 and upgrades to latest fix packs.
• Provided 7x24 DB2 support.

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

DB2 DBA

Responsibilities:

• Perform rolling fixpack apply on HADR environments.
• Database utility experience including reorg, runstats, rebind, export, import, load, autoload, backup, restore and recover database utilities.
• Migration of DB2 from v9.7 to 10.5.
• Perform data refresh from Prod to lower environments using redirected restore across different backup/recovery solutions.
• Install/Upgrade DB2 Server, DB2 Client, Db2 Connect as per Solution requests/Changes.
• Create Instances and databases as per Solution Requests.
• Experienced in UNIX shell scripting and troubleshooting. Use of shell scripting to monitor different aspects of database.
• Supported cognosapplication on partitioned environment (DPF) with 8 physical partitions and 29 partitioned ware house environment. Experience working with MDCs, MQTS, Range-Partitioned tables, and Range-Clustered tables.
• Monitor temp space utilization over the database using scripts.
• Apply Security Patches and Fix Pack Updates on all instances.
• Database backup and recovery experience with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR.
• Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools.
• Database and SQL access plan optimization experience with DB2’s Explain, Visual Explain, and advisor tools. Stored procedure (SP).
• Experience automating database maintenance and monitoring with shell scripts including automating system event logging, e-mail alert notification, and reporting using the DB2 utilities and Command Line Processor (CLP).
• IBM Problem management, and resolution (PMR) experience with DB2 diagnostic log facility, administration notification log, trace facilities.
• Perform administration tasks such as database backup and restoration, Monitoring database health in terms of memory, CPU utilization, disk space and security.
• Responsible for running optimizer plans for slow performing queries, running trace and create standard reports on query performance and Database recovery. Performance tuning using OPM, db2advis, db2expln for query optimization.
• Experience in good troubleshooting techniques to ensure quick and successful resolutions (snapshot, db2pd, db2top etc.).
• Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
• Enabling Federation to retrieve the other database object while being connected to a different database as well as setting up the registry variable to enable the Federation of Cross RDBMS.
• Preparing documentation, training plans and perform knowledge transfer.

Environment: Operating System: AIX 5.1/6.0/7.1. DB2 UDB v9.5/9.7 ESE/10.5 AESE, Shell Scripting, BMC Remedy, Putty, Putty Connection Manager, Mobaxterm, Citrix, TSM.

Confidential, CO

DB2 DBA

Responsibilities:

• Involved in upgrading DB2 UDB 9.7 and 10.5 on production and development servers.
• Create Instances and databases as per Solution Requests.
• Worked on DB2 defects along with IBM and applied special builds for the production and development environment.
• Installed DB2 UDB V9.x and V10.5 software on AIX, Linux and Windows environments
• Worked with tools DB2 Performance expert, DBArtisan, DB2MON, Control center to debug and resolve database issues.
• IBM Problem management, and resolution (PMR) experience with DB2 diagnostic log facility, administration notification log, trace facilities.
• Supported cognosapplication on partitioned environment (DPF) with 8 physical partitions and 29 partitioned ware house environment. Experience working with MDCs, MQTS, Range-Partitioned tables, and Range-Clustered tables. Developed shell scripts for daily maintenance tasks, archiving DB2 log files, and performance monitoring.
• Extensively worked on tuning complex SQL queries, developing stored procedures, and functions.
• Experience in monitoring and tuning database using snapshots and event monitors, identifying problem in SQL statements and performance bottlenecks, schema changes, configuration changes and explain analysis; working with developers, working with IBM support.
• Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the database.
• Worked on HADR setup with Tivoli System Automation (TSA).
• Performed capacity planning.

Environment: Operating System:AIX, Linux DB2 UDB LUW V 9.7 AND 10.5(ESE) Edition, TSM, Data Studio, db2top, Putty, Control Center.

Confidential

DB2 DBA

Responsibilities:

• Implement backup and recovery strategies for databases based on business requirements.
• Performing the Point in Time roll forward from Online as well as Offline Back Up.
• Binding of database and creation of packages while Migration and Upgrades.
• Performing Reorg, Run stats.
• Changing the Database from Circular to Archival logging.
• Updating Instance memory and Database memory.
• Setting up of same Database in a QA and Development Region as existing in Production Environment.
• Export and Import and Load utilities for the setting up same references in Test Region as existing in the Production environment.
• Perform TSM setup.
• Retrieval of the LOGS and Database backups from TSM.
• Responsible for the coordination of DPF backups and recovery of databases depending on application requirements
• Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
• Reducing the HWM using reduce max.
• Database and Server migration from 9.7 to 10.5
• Proficient in Optimization of SQL Queries by use of MQT and Staging Tables for better Read Operation.
• Providing ideas to reduce the time taken to perform the backup of large size database.
• Instance Move of the db2 instances for the shared environment.
• Setting up of Federation across RDBS platforms.
• 10.5 upgrades and applying Fix pack patch (rolling patch).
• Setting up of backup/restoring strategy of TSM.
• Day to day maintenance and support activity and Monthly changes in Infrastructure change window.
• Root cause analysis, Availability of 24*7 during Issues and High Severity.

Environment: Operating System: Windows XP, Windows server 2003/2008, AIX, Linux DB2 UDB LUW V 9.7 (ESE) Edition, TSM, Data Studio, db2top, Putty, Control Center.