SUMMARY:

20 years experience as a z/OS DB2 Database Administrator, functioning in all aspects of DB2 DBA from development through production support, including SQL tuning; 10 years experience as an IBM OS/MVS Assembler, Cobol and IMS programmer.

TECHNICAL SKILLS:

HARDWARE/SOFTWARE: IBM OS/390, z/OS, SYSPLEX, Cobol, SQL, CICS, JCL, DB2/Utilities, DBA Expert, Erwin, TMON, Quest, Visual Explain, CA - Platinum, CA-Detector, CA-Migrator, Omegamon, BMC Utilities, SPUFI, QMF, VSAM, TSO/ISPF, DB2 v10

EXPERIENCE:

Confidential, Louisville, Kentucky

Senior DB2 Database Administrator Consultant

Responsibilities:

• DBA maintenance support for People Soft Financial and Human Resource zOS DB2 v9 databases.
• We maintained several test and QA versions of the People Soft Financial and Human Resource databases.
• Each database consisted of several hundred tables varying in size from a few hundred to several million rows.
• We are currently at DB2 v9 using IBM DBA Tool and Omegamon software to manage, migrate, maintain and monitor daily database activities.
• We also use IBM DB2 utilities for routine database maintenance.

Confidential, Baltimore, Maryland

Senior DB2 Database Administrator Consultant

Responsibilities:

• As a senior Applications DB2 DBA Consultant at Confidential, my primary responsibilities included development and maintenance support of the Disability Case Processing System (DCPS).
• We currently maintain several test, validation and integration versions of the DCPS DB2 database.
• Each database consists of several hundred tables varying in size from a few hundred to several million rows.
• We are currently at DB2 v10 using CA Platinum and Omegamon software to manage, migrate, maintain and monitor daily database activities.

Confidential, Boulder, Colorado

Senior DB2 Database Administrator Consultant

Responsibilities:

• I was responsible for the production support of seven different IBM client accounts.
• Each account was very different including the version of DB2, ranging from v8 thru v10.
• Responsibilities included database maintenance, implementation of approved database changes, and database security.
• Responsibilities varied depending on account.

Confidential, Lanham, Maryland

Senior DB2 Database Administrator Consultant

Responsibilities:

• As a senior DB2 DBA Consultant at the Confidential, I was a member a team that was responsible for the maintenance of the Customer Account Data Engine (CADE2) DB2 database.
• We maintained tables that exceeded a terabyte with several hundred partitions duplicated in several environments that had varying user and maintenance requirements.
• Most of the maintenance tools were home grown REXX and CLIST. Other responsibilities include SQL tuning, backup, recovery, creating, modifying or dropping DB2 objects as needed; data cloning and statistics migration. for z/OS v9 with DB2 Connect is the database environment.
• We were required to work 24/7 shifts.

Confidential, Richmond, Virginia

Senior DB2 Database Administrator Consultant

Responsibilities:

• As a senior DB2 DBA Consultant at Confidential, my primary responsibilities included Development and Quality Assurance database administration support.
• The tools used were Omegamon, Erwin, IBM DB2 Administration, and File-AID for DB2.
• Other responsibilities included SQL tuning, backup/recovery, granting/revocation of DB2 user privileges, and creating, modifying and/or dropping DB2 objects as needed.

Confidential, Baton Rouge, Louisiana

Senior DB2 Database Administrator Consultant

Responsibilities:

• As a senior DB2 DBA Consultant at Confidential, my primary responsibilities included production/development DB2 database administration support.
• The tools used were Quest, Erwin, CA-Detector, CA-Migrator, IBM DB2 Administration Tool, and File-AID.
• Other responsibilities included SQL tuning, backup/recovery, granting/revocation of DB2 object user privileges, and/or creating, modifying or dropping DB2 objects as needed.

Confidential, Marysville, Ohio

Senior DB2 Database Administrator Consultant

Responsibilities:

• As a senior DB2 DBA Consultant at Confidential, my primary responsibilities were database development production support for the Global Production Control System (GPCS). GPCS was installed at several plants.
• Each system had several hundred tables, varying in size from a few thousand to several million rows.
• In addition to supporting GPCS database production and development,
• I also supported all other production DB2 databases when I was on-call every third week.
• The tools used were CA-Platinum, CA-Detector, CA-Migrator, Erwin, Omegamon, Visual Explain, and File-AID.

Confidential, Columbus, Ohio

Senior DB2 Database Administrator Consultant

Responsibilities:

• As a senior DB2 DBA Consultant at Confidential, my primary responsibilities were DB2 development/production support which included: application tuning, backup/recovery, granting and/or revoking user privileges, creating and/or dropping DB2 objects as required.
• The tools used were Ca-Platinum utilities, Erwin, Omegamon, and File-AID for DB2.
• Other responsibilities included DB2 application tuning, backup/recovery, granting/revoking of object/user privileges, and creating or dropping DB2 objects as needed. DB2 v6 with DB2 Connect was the Database environment.