Peter R. Campbell

**** ***** **,*** ****, Parsippany NJ 07054, adatw7@r.postjobfree.com 973-***-****

SUMMARY

Successful ZOS DB2 DBA with over 20 years’ experience in banking industry environment.

Implemented various financial report and order transaction-based systems. Followed the project life cycle tasks involving DB2 DBAs.Those being database design all the way to implementation in production. Continued with backup/recovery/performance.

SKILLS

Database Design, BMC Changer Manager, BMC Catalog Manager, BMC Copy Plus,

IBM DB2 Utilitie,s REXX TSO/ISPF, DB2 Backup/Recovery, BMC Apptune,

CA Insight for DB2, DB2/COBOL, ZOS Utilities, ERWIN, DB2/QMF

Experience:

May 1999 to Oct 2018

Senior DB2 DBA Employee

Pershing – Florham Park NJ

Participated in all stages of the project life cycle of each DB2 system.

Involved in the physical design of DB2 Systems.

Established the physical databases across all environments

Set up the necessary backups and reorgs for all systems.

Established an SQL review phase of the project due to the performance of a high transaction through put of the system.

Established a further set of backups specifically for production to provide faster recovery

All systems are performing to the SLA agreements.

Was involved in monitoring for performance and on-going maintenance of the systems.

The database systems included an Automatic Order Processing System that collected and executed orders, Global Clearance and Reporting system that cleared instructional trades and reported on them, Online Balancing system to balance trades between the customer and the street side of the trade, a System controlling the processing of standard files, files sent to customers outside.

Participated on beeper support of the production environment.

Oct. 96 to March 99

Consultant DBA

Merrill Lynch

Implemented and supported a stock trading application using DB2 V4.1.

Involved in all DB2 tasks of the project lifecycle

Used the BMC DB2 utilities.

Participated in 24x7 beeper coverage

Feb 96 to Oct 96

Consultant DBA

Simon and Schuster

Supported a Royalties DB2 application.

Involved in all DB2 tasks of the project lifecycle

Implemented an automated DB2 image copy system and space monitoring tool. These were both written in REXX.

Sept 1977 – Jan 1993

Summary of remaining companies

Worked at Chemical Bank as a DB2 DBA supporting multiple appliocations from Feb 1995 – Feb 1996

Worked as a DBA DBA at Chemical Bank supporting a DB2/QMF reporting system from Jan 1993 – Feb 1995

Worked as a DB2 DBA for UPS from May 1989 – Jan 1993

Worked as a DATACOM DBA at MARS from May 1987 to May 1989

Worked as a DB2 COBOL Programmer for a consultant company for Manufacturers Hanover Bank from Sept 1986 to May 1987

Work as a Customer Support Representative for ADR using DATACOM/DB from May 1984 to Sept 1986

Worked a a DB2 IDMS Programmer fro a consulting company from Oct 1981 – May 1984

Worked in the UK as a IDMS programmer from Sept 1977 – Sept 1981

EDUCATION

Received a Degree in Computer Science from Hatfield Polytechnic in the England

Contact this candidate