PROFESSIONAL SUMMARY:

• Senior DB2 DBA with over 20 years of experience in Information Technology providing production DB2 database administration on UNIX AIX, Confidential mainframe and Windows client server platforms.
• Worked in large database environments up to 80TB in size and multi - partitioned environments up to 80 partitions.
• Over 17 years on the UNIX platform experience, including 8 years of experience specifically on Linux, and he has over 17 years of Shell scripting experience.
• Three years of experience using DB2 on Windows
• Worked on SAP Databases

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

DB2 DBA

Responsibilities:

• Installed and administered HADR on DB2 versions 11.1 on DB2 LUW
• Migrated DB2 UDB Databases from version 9.5 to version 11.1
• Installed HADR DB2 11.1 on Multiple Standbys for HADR
• Created DB2 Databases
• Performance and Tuning on SQL Applications
• Installed and administered Confidential Data Studio
• Installed and administered Confidential Data Server Manager version 1.1
• Installed DB2 version 11.1
• Installed fixpacks on version DB2 versions 9.7, 11
• Designed backup and restore strategies.
• Purchased DB2 Advanced Workgroup Edition
• Met with Confidential Monthly
• AWS Storage S3, Dedicated Instance
• Worked with applications programming staff
• LDAP Administrator for Confidential
• Installed and Administered 3 party software.
• Installed DB2 into the cloud using AWS S3, EC2
• Migrated from AIX to Linux
• Created Backup and Restore Scripts
• Worked with application programmers
• Installed Tivoli Storage Automation

Confidential, Fort Wayne, Indiana

DB2 DBA

Responsibilities:

• Installed and administered HADR on DB2 versions 9.7,10.1 10.5 on DB2 LUW
• Installed Tivoli Netcool/Omnibus application
• Installed Tivoli Monitor software
• Installed Tivoli Business Service Manager
• Installed Tivoli Netcool Configuration Manager
• Migrated DB2 UDB Databases from version 9.1 to version 10.5
• Installed HADR DB2 10.1 on Multiple Standbys for HADR
• Created DB2 Databases
• Performance and Tuning on SQL Applications
• Migrating DB2 from Windows to AIX other
• Installed and administered Confidential Data Studio
• Installed and administered Confidential Data Server Manager version 1.1
• Installed DB2 version 10.1
• Installed DB2 version 10.5
• Migrated 3 Oracle version 11 databases to DB2 versions 10.1 and 10.5
• Installed fixpacks on version DB2 versions 10.1 and 10.5
• Designed backup and restore strategies.
• Worked on 70 instances
• Deinstalled 50 instances
• Worked on 180 databases

Confidential, Jacksonville Fla

DB2 DBA

Responsibilities:

• Installed and administered HADR on DB2 versions 9.7,10.1 10.5 on DB2 LUW
• Migrated DB2 UDB Databases from version 9.1 to version 10.5
• Installed HADR DB2 10.1 on Multiple Standbys on HADR
• Created DB2 Databases
• Administered HADR using TSA
• Performance and Tuning on SQL Applications
• Migrating DB2 from Windows to AIX other
• Used SQL Server 2008, 2012
• Installed and administered Confidential Data Studio
• Installed DB2 version 10.1
• Installed DB2 version 10.5
• Installed Data Administration tool AQT
• Installed fixpacks on version DB2 versions 10.1 and 10.5
• Designed backup and restore strategies.
• Worked on DB2 on Windows 2008, 2012
• Worked on DB2 on AIX 6.1, and 7.1
• Worked with Confidential on PMR’s
• Administered DPF Databases on DB2 UDB
• Worked on the E-Commerce system
• Installed and administered Foglight
• Administered SAP Transport
• Working with Middleware team using WebSphere
• Installed DB2 version 10.1.4
• Migrated from DB2 9.7.9 to 10.1.4
• Worked with the Application and Systems Teams

Confidential, Milwaukee, WI

DB2 DBA

Responsibilities:

• Helped design a Data Warehouse with the Accounting Group
• Installed HP Asset Manager 9.2 and a newer version of DB2 9.7 for this project
• Worked with the storage team to add additional space to the database
• Performed Data migration of the 2 TB sized accounting Data Warehouse
• Worked with Confidential and business partners on multiple projects
• Performed backup and restores of over 80 databases
• Worked on Suse Linux on the HP Asset project
• Involved in performance tuning major financial applications
• Worked on table partitioning, DB2 Data Warehouse, DPF Tables, & Optim Performance Manager
• Worked closely with the offshore team
• Setup HADR on DB2 version 9.1, 9.7, 10.1

Environment: DB2 10.1, Linux, AIX, Windows, SUSE Linux 10,11, SAP Financials

Confidential, Chicago, IL

DB2 DBA

Responsibilities:

• Involved in install and upgrades of PeopleSoft 9.2; migrated data between 20 databases
• Installed DB2 9.7, 10.1 and Fix Packs; upgraded from version 9.1 to 10.0
• Installed and Administered DB2 Connect version 9.7
• Migrated DB2 from AS 400 to DB2 AIX 9.7
• Created backup and restore procedures for Confidential, creating new tables, table spaces, buffer pools etc.
• Involved in mentoring DB2 Unix to the DB2 AS400 DBAs, ORACLE DBAs
• Set up DB2 Backup to Tivoli Storage manager (TSM), setup HADR and Federated databases
• Created tables, indexes for all databases for Confidential
• DPF Databases
• Performed the physical and logical disk layout
• Designed and Administered an E-Commerce solution.
• Migrated Oracle 9 to DB2 LUW 9.7
• Set up SAP Databases on DB2 9.7
• Worked on DB2 LUW on Windows 2008 30% of the time.
• Performed Space Management of DB2
• Sun Solaris 9.7
• Involved in making recommendations to Managers on hardware and software purchases
• Worked with Offshore and provided on-call 24/7 support

Environment: PeopleSoft 9.2, DB2 9.5, 9.7,10.1, 10.5, Windows 2008, DB2 LUW, Optim Performance Monitor, Optim Database Administrator, SAP

Confidential, Chicago, IL

DB2 DBA

Responsibilities:

• Duties included being on-call during the weekends, setting up restores, performing backups and creating new tables, table spaces, buffer pools, etc.
• Worked on DB2 version 9.7 and 10.1 on AIX version 6.1
• Installed and Administered DB2 Connect version 9.7
• Installed DB2 LUW version 10 on AIX, LINUX, and WINDOWS
• Worked on Windows 2008
• Performed the physical and logical disk layout.
• Worked with Offshore Teams
• Migrated Databases, data from DB2 Z/OS to DB2 LUW on Linux and AIX
• Setup HADR on both Non Clustered and Clustered System
• Involved in the TSM backup installation and configuration.
• Q Replication
• Worked on DB2 and SAP Databases
• Worked on Suse Linux 10
• BMC Foglight
• Worked on E-Commerce databases
• Worked with Content Manager version 7.1
• Worked on DB2 Data Warehouse
• Sun Solaris 9.7
• Windows 2008
• Performed Q and SQL Replication

Environment: DB 2 9.5/9.7/10.1 , LUW 10, Z/OS, AIX 6.1, Suse Linux 10, Infosphere Windows 2008, CDC version 6.5, DB2 9.8 Pure Scale, Optim Performance Monitor, Optim Database Administrator, SAP Infosphere Optim 9.1

Confidential, Naperville, IL

DB2 DBA ARCHITECT

Responsibilities:

• Provided on-call weekend support, setup restore procedures, performed backups, created new tables in a DB2 environment comprising versions 8 and 9 on Z/OS and version 9.7 on AIX version 6.1
• Installed and Administered DB2 Connect version 9.7
• Performed the physical and logical disk layout.
• Migrated Databases and data from DB2 Z/OS to DB2 LUW on Windows and AIX
• Worked with Wipro Offshore teams; supervised a 2 member team
• Setup HADR on both Non Clustered and Clustered Systems
• Created DB2 and SAP Databases on DB2 9.7
• Involved in Veritas backup installation and configuration
• Set up DB2 Backup to Tivoli Storage manager (TSM); setup HADR and Federated databases
• Made recommendations to managers on hardware and software purchases
• Performed Q and SQL Replication

Environment: DB2 8, 9, DB2 LUW, Z/OS, Windows, AIX, DB2 Pure Scale 9.8, DB2 LUW, Oracle Transport Version 11, Optim Performance Monitor, Optim Database Administrator, Infosphere Optim 7.3

Confidential, St. Louis, MO

IT Architect/ DB2 DBA

Responsibilities:

• Was brought in to perform data migration due to the Wachovia and Wells Fargo merger
• Migrated a total of 80 terabytes from Oracle databases to DB2 LUW on AIX
• Performed the physical and logical disk layout
• Provided on-call support during weekends, set up restore procedures, performed backups and created new tables, table spaces and buffer pools
• Worked closely with the Project Managers; provided status reports on a weekly basis
• Involved in DB2 UDB migration from version 9.5 to 9.7
• Migrated from TSM version 6.1 to NetBackup version 7
• Migrated 20 databases from AIX to Windows
• Migrated Query Patroller, DB2 Governor to Work Load Manager 9.7.
• Windows 2008
• Participated in the upgrade of Datastage version 8.0 to version 8.1.
• Installed the Optim Database Administrator tool.
• Performed Q and SQL Replication
• Worked closely with Wipro offshore teams of WIPRO

Environment: DB2 LUW, DB2 UDB 9.5/9.7, TSM, NetBackup, Windows 2008, DataStage, Oracle, Infosphere Optim 7.3

Confidential, Bloomington, IL

DB2 UDB DBA, UNIX Systems Administrator

Responsibilities:

• Responsible for performance tuning of SQL and DB2 systems
• Worked with Quest Software to educate Confidential, which products would benefit them
• Installed third party applications software
• Created physical and logical disk layout
• Worked with Offshore Teams of INFOSYS, TCS, WIPRO
• Installed, configured and administered TSM on AIX and Windows.
• Designed DPF Warehouse databases which are at least 80 terabytes in size.
• Installed configure and administered DB2 Patrol across two hundred servers.
• Q Replication
• Worked on Windows 2008
• Lead point of contact in converting DB2 Disks backups to TSM.
• Worked with Content Manager version 6
• BMC Foglight
• Worked on a Data Warehouse that was 100 terabytes in size
• Worked as Lead DBA on the sizing project with Confidential (spent 4 months in Gaithersburg Maryland with Confidential in their Data Replication Center)
• Installed DB2 version 9.7 on AIX Version 6, Infosphere Warehouse, and Power VM and DB2 virtualization.
• Performed Q and SQL Replication

Confidential, Hayward, CA

DB2 DBA, UNIX Systems Administrator

Responsibilities:

• Installed DB2 EE and EEE, DPF v. 8.2, 8.2.4 on AIX v.5.2, 5.3.
• Worked on Windows 2000
• Created databases, backup, recovery and tables.
• Setup the disaster recovery for DB2.
• Responsible for upgrades on DB2 across all nodes.
• Responsible for major new system at Confidential .
• Performance and tuning of DB2 systems and SQL.
• Performed UNIX and Linux System administration.
• Installed third party software.
• Worked on DB2 Data Warehouse
• Responsible for SAP GUI administration and installation.
• Performed physical and logical disk layout.
• Migrated Oracle version 7 to Confidential version 8.2
• Designed E-Commence soulution
• Set up DB2 Backup to Tivoli Storage manager (TSM), setup HADR and Federated databases
• Designed the new Sigcapp and EJ systems which included making the decision on which UNIX servers to buy setting up the volume groups.
• Help Setup SAP Financials on DB2 version 9.1
• Installed version 5.3 on AIX.
• Installed DataStage, DB2 UDB version 9.0.

Confidential, Bloomington, IL

DB2 DBA

Responsibilities:

• Installed the DB2 EE and DPF v. 8.2 on AIX v.5.2.
• Responsible for DB2 Z/OS administration on Z/OS 1.7; Created databases, backup, recovery, and tables; Set up the disaster recovery for DB2.
• Worked with Offshore Team of INFOSYS
• Responsible for upgrades on DB2 across all nodes.
• Responsible for performance tuning of DB2 systems and SQL.
• Performed UNIX and Linux system administration.
• Responsible SAP GUI administration and installation.
• Q Replication
• Used SAP utilities with the DB2 database; Applied the SAP OSS patches; Involved in performance tuning of the SAP database.
• Performed physical and logical disk layout.
• Installed and configured WebSphere version 5.1 and version 6