Db2 Dba Resume Profile
PROFESSIONAL SUMMARY
Senior DB2 DBA with over 20 years of experience in Information Technology providing production DB2 database administration on UNIX AIX, IBM mainframe and Windows client server platforms. Have strong experience in DB2 database administration with versions 2.2 to 9.7 in enterprise level environments up to 80TB in size and muti-partitioned environments up to 160 partitions. Experienced in full life cycle development for all aspects of DB2 database support and proficient in database physical design, installation, performance tuning, backup and recovery, database maintenance procedures, support of N tier architecture applications, DB2 stored procedures, and the use of third party products. Seeking a challenging opportunity to utilize DB2 administration skills and be an asset to the team.
Confidential
DB2 DBA
- Infosphere CDC version 6.5
- Worked on DB2 version 9.7 on AIX version 6.1
- Installed and Administered DB2 Connect version 9.7
- DB2 9.8 Pure Scale
- Installed DB2 LUW version 10 on AIX, LINUX, and WINDOWS
- Performed the physical and logical disk layout.
- Worked with Offshore Teams
- Duties included being on-call during the weekends, setting up restores, performing backups and creating new tables, tablespaces, bufferpools, etc.
- Migrated Databases, data from DB2 Z/OS to DB2 LUW on Linux and AIX
- Set up HADR
- Optim Performance Monitor
- Optim Database Administrator
- Optim Data Archive
- Infosphere Optim 9.1
- Infosphere Change Data Capture CDC
- Also setup HADR on both Non Clustered and Clustered System
- Involved in the TSM backup installation and configuration.
- Made recommendations to the managers on what hardware and software purchases
- Q and SQL Replication
- TSA
Confidential
DB2 DBA ARCHITECT
- Worked on DB2 version 8 and 9 on Z/OS
- Worked on DB2 version 9.7 on AIX version 6.1
- Installed and Administered DB2 Connect version 9.7
- DB2 Pure Scale 9.8
- Performed the physical and logical disk layout.
- Duties included being on-call during the weekends, setting up restores, performing backups and creating new tables, tablespaces, bufferpools, etc.
- Migrated Databases, data from DB2 Z/OS to DB2 LUW on Windows and AIX
- Worked with Z/OS systems Programmers.
- Optim Performance Monitor
- Optim Database Administrators
- Worked with Offshore Teams of WIPRO
- Also setup HADR on both Non Clustered and Clustered Systems
- Inforsphere Optim 7.3
- Worked with off shore, had two people to supervise.
- Involved in the Veritas backup installation and configuration.
- Made recommendations to the managers on what hardware and software purchases
- Q and SQL Replication
TSA
Confidential |
- Migrated Stanley Works SAP BASIS to Black and Decker SAP BASIS
- Migrated to DB2 UDB version 9.1 DB2 UDB version 9.7
- Installed Cockpit DBA SAP DB2 UDB
- Performed the physical and logical disk layout.
- Duties included being on-call during the weeekends, setting up restores, performing backups and creating new tables, tablespaces, bufferpools, etc.
- TSA
- Migrated DB2 UDB version 9.5 to DB2 UDB version 9.7.
- DB2 Pure Scale 9.8
- Worked with Offshore Teams at Infosys
- Optim Performance Monitor
- Optim Database Adminstrator
- Migrated Query Patroller, DB2 Governor to Work Load Manager 9.7.
- Worked on SAP BASIS version 7.0
- Q and SQL Replication
Confidential |
- Migrated Wachovia Investment Bank with Wells Fargo's Investment Bank.
- Migrated a total of 80 terabytes from Oracle databases to DB2 LUW on AIX.
- Performed the physical and logical disk layout.
- Duties included being on-call during the weekends, setting up restores, performing backups and creating new tables, tablespaces, bufferpools, etc.
- Met with project managers on a weekly basis.
- Migrated DB2 UDB version 9.5 to DB2 UDB version 9.7.
- Migrated from TSM version 6.1 to Netbackup version 7.
- Worked with Offshore Teams of WIPRO
- Migrated Query Patroller, DB2 Governor to Work Load Manager 9.7.
- Participated in the upgrade of Datastage version 8.0 to version 8.1.
- Installed the Optim Database Administrator tool.
- Infosphere Optim 7.3
- Q and SQL Replication