Professional Summary I am a DB2 LUW Database Administrator with 20 years of experience covering the full spectrum of DB2 roles, including design, installation, build, maintenance, support, tuning, performance monitoring, backup, recovery, capacity planning, disaster recovery, security and version migrations, with a special focus on AIX/UNIX. 18 of these years were spent with JPMorgan Chase where he solely designed, created and supported any new DB2 LUW database needed for Retail Banking. 90% of these databases were configured with 2 or 3 site HADR configured with TSA, and were Tier1 business critical applications which could not have any outages, and due to his thoroughness and attention to detail, were extremely stable. He has very strong Korn shell scripting skills, and wrote all of the jobs, backups, monitors and alert scripts for all of these databases to provide 100% uptime and reliability. For 15 years, he was the sole Primary support (24x7) for 30 business critical Production databases, and 100's of Test/Dev dbs, and went out of his way to always ensure 100% availability and uptime while troubleshooting and fixing any type of issue encountered. He then worked at least every other weekend to provide night time maintenance on these databases, and quarterly scheduled Production HADR failovers to ensure HA reliability. Daily, he solely managed his own workload for all of the 100+ databases he supported, while working with Project Managers, application teams/developers, UNIX engineers, SAN storage, Change Management, Performance team, TIVOLI team, Audit/Compliance, and other DBA's. In this sole support role, he successfully led all projects and meetings related to any of the databases that he supported, and proactively setup meetings accordingly. Created databases with various types of security including DB2 role based access (RBAC), LDAP, user/group authorization privileges, and Guardium's monitoring of access. Worked with application developers to design and create db objects, and to analyze and fix poor performing queries. Designed backup, recovery, HA and Disaster Recovery strategies for all environments (Prod, Test, Dev), and performed quarterly Production restores to test and ensure recoverability for DR. He has vast experience in creating migration plans, and has successfully migrated 500+ DB2 databases over the past 20 years. Has experience in monitoring DMS tablespace growth successfully extending storage within DB2 and the SAN/UNIX teams.

Highlights:

• C Programming Language
• Triggers
• Unix
• Applications
• Change Management
• Database
• DB2 Database Administrator
• IBM DB2 Database
• Management
• Microsoft Change Management