Database Administrator Resume Profile Little Ferry, NJ - Hire IT People

OBJECTIVE

To enhance the ability of a business to reach its goals by utilizing over 30 years experience in Database Administration and Management.

SUMMARY

Hardware:

Software:

IBM Mainframes

IDMS thru 18.5 , IDMS Server, SYSGEN, SCHEMA, SUBSCHEMA, and DMCL compilers, IDMS/SQL, CA Visual DBA, CA Quick Bridge for Table Procedures, IDD, OLQ, UCF, ADS/O, ADSA, CULPRIT, IDMS Utilities, ENDEVOR, DML/O, MIGRATOR, JOURNAL ANALYZER, DBAUDIT, DBREORG, TASK ANALYZER, ADS/ALIVE,VEGASOFT VEGA90s, PREALERT, FAST ACCESS, DB2 UDB for Windows, EASYTRIEVE , TCC, TSO/ISPF, OS JCL, OS Utilities, SMP/E, SDSF, COBOL OS/VS THROUGH 370 , VSAM, CICS, TMON, FDR, LIBRARIAN, EMC TIMEFINDER, VISIO, EXCEL, WORD, etc.

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Monitored all 5 CVs.
Performed normal maintenance and tuning functions: area expands, page expands, index rebuilds, unloads/reloads etc.
Installed new releases and fixes via SMP/E for both IDMS and CA Common Services CCS .
Created a SQL compatible network schema to be used by IDMS SQL to access all records in the active IDMS network database.
Maintained the CA LMP License Management Program keys.
Created a Production Mirror Image Database that gets refreshed and rolled forward nightly for debugging Production problems without affecting the live Production Database.
Provided SQL access to the network schema for Java application development.
Provided SQL access to VSAM file data using IDMS SQL, ODBC, and TCP/IP.
Tuned SQL queries developed by application programmers.
Provided 24 hour support.
Implemented application requested changes.
Supported TCP/IP access using JDBC Type 4 drivers.
Supported ODBC access using CCI and TCP/IP.
Wrote SQL Table Procedures for Network Database access.
Wrote Database Procedures for asynchronous delta updating of a SQL Server database.
Created unified COBOL compile PROC to handle all variations of COBOL programs.
Wrote a REXX EXEC to facilitate COBOL turnovers into Production.
Automated journal and log job submission and nightly consolidation of journals to tape.
Created flexible backup and restore jobs for the IDMS databases to handle daily, weekly, monthly, and yearly scenarios.
Modified Health Checker parameters to output fewer messages to the console.
Provided guidance to programmers writing IDMS SQL programs and Table Procedures.
Wrote and executed a REXX EXEC to find, change, and re-compile all COBOL programs that had IDMS field names longer than 31 characters which cause a C level, condition code 8, COBOL compile error.
Renamed schemas, subschemas, files, DMCLs, segments, and DBTABLEs to conform to simple and clear naming conventions and standards. Wrote a REXX EXEC to adjust the affected programs.
Wrote a program to summarize area utilizations and flag areas that are getting full.
Created a Bachman diagram using Visio to be able to visualize the Production IDMS Database.
Created refresh jobs for different databases and sections of different databases, if required and if possible.
Moved the IDMS scratch area from disk to XA storage.
Documented the changes I made and the parts of the system I was responsible for administering.
Worked with the programming staff on debugging COBOL programs.
Identified bad data on the database causing SQL to malfunction.
Created shutdown programs to provide statistics prior to bringing down the databases.

Confidential

Database Administrator

Monitored all 12 CVs.
Provided 24 hour support.
Implemented application changes in the Test environment.
Directed the NBC process of moving changes from the Test to Production databases using CA-ENDEVOR.
Supported Vegasoft which is used communicate between IDMS and non-mainframe, distributed databases.

Confidential

Database Administrator

Supported DB2 programming staff.
Managed the DBA staff overseeing the IDMS databases and the reporting DB2 database.
Designed a methodology to manage the many discrete MS-ACCESS databases in use throughout the company.
Redesigned parts of the IDMS network database to utilize SQL to promote platform independence.
Installed IDMS 14.1 on all CVs and 15.0 on the tech CV.
Upgraded the system for Y2K.
Trained an assistant DBA.
Gave classes on IDMS programming to staff.
Provided 24x7x365 support for all databases under our control.
Set up an easily maintainable IDMS environment.

Confidential

Senior Database Administrator

Supported all IDMS CVs.
Installed all IDMS and related software, fixes, and upgrades.
Performed UNLOAD/RELOADS INDEX REBUILDS PAGE EXPANDS RESTRUCTURES SYSTEM GENERATIONS SCHEMA, DMCL and SUBSCHEMA COMPILES MIGRATIONS TO PRODUCTION IDMS/CICS/UCF PRINTER SUPPORT DATABASE BACKUPS/RESTORES ROLLBACKS ROLLFORWARDS etc.
Applied database security.
Provided 24-hour support for Production and applications programming.
Worked with Systems Programming on DASD management.
Developed PROCS to facilitate the use of IDMS.
Participated in physical database design.

Confidential

Senior Database Analyst

Supported all IDMS CVs.
Performed logical and physical database designs and application design reviews.
Performed a subset of all the tasks mentioned above.

We provide IT Staff Augmentation Services!

Database Administrator Resume Profile

Little Ferry, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship