SUMMARY:

IDMS Systems Programmer & DBA with over 25 years of progressive mainframe, Client Server, and desktop systems, database and application experience. Related experience in application development in Assembler, Cobol, ADS/O, Culprit SQL, and software engineering encompassing all SDLC phases surrounding database administration, system analysis and design, software design, implementation, integration, conversion, system/unit/QA testing, support and documentation for online and batch systems. Environments include CA - IDMS, DB2 on z/Series OS and AIX/UNIX with Oracle. Have performed hundreds of software upgrades; performance tuning and level II technical support. Performance of related technical studies, requirements gathering, logical and physical data modeling. Design and modification of database structures, system catalog, and data dictionary. Definition of users, resources to security systems; monitor/control of resource usage and user access.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Responsibilities:

• Prosecuted information technology patent applications on a part time basis (between database consulting projects) for software and microprocessor inventions.
• One example “Big Data” patent recently issued by the United States Patent and Trademark Office is attached.

Database Consultant

Confidential, Clinton, NJ

Responsibilities:

• Performed R19 CA-IDMS upgrade testing & DBA activities including database and application migrations with Endevor, restructures, reorgs, etc. Sole DBA for 20 IDMS CVs.

Database Consultant

Confidential, Horsham, PA

Responsibilities:

• IDMS Systems Administration, Maintenance and 24/7 support for CA IDMS R16.x and third party vendor products.
• Providing backup and recovery procedures to minimize data loss and maximize database availability. Verification of ZOS Upgrade compatibility.
• Monitoring, Tailoring, Performance & Tuning, Maintaining, & Upgrading database software to meet business needs when required.
• Upgraded CA-TOOLS & CA-IDMS Rel. 14.1 to 16.0 SP3 and documented a procedural upgrade plan to get the release into production.

Database Consultant

Confidential, Livingston, NJ

Responsibilities:

• Supported corporate systems programming group in the application of frequent maintenance to DB2 under z/OS, monitored and documented CA-IDMS production systems, performed testing of cloned LPARS at offsite disaster recovery data center.

Database Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Performed Database Administration tasks for a major new release, down to adding the elements with comments and some data modeling; Applications Programming and testing for CA-IDMS Rel.
• 16.x on the mainframe and Oracle 9i on a Sun Solaris network.
• Worked a little bit with ERWIN. Prepared a Data Base Network diagram for distribution throughout IT for the software release enhancement.
• Worked with Oracle Enterprise Manager (OEM), SQL Navigator and the SQL Option, TCP/IP, JDBC and Quick Bridge CA-IDMS products on the mainframe.

Database Consultant

Confidential, Dallas, Texas

Responsibilities:

• Performed Systems Programming, Database Administration, Applications Programming and Project Management for CA-IDMS, DB2, and Oracle database systems in all operating environments (i.e. z/OS/390/MVS/ESA and AIX/UNIX) and under all major security environments (i.e. ACF/2/RACF/Top Secret).
• Performed 24 x 7 IDMS DBA support functions including unload/reloads of 55 Customer Accounts databases, disaster recovery, applying database changes to support development utilizing most all IDMS utilities.
• Converted all Fast Dump Restore JCL to DFDSS, maintained COBOL and ADS/O code and performed routine DBA functions. Used Batch Cobol/IDMS and Culprit to Extract and Reformat IDMS mainframe data into flat files for transport and loading into Sybase UNIX databases.
• Unloaded/Reloaded mega IDMS segmented databases, performed routine DBA functions for 24 x 7 on call support and database changes.
• Installed and upgraded several IDMS CV's using SMP/E, including all interfaces to Tact Software, CICS, DB2 and mainframe Oracle, applied APARS as needed.
• Upgraded several IDMS CVs and supported an IDMS CAS Manufacturing Conversion to the latest release level.

Confidential, Ft. Wayne, Indiana

Principal Oracle DBA

Responsibilities:

• Manufacturing dates to 8 bytes for Y2K compliance using IDMS Restructure and Unlo/Relo utilities, corrected errant COBOL application code which was filling up database areas, trained new Oracle DBA.
• Performed Oracle DBA functions on eight Shop Floor RS/6000 AIX systems which continuously extracted data from mainframe OS/390 IDMS databases using MQ Series.
• Wrote PL/SQL code, supported the development code written in MF/Cobol, and tuned the various systems manually, and with the help of Oracle Enterprise Manager.
• Upgraded over 70 IDMS CV's from Release 10.xx to Release 12.xx for Y2K compliance, including security.
• Ensured appropriate APARS were applied using SMP/E to resolve storage violations. Worked with applications people and IBM Global Services to migrate data across mainframes using DFDSS and to ensure that IDMS was installed properly under SMP/E.
• Upgraded entire Test/QA/Production IDMS environment to IDMS Release 14.1, and helped upgrade Payroll application for IBM's Language Environment with application staff. This was OS/390 under VM using Panvalet as editor.
• Recently converted several Natural/Adabas batch programs to Cobol/IDMS and updated/tested various batch COBOL programs according to new release Specifications. Wrote Culprit programs to retrieve complex test cases for QA. Remotely upgrade 3 IDMS CV's from IDMS Release 10.0 to 14.1, including Security, for Y2K.

SENIOR DATABASE ADMINISTRATOR

Confidential, D/FW Airport, Texas

Responsibilities:

• Performed Project Management functions within the DBA group and attended various Systems Project Management Courses such as the McDonnell Douglas STRADIS Systems Development Methodology course.
• Performed capacity management, emergency database conversions and consulting support for DBA staff.
• Provided second-level critical support for various Integrated Database Management System (IDMS) Production Systems on a 24-hour on-call basis.
• Represented GTE at Computer Associate's User Conventions (1989 Atlanta; 1990 Washington, D.C.).

SYSTEMS PROGRAMMER

Confidential, Plano, Texas

Responsibilities:

• Performed Technical Project Leader and Administrative functions such as leading weekly teleconferences with Project Managers and Systems DBA’s throughout EDS and was principal author of the IDMS Planning Guide.
• Performed Corporate Software Systems Maintenance, Quality Assurance Testing, Distribution, and Consulting Support for the Confidential IDMS/R product line installed in MVS/XA/ESA environments at EDS data centers worldwide.
• Gave technical presentations on Corporate Software functions and IDMS/R product capabilities for various groups within EDS. Performed consulting activities for the ADABAS and DATACOM DBMS software products.