| TECHNICAL PROFILE | Software: | SQL, DB2, IMS DB/DC, SQL Server 2000, Ver 7, Ver 6.5, Platinum Utilities, BMC Utilities, Erwin, File Aid for DB2, IMS, ISPF, TSO, JCL, CLISTS, DYL280, COBOL, COBOL II DB2 Connect Ver 7.2, DB2/2, DDCS/2, DB2/6000, DDCS/6000, DB2/6000 PE, ORACLE SQL, PL/SQL, ORACLE 8 Database Admin, ORACLE 8 Backup & Recovery, ORACLE 8 Networking, PeopleSoft Software | | Hardware: | IBM 3090, Amdahl, Compaq, Hewlett Packard, Gateway 2000 | | Operating Systems: | OS/390, MVS, AIX/6000 4.2, Windows 95/98/NT/2000/XP, DOS, OS/2 | | NetWare Systems: | IBM LAN Server 2.0/3.0, Novel 3/11 | | Internet Web Tools: | NetObjects Fusion 4.0 / 5.0 / 7.0 | | Case Tools: | Bachman | |
| PROFESSIONAL EXPERIENCE INGRAM MICRO, INC., Santa Ana, CA 2000 – 2003 ACS, INC., Dallas, TX – Outsource Agreement (2003) Senior IMS / DB2 DBA Responsible for all production IMS databases within the company, providing 24x7x365 support, database conversions to OSAM access method, consulting to the applications development group, performance and tuning of IMS applications, installation of the BMC IMS database utilities, and cross training. - Directly responsible for developing and implementing all backups and Disaster Recovery jobs for all production IMS databases. Directly involved with all Disaster Recovery offsite testing.
- Assisted with installation of IMS V7.0, DBRC, and data sharing within a sysplex environment.
- Directly responsible for the migration/installation/maintenance of DB2 Connect V7.2 Fixpak 7 onto several different servers.
- Successful migration/installation of over 75 SQL servers (SQL 2000, Ver 7, Ver 6.5) within a tight three-month deadline. This migration involved moving physical servers from California to Dallas, TX and doing the installation remotely. Also involved migrating and building all data, backups/recoveries and user security profiles..
|
 | | AMERICAN CENTURY INSURANCE, Kansas City, MO 2000 Senior DB2 DBA Consultant assigned to support applications development group, providing modifications to existing DB2 tables and databases, new software installations, and production support, as well as providing system cleanup. |
| GEO LOGISTICS CORPORATION, Murietta, GA 2000 DB2 DBA for RISC 6000 and PeopleSoft Software - Responsible for providing support for the applications area using PeopleSoft software.
- Configured a RISC 6000 box with 6 nodes, each running AIX 4.2 and DB2/6000 5.0.
- Provided support for the print services manager on the AIX system and the Legato Tape Management system.
|
| LOS ANGELES CITY DEPARTMENT OF WATER AND POWER, Los Angeles, CA 1998 – 1999 Consultant, DBA Group for the Y2K Project DB2 DBA responsible for providing the applications area with various IMS and DB2 test systems in support of the Y2K project. - Utilized Platinum Utilities for DB2 to migrate complete DB2 applications form the production subsystem to a Y2K test subsystem.
- Utilized Compuware File-Aid for IMS Utilities to migrate complete IMS systems from production to a Y2K test system.
- Improved performance of IMS and DB2 systems as needed during the Y2K testing.
- Provided the applications area with training in the use of the IMS Compuware File-Aid Utilities and DB2 Platinum Utilities.
|
| KAISER PERMANENTE, Pasadena, CA 1996 – 1998 Consultant, Applications Areas Medical Reporting System (1997 – 1998) Responsible for the support and enhancement of the existing Medical Reporting system. - Modified the Import Eligibility Process, reducing the time for imports from over 24 hours, to fewer than three hours, processing 15,000 records.
Sales/Marketing New Group Processing (1996 – 1997) Responsible for developing various DB2 batch reporting programs. - Developed automated DB2 process for delivering New Membership Packages in both a timely and cost reducing fashion.
Online Patient Appointment Scheduling (1996) Responsible for developing Batch DB2 auditing programs for tracking errors produced by the Online Scheduling system. |
| CARTER HAWLEY HALE STORES INC., Anaheim, CA 1982 – 1996 Information Management Specialist (Senior DBA) (1990 – 1996) Responsible for migrating DB2 databases from one subsystem to another, both on the same physical machine and on different machines using the Platinum Utilities for DB2. - Provided 24x7x365 support for all production IMS and DB2 databases for the entire company.
- Analyzed, created, executed, documented, and verified DB2 reorgs, image copies, and recoveries for all DB2 databases on all DB2 subsystems.
- Created indexes as needed for performance improvements on DB2 tables.
- Generated the DDL, views, and aliases for all DB2 tables within the various DB2 databases for all DB2 subsystems.
- Developed, tested and implemented a Disaster Recovery system for the entire company.
- Performed offsite testing of the Disaster Recovery system to ensure that all DB2 tables and IMS databases were recovered successfully, and that all applications functioned correctly on the offsite host.
- Developed and programmed a DB2 system that automatically kept the DB2 catalogs in sync with the MVS catalogs for all recorded recovery datasets resulting in savings of approximately $40,000 annually.
- Developed and programmed a DB2 system that automatically kept track of all DB2 packages, purging those that were more than three versions old.
- Developed and programmed an IMS system that generated all Program Source Blocks (PSB) and Database Definitions (DBD) from object code whenever a new division was installed. The program saved a total of 80 hours of manual work (two people, 40 hours each).
- Configured and installed a Local Area Network for the development team which was composed of a single fileserver and 20 workstations.
- Developed and programmed an application that used Distributed Database Connection Services (DDCS/2) installed on the fileserver to update host DB2 tables. The system kept track of LAN workstation parameters and generated needed reports.
Manager Production Support (1985 – 1990) Managed a group of seven people responsible for maintaining the IMS Production Databases, and ensuring availability at all times. - Developed and implemented a schedule for purging and reorganizing the IMS databases on a monthly basis.
Senior Data Base Analyst (1982 – 1985) Responsible for the installation and testing of DBRC (Database Recovery Control) for IMS that monitored all production databases and kept track of activity against each database. - Developed and implemented a backup and recovery system for all IMS databases.
- Developed the batch jobs and procedures for backing up and restoring the IMS databases.
- Developed procedures for having all batch update jobs perform backouts when the updates aborted.
- Provided training to the development team for implementing the backouts in their production batch update jobs.
|
| PREVIOUS RELEVANT EXPERIENCE COUNTY OF RIVERSIDE Data Processing Data Base Analyst EDUCATION Continued Education, Cal Poly University, Pomona, CA Associate Arts Degree, Computer Science, Riverside City College, Riverside, CA |
|
| Last Updated December 15, 2003 9:30am |