Consultant Resume

SUMMARY:

An IT professional specializing in database technology wif over 30 years as an IMS DBA and 15 years as a DB2 DBA, I has a strong background in IMS and DB2 database design
I also has experience wif several relational DBMS's including ORACLE.to develop and market tools for IMS and DB2 DBA’s

TECHNICAL SKILLS:

HARDWARE: IBM Mainframe, PC

SOFTWARE: IBM z/OS, IMS 10.1, DB2 9.1, REXX/CLIST, SQL, QMF, ASSEMBLER, COBOL, TSO, MS DOS, WINDOWS XP, OS/2, CA and BMC products, ChgMan and Endevor change management software. IMS/DB2 DBA support for multiple IMS/DB2 production, QA and development environments including 24/7 on - call support. Supported implementation of NPI (Non Public Information) project dat masked sensitive clien

PROFESSIONAL EXPERIENCE:

Consultant

Confidential

Responsibilities:

HALDB IBM’s High Availability Large Database (IMS partitioning) for a database dat reached the 8gb limit.
SMS (System Managed Storage) to eliminate out-of-space conditions and the need to manage database DASD.
DBRC to maintain integrity and availability of databases.
New utility procedures and JCL using database dynamic allocation for approx 60k utility jobs.
Implemented BMC utilities including Change Accums resulting in process improvements saving MIPS and optimizing batch windows.
Wrote in-house software to generate database utilities for over 10k databases as well as DBRC and dynamic allocation components

C onsultant

Confidential

Responsibilities:

Performance/tuning using Omegamon and analyzing application code. Maintained randomizer parameters to provide optimum database performance.
Maintained partitioning for large databases.
Designed IMS partitioning algorithm for rolling 13 months data.
Created and maintained schedule for JCL for reorgs, local and off-site backups.
Created and maintained DDL for DB2 objects - stogroups, databases, tablespaces, tables and indexes.
Developed and implemented backup and recovery strategies including Disaster Recovery for approx 750 gb of data.
Developed software to generate utility JCL for ad hoc and scheduled jobs for any vendor’s utilities (IBM, BMC CA) for image copies, reorgs, recoveries etc. Successfully recovered IMS and DB2 databases for Disaster Recovery exercise at Comdisco for five successive years.
Very familiar wif BMC products, Copy Plus, Change Accum Plus, Recovery Plus etc.
Created and implemented logical and physical database design for new databases.

Consultant

Confidential

Responsibilities:

Provided central DBA support for 11 production billing systems running in four data centers;
Supported development and test environments.
Participated in logical and physical database design for complete re-write of system.
Developed SQL based analysis tools for logical and physical database design. Evaluated and implemented software packages such as BMC's Image Copy Plus, Pointer Checker Plus and Recovery Plus.
Supported split of billing system into Toll and Equipment billing systems and consolidation of equipment billing system from eleven to four physical systems.
Developed strategy for and implemented database Disaster Recovery plan for billing application.
Evaluated Relational Database Management Systems (Oracle and Sybase) for mid-range processors in an AT&T UNIX environment and made recommendation to upper management.

Consultant

Confidential

Responsibilities:

creation of clists for generation of backup/recovery JCL
BTS simulation control block gens
Programmer support
Database tuning

Confidential

DBA Manager

Responsibilities:

Taught database portion of Application Development Methodology.
Made recommendations to upper management regarding strategic data planning and direction.

Senior Technical DBA

Responsibilities:

Designed and implemented and supported of DL/I databases for manufacturing, materials management, A/R, HRS and payroll databases.
Implemented DL/I features such as logical relationships, secondary indexes, edit/compression routines, etc. Employed structured database design methodology based on third normal form data.
Acted in consulting role wif applications development in systems design and implementation.
Supported 22 hr. IMS/DC region for database backup, restart/recovery, performance and tuning and several CICS/DL/I regions (database and table support).
Developed logical database design for entire distribution system which included customer master, customer profiles, A/R, order processing, warehousing, promotions, item master, etc. This model encompassed approximately 60% of the DP systems tan in place at Mars Inc.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship