Administrator Database
Resume:
Stephen D. George
rd
***** ** ** ** ● Bellevue, WA 98004 ● 206-***-**** ● abno2m@r.postjobfree.com
An experienced mainframe data base administrator with recognized technical expertise
and innovative problem solving skills
SUMMARY OF QUALIFICATIONS
Over 25 years experience as an IMS data base administrator.
Certified by IBM as having Mastery of IMS Fundamentals, IMS Database
Administration and IMS Systems Programming.
Thorough technical understanding of IMS databases and performance factors.
Creative and innovative problem solver.
Excellent ability to communicate with people who have varying levels of
understanding of IMS technical issues.
PROFESSIONAL EXPERIENCE
DHL IT Services, Scottsdale, AZ (working remotely from Seattle) 2004 – Present
Database Administrator
Responsible for the IMS subsystems, databases and the utilities used to maintain them.
Leader in migration to NESI IMS tools, which saved on licensing fees.
Presented at Guide/Share Europe about NESI tools migration.
Used KBLA to provide exemplary documentation to IBM to debug IMS V9 code
defect.
Converted a database to HALDB in order to partition its secondary index.
Developed process to create an environment for DBAs to use to test utilities.
Conceived, designed & did proof-of-concept testing for a program revision that cut
run time from 24 hours to less than one.
Analyzed access patterns to one database and created a custom randomizer to
minimize the blocks scanned.
Airborne Express, Seattle, WA 1983 – 2004
Database Administrator
Responsible for the IMS subsystems, databases and the utilities used to maintain them.
Justified and implemented various IMS vendor tools.
Made numerous changes to processes to handle growing databases with shrinking
batch windows.
Evaluated available compression products and recommended we write our own.
Conceived & helped design an exit to dynamically allocate new OLDS datasets to
avoid system outages.
Key member of team that converted critical databases to Fast Path with indexing tool.
Key member of team that evaluated and implemented DB2.
Key member of team that implemented block-level data sharing.
Implemented DBRC registration for all databases.
Blue Cross and Blue Shield of North Carolina, Durham, NC 1980 – 1983
Database Administrator
Responsible for the IMS subsystems, databases and the utilities used to maintain them.
Solved performance problems in purchased Subscriber & Claims processing system
(LRSP).
Created process to allow starting the IMS batch monitor for jobs already running.
Learned to write programs in Assembler.
Learned to use the SAS language.
The Kemper Group, Long Grove, IL 1974 – 1979
Database Administrator
Responsible for the IMS subsystems, databases and the utilities used to maintain them.
Graduated near top of internal COBOL training class.
Designed and wrote IMS/TM system to track Guide/Share requirements voting.
Installed and maintained IBM's SMU-II pointer checker product.
Planned and implemented backup, recovery and reorganization jobs for all databases.
Wrote program to track distribution of child segments during load of Policy database.
EDUCATION
University of Illinois, Champaign-Urbana, IL
Bachelor of Science, Economics
Various industry-related courses & conferences.
COMPUTER SKILLS
IBM Mainframe z/OS, TSO, ISPF, SDSF, JCL, Assembler, COBOL, IMS, VSAM,
OSAM, DB2, SQL
SAS for z/OS
Neon Enterprise Software IMS utilities (Eclipse iRecover, iChange, iCopy, iUnload,
iLoad, iBuild, iExtract, Mission Control, Lightning X, DB Director)
BMC IMS utilities (Secondary Index Utility, LoadPlus, Image Copy Plus, Change
Accum Plus, Prefix Resolution Plus, Pointer Checker Plus, Unload Plus, MAXM,
Mainview for DBCTL)
Compuware FileAid and FileAid for IMS
Allen Systems DataManager
Microsoft Windows, Office, IE
KEYWORDS
IMS, Assembler, JCL, SAS, DBRC, DBA, COBOL, CICS, DBCTL, IMS/TM, Fast Path,
DEDB, HALDB, TSO, ISPF, BMC, Neon, NESI, MVS, z/OS, SDSF, ASM, IBM,
Mainframe, performance, KBLA, Programmer, Hierarchical, tuning
Contact this candidate