• Maintain both DB2 and IMS databases in 20 test environments and three production environments as required for both project change requests and production support incidents with little or no impact to the availability of dependent applications. • Manage technical requests, problems and questions that are submitted to the mainframe database team on a daily basis. As a result the mainframe database team continues to achieve a high level of customer satisfaction especially with application development and other production support teams.• Identify and correct DB2 performance issues in both batch and online applications on a continual basis resulting in significant CPU savings and better application response times.

• Collected / analyzed performance data for large Datacom to DB2 project and recommended tuning opportunities that were essential in satisfying CPU capacity constraints. • Provided analysis of and resolution to DB2 application issues in both test and production environments resulting in fewer issues in successive project phases.• Worked with applications teams in implementing DB2 application coding changes that resulted in significant CPU and elapsed time savings.

• Maintained all aspects of a seven terabyte production DB2 database used by 401K record keeping system and nine test DB2 databases totaling five terabytes resulting in no production down-time. • Functioned as chief DB2 Security Administrator for the DBA team. Collaborated with the mainframe security team on a large project to implement DB2 database security changes required by corporate audit.• Developed process for identifying Production SQL tuning opportunities that resulted in over $1M in cost savings.• Performed SQL code reviews to ensure DB2 application programs satisfied coding standards. Recommended SQL and application coding changes that resulted in improved DB2 performance.

• Maintained DB2 databases for Time Entry and vendor-developed Employee Information System applications. Designed alternate database indexes for EIS that resulted in significant cost savings and improved performance. • Supported various client/server projects utilizing Oracle databases on UNIX.• Installed, maintained and provided technical support for mainframe DB2 database administration tools.