OBJECTIVE/SUMMARY

I am a can do type individual. I have done development work in many environments. I have worked as a DBA using the following and not necessarily limited by: Oracle Data Base Analyst /Administrator, DB2 Data Base Analyst/Administrator, however primarily as ADABAS Data Base Analyst/Administrator, and can work in many other capacities. With 2 years' experience Oracle DBA, 1 year as a DB2 DBA. 36 years experience ADABAS DBA. 11 years of application program development using each of the mentioned databases. Ability to solve software related problems and issues. Perform software upgrades/updates to Database software, and Data Base Performing Tuning. Help solve day to day database related problems. Develop software tools and procedures to support Database ongoing support and maintenance.

PROFESSIONAL EXPERIENCE

Confidential, CalSTRS

• Continued working in many of the same aspects as listed with the experience below when working as a consultant for CalSTRS. After an extensive effort working with ADABAS Event Replication, with the loads of over 7 million updates per hour and current hardware configuration, determined that Replicator was not going to be able to process the load needed for a full replication of CalSTRS Production ADABAS database, with a target on Windows Enterprise Server 2008, and a 24 processor Wintel SAN supported environment, utilizing a 1 GB network connection. Continues to improve and enhance day to day operations and procedures for efficiency and ease of use. Continue to participate in Application software weekly migrations.
• Using all of the utilities available with ADABAS, and third party utilities manage the production database with largest files over 178million records, and many additional files of 100m records.

Confidential

Participated in the upgrade of Construct from V511 to V521 and recently to V531. Assisted in upgrade of ADABAS from V744 to V813, and Natural V424 to V425.

Confidential

CalSTRS

• Perform analysis of erratic previously unsolved Adabas Response Code.
• Participate in Application Software twice weekly migrations. Participate in performing file changes required from Applications.
• Tested a process of reorganizing a large Adabas file of 157 million records, saving 8 days of processing from previous technique used, new process runs in 24 hours.
• Analyzing Fastpath performance, monitoring performance, and making adjustments to Fastpath parms in an attempt to improve performance reducing calls and I/O's in Adabas.

Confidential

CalSTRS

• Was involved in the Construct upgrade, V511, with many customized models and frames. Tuned Fastpath to saving 15,000.00 a month in ADABAS costs.
• Found job that could benefit from a program change to use muti-fetch, and a better descriptor for the file access, saving 300,000.00 per year in Adabas Costs. Total annual savings in 1st year on contract is 550,000.00.
• Participated as main DBA, configuring Adabas Event Replication for replication to Windows Server platform. In Process of configuring environment to replicate 189 production Adabas files approaching 1 billion records in the database.
• Establish testing of ADABAS Event Replicator from Mainframe to Windows operating system.

Confidential

• Perform ADABAS DBA Tasks, Restructure Databases, Load Files, Diagnose and correct day to day problems. Act as an adviser to application developers, to improve Application program usage of ADABAS database resources, most of the improvements I recommended, reduced CPU time usage by 80 or more, and reduced elapsed run times of jobs and online transactions by 85 or more.
• Due to some of my efforts CPU reduction on the CPU was reduced 10 to 20 over 1.5 years of monitoring and implementing suggestions I made. Created an application using Natural V3 to capture ADABAS Nucleus shutdown statistics and store them into an ADABAS file, to be use for analysis of DB resources for 78 ADABAS databases. Assisted in System testing Natural Upgrades from V3.1.5 to V3.1.6 for 78 databases. Worked with CA-APAS Insight V3.1.5, CICS V1.4, Z/OS 1.4, ADASQL V2.2.1. Assisted in System testing of APAS/Insight V4.1.1 and Predict V4.3.2. Involved in Testing, Upgrading all Databases to ADABAS V7.4.3., Involved in implementation of FastPath V7.4.2. Participated in the investigation of upgrading Natural V3.1.6 to V4.1.4 with Natural Optimizer Compiler.

Confidential

• Performed two weeks of analysis of current mainframe environment in which to upgrade
• ADABAS V6.2.1, Natural V2.2.8 , Predict V3.4.1 to ADABAS V7.4.4, Natural V4.1.4, and
• Predict V4.4.1. Analyzed current Natural environment which was a mix of V1.1.x, V1.2.x,
• V2.1.x and V2.2.x set of Natural Source code. Created a project planned for the upgrade process.

Confidential

• Performed Oracle Data Base software upgrades from V8.1.7.0.0 to V8.1.7.4.1 and V8.1.7.4.11 on all 8 way DB Servers. More than 40 Data Base Servers were upgraded. V8.1.7.4.12 is currently being rolled out.
• Developed a tool using ACCESS 97/2000 to generate standardized TNSNAMES.ORA file for all server and client machines. Also used this TNSNAMES Access DB to generate DB Links to all servers. Developed a process to generate HOST file for Windows Advance Server for enabling GIGABIT IP networking facilities. A SQL script to validate/test Oracle DBLINKS.
• Developed several ACCESS 97/2000 programs to do data conversions downloads from mainframes to be loaded into Oracle DB's. Later converted some of these programs to Visual Basic V6.
• Wrote many PL/SQL programs to do OLTP for several HL7 transactions systems.
• Supported and coded a data conversion to Kaiser Pharmaceuticals Analytical Services system using Oracle V8.1.7, where data came originally from another incompatible system on SYBASE. SQL was the tool of choice for conversion.

Confidential

Provide DBA Support for a new project to develop a Web based Localization Authoring Tool LAT for Medical / Pharmaceutical personnel working with IBM DB2 UDB V7.2.2 on Windows 2000 Professional Server platform and IBM DB2 V6.1.2 on OS/390. Installed and used Erwin 4.0 to track all table changes within the LAT project. Provide DBA Support, established Master-to-Master Replication for new Development, and for TEST QA Systems. Established use of GUI Tools Oracle Enterprise Manager, some troubleshooting, using Oracle 8i, V8.1.7.0.0 and V9.2.0.0.0 on Windows 2000 Advance Server platforms.

Confidential

• Provided Senior DBA Support, monitored data center move of the ADABAS/Natural environment of client company, R. R. Donnelly. Acxiom acted as the Outsourcer.
• Trained Acxiom personnel in ADABAS DBA Skills, and ensured that the transition from previous outsourcer to Acxiom continued smoothly. Client was running ADABAS V6.2.1,
• and Natural V2.2.8. Used Zephyr TN3270 Emulation Software.

Confidential Contract Consultant,

Provided Senior DBA Support in upgrading to the latest versions of Software AG products in support of Student Information System. The upgrades involved were for the following products:

Confidential Contract Consultant,

Provided Senior DBA support for the entire worldwide organization. Over 90 databases with more than 2,000 files, on more than 30 platforms. MVS/ESA, CICS V2.1.3 and later versions, ADABAS V5.2.3 and later versions, PREDICT V3.1.3 and later versions, and Natural V2.1.7 and later versions. Used Irma 3270 Emulation Software.

Contract Consultant, Confidential

• Provided technical guidance using Natural/DB2, and re-engineered an online TSO/Nomad/
• Teradata system to CICS/TPF/Natural 2/DB2 for improved efficiency, faster response, and more flexibility in adding new users. Products used were Natural V2.2.7, DB2 V2.3 and V3.0, TPF V4.5.

Contract Consultant, Confidential

• Designed and developed an Executive Management Information System. Products used were Natural V2.2.4, V2.2.6, DB2, CICS, Construct V3.2.2, V3.3.1, PAC V1.3.1. This was one of the first projects to be completed early, and under budget. Made modifications and corrected
• programming deficiencies to Tour Group System, as per client's request. Assisted DBA staff with system problems relating to Natural V2.2.6 and ADABAS V5.2.5. Corrected problems in Multitrack timekeeping system. Wrote and tested conversion system to integrate all film products into a series of DB2 tables. Wrote several utility programs to report on cross-referenced data in Predict, and various other components in the system, as needed. Provided daily technical support for all Software AG products. Established PAC - Predict Application Control, and set up the production environment to be under the control of PAC. Conducted a training session on the use of PAC to an audience of 40 participants.

Contract Consultant, Confidential

Provided programming support for personnel on sick leave, using Natural V2.2.4, ADABAS V5.2.4, Natural Process, and Natural Connection.

Contract Consultant, Confidential

• Provided DBA support. Installed and converted Natural V2.1.7 to V2.2.4 into the production environment. Was responsible for day-to-day Natural and ADABAS questions and problems.
• Used ADABAS V5.1.8 and V5.2.3. Developed reporting capabilities for Natural Security V2.2.4 Software AG did not support batch reporting in this release .

Confidential

Contract Consultant

CWTAPPS project. Providing application's system support. Designing new software with NATURAL V2.1.7, Providing DBA support, restart/recovery, NATURAL Security, trouble shooting, assisting application developers with various problems and concerns.

Contract Consultant, Confidential

Provided application system support. Interfaced in-house written security system with Natural V2.1.4. Developed a message system, and was half of a team that developed a series of programs for providing a method of jumping from one Natural environment to another under CICS.

Contract Consultant, Confidential

Created a database application file integrity checking system for the Los Angeles Times Integrated Circulation Information System ICIS . Also, provided coverage for systems programmer while on vacation, and DBA support to the database administration staff. Was project lead and supervised the project working with one other person.

Contract Consultant, Confidential

Provided application maintenance and enhancements to ATM Card Production System. Made suggestions for future enhancements, improved existing structure for PL/1 programs. Wrote approximately 50 Natural V2.1.6 programs, many of which are used in the production system. Acted as liaison between ADABAS DBA staff and program development. Evaluated other vendor's software for potential candidates for conversion of current system. Assisted EDS in establishing transmission of data between data centers.

Contract Consultant, Confidential

• Provided database design, file design, system design, and program design for the development of the Integrated Circulation Information System. Installed Elite, Super-Natural V2.1.2 V2.1.3,
• Natural Security V2.1.2 V2.1.3, ADABAS CPO V4.1.10, and DBUG's SPACEMAN. Set up the main security profiles for Natural Security V2.1.2 and V2.1.3, and trained personnel in its use. Provided ongoing support for Production and Development Systems. Maintained six
• databases with several files in excess of 1.5 million records. Attended 100 internal and external walk-through sessions on system and programs during the design phase. In addition, attended 50 program walk-through sessions that averaged eight programs per session.

Contract Consultant, Confidential

With DEBUG APAS/Insight software, quality assured and avoided serious potential program performance problems from getting into the production environment. Improved production/development MPM JCL. Supported staff of 100 people in various roles

Confidential

management, the architect, system designers, program designers, programmers, and user liaison in all aspects of Data Base Analysis/Administration. Was one of four expanding to seven key personnel in this data administration department. Assisted in the conversion of ADABAS to Version 5. Created many JCL procedures for Version 5 conversion of Release 3A, which was successfully implemented in May, 1989.

Contract Consultant, Confidential

Provided database design, file design, system design, and program design for the development of the Schools Automation System. Supported a staff of two system architects, two systems designers, eight Natural programmers, and DBA. Acted as site DBA for the entire length of the contract. Phase 1 of the project was completed on time. Also, provided Natural Security support Natural V1.2.7 and ADABAS V4.1.1.