IMS & DB2 Database Specialist Resume

PROFESSIONAL SUMMARY:

Have 32 years of experience as a mainframe IMS/DB2 DBA at a major retailer, and 34+ years of total IT experience. Responsibilities include the development & maintenance of IMS databases & DB2 tablesdeveloper support, problem resolution, data administration and procedure documentation. Recently involved in the conversion of BMC suite of products to IBM’s offerings. Conscientious, thorough and possesses excellent team - working skills.

SUMMARY:

IBM z/900 Series mainframe processors
Mainframe z/OS V1.13, JES3, RACF
DB2 for z/OS V10, SQL, SPUFI, QMF, DB2I
BMC/DB2 utilities (Copy+, Recover+, Unload+, Reorg+, Load+, XBM, Apptune, Catalog Manager)
IBM/DB2 utilities (Copy, Reorg, Unload, Load, Recover, UET)
IMS V13, DBRC, DLI, MPP, MFS, BTS, ADF
BMC/IMS utilities (ImageCopy+, Recovery+, Maxim Reorg/EP, Pointer Checker+, Datapacker)
CA - Endevor (SCM), View, Vision/Quickjob, TopSecret, Roscoe, Panvalet, Librarian
TSO/ISPF, JCL, HSM, TMM, ABARS, TWS/OPC, TEFE
Compuware - Fileaid XE/DB2/IMS, Xpediter, Abend-Aid, Strobe
OMC/Flash, CMOD, IOF, $AVERS
ASG TMON DB2/MVS, Omegamon MVS/DB2/IMS
Sybase PowerDesigner V16
PeopleSoft V.8
OS/VS COBOL, Vision/Quickjob, MARKIV
MS Office - Outlook, Word, Excel, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidentia

IMS & DB2 Database Specialist

Responsibilities:

Performed operational DBA duties.
Projects include conversion of BMC to IBM utilities, support of applications systems including Merchandising, Allocation, Inventory, Pricing, Replenishment, Forecasting, Vendor Processing, Financial systems, and PeopleSoft.
Responsibilities involve DB2 object creation/modification, maintaining utility jobs, daily problem resolution, software testing, performance analysis, and Disaster Recovery.
Performed DBA duties for IMS that involve the maintenance of over 600 full function databases (HIDAM, HDAM, HISAM, and SHISAM) for online & batch access.
Major projects include adding BMC software compression to eligible databases, Y2K Testing, and Disaster Recovery. Ongoing support involves maintaining BMC utility jobs and database recoveries using DBRC.

Confidential

IMS Database Administrator / Technical Services Application Support

Responsibilities:

Involved in the consolidation of the Distribution Center.
Support of the DC-IMS system (online & batch), coordinating Disaster Recovery testing, and support of orphaned software from the defunct data centers.

Confidential

IMS Database Administrator

Responsibilities:

Performed DBA duties for over 300 full function IMS databases.
Duties include adding/changing IMS database, index, and segment structures (DBDs), developing/maintaining batch utility jobs, generating PSBs, and problem resolutions.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship