James R. Hall **** S Keating Ave Chicago, IL ***** Phone: 773-***-**** Email: ac30hs@r.postjobfree.com

. SUMMARY

IBM Certified Database Associate DB2 10.1 Fundamentals.

** ***** ********** ** ** with z/OS Series IBM Mainframe Servers.

20 years experience with DB2, predominately in Database Administration.

15 years experience supporting and administering PeopleSoft HCM and Financials databases on DB2 z/OS.

Proficient with DB2 and Vendor Utilities.

Proficient with z/OS, JCL, TSO/ISPF and VSAM.

Knowledgeable with COBOL particularly in a batch environment.

Kmnowledgeable with RACF and Endevor.

Familiar with CA-7, ZEKE, ADABAS and Natural.

Experience working with Generation Data Groups, VSAM, Partitioned, and Physical Sequential files.

Experience with JCL and batch job execution in a mainframe environment using Procedures.

Experience with CICS for online application functionality.

Understand the fundamentals of the financial services and operations industry.

Experienced with NDM and FTP transmission protocols

Proficient with BMC and CA performance/administrative tools.

Proficient with DB2 Connect installations on AIX and Windows servers, and knowledgeable with AIX and Linux commands.

Proficient with Logical and Physical Database Design, DB2 Performance and SQL Programming Language, achieving substantial resource savings with creative strategies and processes.

Achieved Advanced Communicator Gold and Advanced Leader Bronze in Toastmasters International, and passionate about the benefits of owning effective communication and leadership skills.

PROFESSIONAL EXPERIENCE

Ensono – Chicago, IL - Expert Consultant

Cook County Circuit Court – August 2017 to Present

Performed DB2 Database Administration support serving Cook County Circuit Court MIS Mainframe Application team, preparing to transition to DB2 V11 from DB2 V8.

Partnered with the Mainframe application programmers supporting the TRIM (Traffic Information Management) application which stored the information for all traffic violations committed, tickets issued and court cases presided over in Cook County and accessed online via CICS.

Collaborated with the programmer on implementing the Late Payment Fees project table changes.

Pioneered many features with DB2 utilities introduced in V8 that had not been addressed since they had not had a dedicated DBA for the previous 18 months.

Produced their DDL for existing objects using procedures and processes I created to better position them until they install new administration tools with V11.

Established myself as an integral member of the team who was respected, appreciated and liked by my team members.

Health Care Service Corporation – Chicago, IL – Enterprise Database Administration Group

Lead Database Consultant - October 2014 – June 2017

Team Leader for database activities supporting PeopleSoft HCM and Financials product suites, as well as multiple Financial applications, running on DB2 z/OS version 11. This included successful planning, execution and implementation of multiple tax updates, product bundles and application customization projects of varying sizes and scope, as well as changes related to addressing performance, tuning and capacity opportunities.

Drove database efforts to create Demo environments allowing HCSC to transition PeopleSoft support from Oracle to Rimini Street thereby saving HCSC thousands in support contracts. Rimini Street used these environments to develop Tax Update changes formerly provided by Oracle.

Spearheaded database implementation activities during the PeopleSoft HCM 9.2 upgrade, achieving multiple technical and business objectives in addition to the successful implementation of the upgrade. This streamlined and improved the loading of the Open Enrollment rate tables and provided improved database support for the employee benefit and payroll tables, thus converting them from partitioning by range to by growth. This permitted the HR department to achieve their goal of combining five separate companies into one for all employee processes with minimal impact to the payroll process.

Directed database implementation activities during the PeopleTools 8.53 upgrade which resulted in installing new releases of the Phire project migration product and EDD navigation for employee portal product, as well as the 8.53 PeopleTools release being migrated to the HCM product version 9.0 release and the Financials product version 9.1 release. Also as part of the PeopleTools Upgrade we seized the opportunity to upgrade our AIX and Windows servers to DB2 Connect V10 from V9.7. Additionally, my team delivered as a benefit of this project, PeopleSoft delivered temporary tables were moved from the delivered application tablespaces to their own individual databases resulting in improved performance and reduced processing time.

Converted all supported DB2 application utility jobs to an agile database management methodology, as well as collaborating with the open systems team to set up new PeopleSoft DB2 Connect servers as Linux-based.

Database Consultant - January 2007 – October 2014

Key contributor for all PeopleSoft HCM database activities on DB2 Versions 8 through 10. This included both mainframe and server activity such as cataloging mainframe databases on AIX and Windows servers as well as several DB2 Connect upgrades required during this timeframe.

Oversaw the Enterprise DBA Team Disaster Recovery operations.

Supported database changes for PeopleSoft HCM and EDD product suites through multiple projects and implementations, as well as changes identified by the DBA team as necessary for performance improvement.

Analyzed and identified multiple tables in shared delivered PeopleSoft tablespaces where performance had presented a challenge due to volume of rows being much larger than other tables in those spaces, and moved them to individual tablespaces in PeopleSoft HCM suite to improve performance.

Modified database refresh process for non-production environments from copying data from a production image copy to unloading the data directly from production, eliminating a recurring problem of broken data pages due to using DSN1COPY that was unsupported by IBM to copy the data to using reliable DB2 utilities to move the data from production to non-production.

Implemented an agile database management approach to managing our DB2 Utilities using DB2 tables and REXX programs to take advantage of features provided with DB2 Real Time Statistics.

Initiated and facilitated inaugural DB2 Users Group for HCSC IT Group employees.

Fidelity Information Services – BMO Harris account - Harris Bank Data Center, Chicago, IL

Database Administrator – April 1995 – January 2007

Principal z/OS DB2 DBA and DB2 subject matter expert for DB2 z/OS Version 7 and 8 for Fidelity Harris account.

Streamlined database activities for PeopleSoft HCM and Financials database environments.

Administered data storage allocations in test and production environments by identifying opportunities for archiving or reducing databases via archival or removal of data.

Collaborated with the Deposits application team to create 300 SQL Stored Procedures written using DB2 Stored Procedure Builder and partnered with primary application developer to tune and improve performance of long-running queries for the retail banking application.

Awarded December 2005 Excel award for efforts during October 2005 implementation of z/OS DB2 components of Check Imaging project, providing Harris Bank a competitive business advantage.

TRAINING AND LEADERSHIP

Leadership and Communication

Toastmasters International – Member of Blue Cross Blue Shield Toastmasters Clubs 1 and 2 since October 2011.

President from July 2013 until June 2014.

Certified Advanced Communicator Gold and Advanced Leader Bronze.

Gave over 50 speeches and presentations to our members.

Reigning Area F81 International Speech Contest Champion

Technical Leadership and Training

DB2 V10 Family Certification - IBM Information on Demand Conference – Las Vegas, NV – 2013.

Completed Database Administration training program - Sears, Roebuck and Co. - 1990.

Contact this candidate