In depth experience with various databses, such as DB2 and IMS

Provided DBA development and production support for multiple General Bank/Retail/HR applications.• Provided testing and production implementation support to application developers for Wells Fargo PeopleSoft applications, executing database changes for DB2 ZOS physical databases underlying the logical data structures.• Used Data Studio to help analyze long-running PeopleSoft queries captured with BMC Apptune and make recommendations for performance enhancements/cost savings.• Conducted routine performance monitoring and tuning reviews of programs in production and made recommendations for program, database, and index changes for both Wells Fargo and Wachovia applications to achieve cost savings.• Provided DB2 ZOS database design, testing and production implementation support as primary DBA to application teams for Wachovia Consumer Loans, Insurance Group, and Collections, including implementing database utility jobs as needed for backup/recovery, reorganization, space usage monitoring, BCP/Disaster Recovery, etc.• Worked with application teams to successfully decommission Wachovia Consumer Loans, Insurance Group, and Collections databases made obsolete by completed merger activities.• Provided 24x7 production support via pager rotation for all Wachovia IMS and DB2 ZOS application databases and supporting utility jobs until completion of merger and decommissioning activities.• Assisted DBA team members with their applications as needed.• Followed DBA Standard Operating Procedures and all established change control processes, keeping the data base inventory and all other documentation for databases updated. • Provided status reporting and appropriate issue escalation to management.• Maintained technical knowledge by attending workshops, reading publications, and participating in local technical user groups.

Provided DBA development and production support for multiple Retail Bank applications.• Provided IMS and DB2 ZOS database design, testing and production implementation support as primary DBA to application teams for Consumer Loans, Insurance Group, and Collections, including implementing database utility jobs as needed for backup/recovery, reorganization, space usage monitoring, BCP/Disaster Recovery, etc.• Worked with application team to convert the Collections application databases from IMS to DB2 ZOS to support a new version of the CACS vendor software, modified/enhanced vendor-delivered DDL to conform to Wachovia standards/guidelines without impacting vendor programs. • Worked with application team and Data Analysts to design logical structures and implement physical DB2 ZOS databases to replace First Union Consumer Loan IMS application functions retained when converting to Wachovia vendor software as part of merger. • Conducted SQL, call chart, and/or Explain report reviews to recommend performance changes for programs still in development.• Conducted routine performance monitoring and tuning reviews of programs in production and made recommendations for program, database, and index changes to achieve cost savings.• Provided 24x7 production support via pager rotation for all Retail Banking application IMS and DB2 ZOS databases and supporting utility jobs.• Assisted DBA team members with their applications as needed.• Followed DBA Standard Operating Procedures and all established change control processes, keeping the data base inventory and all other documentation for databases updated. • Provided status reporting and appropriate issue escalation to management.• Maintained technical knowledge by attending workshops, reading publications, participating in local technical user groups, and attending IBM classes and IMS Technical Conference.

Provided DBA development and production support for multiple General Bank/Retail applications.• Provided IMS and DB2 ZOS database design, testing and production implementation support as primary DBA to application teams for Consumer Loans, Insurance Group, Collections, Application Handling, Credit Bureau/Credit Scoring, Application Level Security, MARS Code Maintenance, Asset Management, Common Entry System, Recovery, Merchant Credit, Time Deposits, Mortgage Data Warehouse, Mortgage Underwriter Sales Expert, and Brokerage, including implementing database utility jobs as needed for backup/recovery, reorganization, space usage monitoring, BCP/Disaster Recovery, etc.• Conducted SQL, call chart, and/or Explain report reviews to recommend performance changes for programs still in development.• Provided 24x7 production support via pager rotation for all IMS and DB2 ZOS application databases and supporting utility jobs.• Assisted DBA team members with their applications as needed.• Followed all established change control processes, keeping database documentation updated. • Provided status reporting and appropriate issue escalation to management.• Maintained technical knowledge by attending workshops, reading publications, and participating in local technical user groups.