SUMMARY:

• Expertise in: Mainframe Application Development, DB2 Database Administration
• Highly skilled, self - motivated, mainframe IT Professional with more than 29 years of IT experience and 16+ years as a DB2 DBA.
• Exceptional DB2/TSO/ISPF/REXX knowledge and creativity have resulted in repeated implementations of outside-the-box solutions to database issues, which resulted in significant cost savings.
• Proven ability in performance tuning at the pageset, SQL, and Bufferpool levels.
• Demonstrated ability to work in high stress, fast-pace environments with cross-functional teams to achieve success within project timelines.

TECHNOLOGY SNAPSHOT:

Operating Systems: DOS, Windows, OS/2, HP UNIX, AIX, VM, MVS, OS/390, z/OS, Linux, Confidential i

Programming Languages: PL/I, SAS, COBOL VS, COBOL II, COBOL 370, JCL, REXX, SQL, SQRQUICKJOB

Databases: XDB, Access (MS), Informix, IMS/DB, DL/I, DB2, Data Sharing, IDAANetezza, Q Replication, DB2 for i ( iSeries )

Program Products: Microsoft Office, REMEDY,TSO, ISPF, SDSF, TMS, QMF, DFSORT, SYNCSORT, ENDEVOR, SCLM, PANVALET, XPEDITER, INTERTEST, BMC DB2 Tools, CA DB2 Tools, Confidential DB2 Tools

Transaction Servers: IMS/DC, Confidential, JCAPS

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

DB2 DBA Consultant

Responsibilities:

• Lead DB2 z/OS V12 Upgrade efforts
• Create automation for Package and Explain table pruning
• Performance Tuning
• Mentor offshore resources

Confidential, Cincinnati, OH

DB2 DBA Consultant

Responsibilities:

• Developed process for capturing and working worst performing SQL by application
• Developed process to load captured DB2 system data to DB2 tables and push it to Confidential
• Implemented trigger process to flatten a normalized model to allow dashboard scalability
• Extensive SQL review and performance tuning
• DML, DDL, HPU, REXX, IDAA, and Production Problem Resolution

Confidential, Mountlake Terrace, WA

DB2 DBA Consultant

Responsibilities:

• Assisted with DB2 V11 migration
• Performed tuning on the Global Purge process for BCS Inter-plan Teleprocessing Services (ITS) to reduce elapsed time by over 90%, a critical win necessary for Premera to meet a footprint reduction deadline for an application outsourcing project
• CA Insight configuration and implementation of the Archive Database for analysis, reporting, and trending purposes
• Redesigned DBA maintenance processes to reduce resource utilization (Elapsed time, CPU, Tape). This also resulted in a significantly smaller and less complex maintenance strategy.
• Worked with Systems team to identify and implement Confidential PTF (Partition-level Statistics issue)

Confidential, Brentwood, TN

DB2 DBA Consultant

Responsibilities:

• Performed an assessment of Confidential ’s DB2 for i V7.1 environment looking for administrative and tuning opportunities.
• Database Object Inventory, Space Utilization, Security, Backup and Recovery, Table Partitioning, Physical File Reorganization, Indexes, Performance, and Modernization.

Confidential, Nashville, TN

DB2 DBA Consultant

Responsibilities:

• Reduced critical quarterly processing time by 4 days through pageset, index, and SQL tuning allowing postponement of a costly mainframe upgrade. DB2 z/OS V9 to DB2 z/OS V10 migration.
• Implemented monitoring processes for proactive problem resolution.
• Modernized existing processes to take advantage of newer DB2 features.
• Reduced contention by 82%.
• DB2 LUW Provided support for DB2 LUW, DB2 Connect, and Q Replication federation servers. DB2
• Connect migration from V9.7 to V10.5. Setup federation server between DB2 LUW V9.7 and DB2 z/OS V10.
• Q Replication Supported Q Replication V10.2.1 with unidirectional and bidirectional replication between
• DB2 z/OS subsystems and Oracle.
• Managed subscriptions.
• Troubleshooting exceptions and MQ channel issues. Executed Cold Start in test. Refreshed out of sync tables.
• Netezza Provided Netezza V7.0.2 database administration that included: security, DDL, grooming, and tuning reorganization. Developed process to load 1 billion rows of DB2 z/OS UNLOAD data.

Confidential, Austin, TX

Sr. Consultant

Responsibilities:

• Performed consulting and development for Confidential .
• Consulting experiences acquired include installation of Confidential for z/OS and Confidential Rational Developer for System Z Unit Test (z/OS on a PC).
• Responsibilities for the RDz UT installation included configuration of the z/OS environment.
• Created RHEL and SUSE installations of Confidential BigInsights, versions 1.4 and 2.0, for Confidential .
• Provided systems and DB2 support for Confidential ’s installation of RDz UT.

Confidential, Plano, TX

DB2 DBA Consultant

Responsibilities:

• Provided recommendations for subsystem parameters (ZPARMS), logging, bufferpools, real storage, and DASD requirements.
• Assisted with the database design for maximum concurrency and minimum DASD utilization.
• Performance Tuning, Developed DB2 utility strategy and the deliverables.
• Provided DB2 V8 & V9 support to the installation team.

Confidential, Louisville, KY

Sr. DB2 Database Administrator

Responsibilities:

• Developed and executed a plan to integrate the Taco Bell databases into a subsystem with different date and time defaults without the need to recompile and test the applications. This resulted in significant savings. The original plan was to hire several contractors to recompile and test all the Taco Bell programs.
• Changed bufferpool strategy from being application centric to I/O centric. Prior to the change the hit ratio for the bufferpools were averaging somewhere between 60-70%. After the new strategy was implemented all bufferpools, except the one reserved for asynchronous I/O, were almost always over 90%.
• Led effort to create DBA standards which resulted in: (1) use of best practice, (2) DBAs were no longer siloed into supporting specific applications, (3) reduction in oncall problems, (4) more efficient DBA maintenance processes.
• Designed and built a process to refresh non-production Peoplesoft databases using a SORT compare process and generated DSN1COPY jobs. The elapsed time to refresh Peoplesoft Financials dropped from a week to one day.
• Implemented Sliding Secondary Extents which resulted in significant DASD savings and the elimination of DBAs over allocating pagesets.
• Led a DBA team effort to identify and tune the worst performing SQL. Out of the top twenty worst performing SQL, we improved all of them except two.
• Implemented Real-Time Statistics and used it to drive our weekend maintenance processing. Results of a significant decrease in overall maintenance elapsed time allowed us to implement distribution statistics.
• Implemented a process to minimize DBA effort in Disaster Recovery tests. This allowed us to eventually designate the oncall DBA at the time of the test to be on point.
• Represented Database Discipline on the Extended Enterprise Architecture team and Data Architecture Implementation squad.
• Developed automation processes to eliminate trivial and mundane DBA tasks
• Developed alert processes to notify the DBA team of impending problems

Confidential, Louisville, KY

Programmer/Analyst Consultant - Independent

Responsibilities:

• Performed many DBA functions as HMHS did not have a dedicated DB2 DBA resource.
• Converted code using a third party product which never generated clean executable code.
• One of four remaining contractors from the original team of twenty, we eventually rewrote many of the converted programs.

Confidential, Louisville, KY

Programmer/Analyst Consultant

Responsibilities:

• Led a project to support the sale of automotive components to the Confidential .
• Co-lead on a project to replace an assembly scheduling system. The new system employed user-specified rules designating the combination of truck builds which could be supported by the assembly line. The execution time of the scheduling system was reduced from hours to minutes.
• Developed mainframe COBOL IMS DC programs accessing mainframe DB2 databases.

Confidential, Lexington, KY

Programmer/Analyst Consultant

Responsibilities:

• Provided analysis, design, and PL/I programming services for a new Profitability Measurement System which reported the company’s profitability by geographic areas and branch offices.
• Performed Programmer/Analyst duties on a project to convert a national inventory system’s database from IMS to DB2.
• Voted by peers to receive the Outstanding Teamwork Award for work on this system.
• Developed and executed test plans on a project to update the inventory system database in real-time via Confidential transactions.
• Performed customer support and development for a national marketing system written in REXX on a VM platform using several data servers.