System Data Base Administration Resume Profile
OBJECTIVE: To work for a progressive organization where current management and Information Technology Operations/Support skills remain a challenge and growth within the organization will be an asset as we grow together in this rewarding environment.
COMPUTER SKILLS
- Years/months experience in brackets
- Mainframe Environment: OS/390/ZOS 17yrs /MVS/JES2/TSO/JCL 17yrs SMPE 20yrs
- DOS/VSE SP ESA 26yrs VM 10yrs MSHP 10yrs
- M/F Languages: COBOL 22yrs ASSEMBLER 20yrs EASYTRIEVE 12yrs
- SQL 4yr ADSO 15 CULPRIT 20 SAS 1
- M/F Databases: IDMS 32yrs IDMS SERVER 2 DB2 3yr MICROSOFT ACCESS 2yr , DATACOM 2 yrs M/F Software: CICS 22yrs VSAM 29yrs CAYENNE modeling for DB2 3mth , ACF2 2yrs , Endeavor 3 yrs , FileAid 2years , CA Products 20yrs , other third party products 20yrs
- M/F hardware: XEROX MF IBM 360/30 360/40 S390 DEC IBM AS400 System 36,38
- Micro Environment: DOS 1yr OS2 1yr WINDOWS 24yrs SERVERS 6yrs
- MICROSOFT OFFICE PRODUCTS 15yrs
EXPERIENCE
IT industry - over 40 years of Information Technology experience covering most spectrums of manufacturing and government agencies state and federal and USDA IDMS database administration.
Confidential
HPES/TEKsystems Contractor
- IDMS Systems Administration, Maintenance and 24/7 support for CA IDMS R17. And for APLUS, CCDB, CDS, CAS, CASH, CUMC, MTPDSP, FMS, GIMS, PCIMS, AND ST/CNTY IDMS ADSO and Cobol Databases and assisting development team with the Y2K revision project of APLUS database to correct the 50/50 rule .which is no longer valid due to changes in application requirements in the Automated Public Law 480 Umbrella System.
- Respond to performance issues. Perform database administration tasks for new and existing tables, including back up, replication, restore and security.
- Coordinate with Development teams, Business Users, and Infrastructure teams to implement
- performance changes, database changes, and system upgrades.
- Strong written and verbal communication skills
- Basic Database Administration: Backup Database, Restore Database, Restructure a database record, Unload/reload an area, Expand an area, Change IDD Work Records, Migrate Dictionary Entities
- Security: Define/update groups, Define/update/delete users, ACF2 Dataset Rules.
Confidential
DISYS Contractor
- MVS/OS390/ZOS - IDMS
- Duties include:
- IDMS Systems Administration, Maintenance and 24/7 support for CA IDMS R16, 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.
- Download and preparation for installation of CA IDMS R18 using CA MSM and SMPE. COBOL shop, no ADSO, customer handled all development work, only assisted with debugging problems..
Confidential
Digitek Software, Inc. Contractor
- MVS/OS390/ZOS - IDMS
- Duties include:
- IDMS Systems Support. Providing 24/7 on call support for IDMS R15 with CA and Vendor products. Providing recovery procedures to minimize data loss and maximize database availability.
- Member of IDMS systems support team for Department of Workforce Development customers and their data processing staff and end-users, trouble-shooting, and working with vendors, providing timely resolutions and assisting with their conversion to DB2.
- Monitoring, Tailoring, Performance Tuning, Maintaining, Upgrading database software to meet business needs.
- Perform Installation, administration and maintenance of third party products using SMPE.
- Obtain and update license keys for third party products for renewal and CPU hardware changes. PMDC, Fast Access, ASI2
- COBOL shop, no ADSO. customer handled all development work, only assisted with debugging problems..
Confidential
TEKsystems Contractor
MVS/OS390/ZOS - IDMS
Duties include:
- IDMS Systems Support and Research for special project to rework their test system to make it the same size as their production systems for the ability to restore the production system to test system at any given time.
- Monitoring, Tailoring, Performance Tuning, Maintaining, Upgrading database software to meet business needs.
- Setting specific database team objectives based on business need, customer feedback, Information Technology objectives, and measuring progress towards those objectives. Not involved in Development of database applications.
Confidential
CDI Corporation Contractor
MVS/OS390/ZOS - IDMS
Duties include:
- IDMS Systems Support. Providing 24/7 on call support for IDMS R16, R17 and CA products. Providing recovery procedures to minimize data loss and maximize database availability.
- Member of IDMS systems support team for IBM Global customers and their data processing staff and end-users, trouble-shooting COBOL applications, customer did not use ADSO and working with vendors, providing timely resolutions
- Monitoring, Tailoring, Performance Tuning, Maintaining, Upgrading database software to meet business needs. SYSGEN, OCF, PMRM, PMDC, PREALERT, VEGA90'S, FAST ACCESS
- Installation, administration and maintenance of third party products using SMPE. Obtaining and updating license keys for third party products for renewal and CPU hardware changes.
- Setting specific database team objectives based on business need, customer feedback, and Information Technology objectives, and measuring progress towards those objectives.
- Technical Support Specialist/IDMS Database Administrator
Confidential
MVS/OS390/ZOS - IDMS
Duties include:
- Performing DBA activities including SYSGEN, OCF, IDD, SCHEMA, DMCL, SUBSCHEMA modifications
- Performing database restructures unloads/reloads, system generations, performance and tuning in IDMS 15 and IDMS 16 environments.
- Developing and testing JCL procedures, COBOL application changes, backups, and recoveries.
- Monitoring, Tailoring, Performance Tuning, Maintaining, Upgrading database software to meet business needs.
- Monitoring database usage levels and planning for future capacity.
- Work with data processing staff and end-users trouble-shooting, and providing timely resolutions.
- Installation, administration and maintenance of third party products using SMPE. Obtained and updated license keys for all third party products for CPU hardware change.
- Set specific database team objectives based on business need, customer feedback, and Information Technology objectives, and measuring our progress towards those objectives.
Confidential
IDMS Data Base Administrator
Duties include:
- Performing DBA activities including SYSGEN, OCF, IDD, SCHEMA, DMCL, SUBSCHEMA modifications
- Performing database restructures unloads/reloads, system generations, performance and tuning in IDMS 15 environments and preparing IDMS 16.
- Providing 24/7 on call support for IDMS recovery procedures to minimize data loss and maximize database availability.
- Monitoring, Tailoring, Performance Tuning, Maintaining, Upgrading database software to meet business needs.
- Developing and testing JCL procedures, COBOL and ADSO application changes, backups, and recoveries.
- Monitoring database usage levels and planning for future capacity.
- Working with data processing staff and end-users trouble-shooting, and providing timely resolutions.
- ACF2 maintenance - change rules, resources, keys to meet Sarbanes-Oxley compliance.
- Document/perform Sarbanes-Oxley procedures for compliance.
- Perform application services using Sarbanes-Oxley procedures in IDMS environments.
- Installing and maintaining third party products like TFast Access Products from ASG.
- Setting specific database team objectives based on business need, customer feedback, and
- Information Technology objectives, and measuring our progress towards those objectives.
Confidential
IDMS Data Base Administrator
Duties include:
- Performing DBA activities including SYSGEN, OCF, IDD, SCHEMA, DMCL, SUBSCHEMA modifications
- Performing database restructures unloads/reloads, system generations, performance and tuning in IDMS 15 environments and preparing IDMS 16.
- Providing 24/7 on call support for IDMS and DB2, recovery procedures to minimize data loss and maximize database availability.
- Document Sarbanes-Oxley data repair procedures for compliance.
- Perform application services using Sarbanes-Oxley data repair procedures in IDMS and DB2 environments.
- Tailoring and maintenance of in house and purchased Software Systems and the interface with other database technologies IDMS, DB2, IMS, Oracle, etc.
- Installed and maintaining Tracer Products from ASG and procedures to track database changes.
- Developing and testing JCL procedures, backups, and recoveries.
- Activities include: Monitoring, Tailoring, Tuning, Maintaining, Upgrading database software to meet business needs using SMPE.
- Monitoring database usage levels and planning for future capacity. Tuning the system to
- ensure optimum performance and to meet business needs. Working with the data processing staff and end-users trouble-shooting, and providing timely resolutions.
- Consulting with Applications Personnel on COBOL and ADSO database issues redesigns, expansions, new development, interfaces, etc.
- Setting specific database team objectives based on business need, customer feedback, and
- Information Technology objectives, and measuring our progress towards those objectives.
- Provided technical leadership on other assigned tasks and fill-in as Endeavor Administrator.
Information Technology Systems Programmer
Confidential
Duties include:
- Installation and maintenance of system software CICS, CA Products, IBM Products, DATACOM, other vendor products and operating systems in multiple OS/390, VSE, and VM platforms using SMPE product installations and maintenance of mainframe tools and products.
- Providing On Call support for Mainframe operating systems, troubleshooting, and documenting the events and resolutions needed to resolve problems and requests for services on various platforms.
- Working in a team environment to modify and enhance the existing operating systems.
- Working within IT team environment to evaluate, design, and plan implementations of new versions of products as released and maintain existing versions.
- Working with users to resolve problems using available debugging tools, ensuring user requirements are met, and develop, implement, and provide training.
- Providing technical leadership on other assigned tasks, and backup support for IDMS problems and installations.
Information Technology Specialist/Analyst
Confidential
Duties include:
- Working in a team environment to modify and enhance the existing business systems, the order management system, and the long term roll information systems written in CICS/IDMS and DB2 COBOL.
- Activities include: Working with users and IT to evaluate, design, and write specifications for new systems. Working with IT team to develop, implement, and provide training for use. Working with users to ensure user requirements have been met. Working with users to resolve problems using available debugging tools. Document all work in accordance with established standards.
IDMS Database Administrator
Confidential
Duties Include:
- Performing DBA activities including SYSGEN, OCF, IDD, SCHEMA, DMCL, SUBSCHEMA modifications
- Performing database restructures unloads/reloads, system generations, performance and tuning in IDMS 12.01 environments and preparing IDMS 12.01 for Y2K.
- Installation and maintenance of IDMS Systems and the interface with
- MVS, CICS and other database technologies DB2, IMS, Oracle, etc.
- Developing and testing JCL for backup and recovery.
- Installing, Maintaining, upgrading database software and third party software to meet business needs using SMPE.
- Monitoring database usage levels and planning for future capacity.
- Tuning the system to ensure optimum performance.
- Working with data processing staff and end-users trouble-shooting, and providing timely resolutions to CICS/IDMS COBOL program problems.
- Consulting with applications personnel on database issues redesigns, expansions, new development, interfaces, etc.
- Monitoring, tuning, modifying the databases to meet business needs.
- Providing 24 hour on call support recovery procedures to minimize data loss and
- maximize database availability.
- Setting specific database team objectives based on business need, customer feedback, and
- Information Technology objectives, and measuring our progress towards those objectives.
- Team member in conversion of IDMS sales and marketing database to DB2.
- Provided technical leadership on other assigned tasks as required.
IDMS System Data Base Administration
Confidential
Duties include:
- Installation and maintenance of IDMS Systems in an OS/390 and multiple VM platforms.
- Converted a number of Data Base environments to the new release of IDMS 14.0.
- Perform System DBA activities such as creation of new CV's, migration of dictionaries, system generations, performance and tuning to both IDMS 10.2 and 14.0 systems, and IDMS 14.0/RACF security administration.
- Applying maintenance to IDMS software using SMPE.
- Working with systems group, in preparation for installation of OS390 operating system.
- Worked with IDMS application group debugging IDMS COBOL AND ADSO programs.
- Provided technical leadership on other assigned tasks.
- Providing leadership, direction and support to IBM GLOBAL SYSTEMS
- handling the Y2K project for SOUTHERN COMPANY.
Confidential
Duties include:
- Installation and maintenance of IDMS Systems.
- Converted a number of Data Base environments to the new release of IDMS 12.01. Performed DBA activities including SCHEMA, DMCL, and SUBSCHEMA modifications and database restructures unloads/reloads, system generations, performance and tuning in IDMS 10.2 and 12.0 environments and IDMS 12.01 security administration.
- Worked with IDMS application group debugging IDMS COBOL AND ADSO programs.
- Assisted Arch Consultants with upgrade of IDMS CAS Products with our upgrade of IDMS 10.2 to 12.01.provided assistance with expansions and redesigns of IDMS databases.
- Provided technical leadership on other assigned tasks. Assisted with conversion of IDMS databases to DB2.
- ISD Support Team
Confidential
Duties include:
- Provide technical leadership on assigned tasks.
- Tasks include maintaining and writing ASSEMBLER, COBOL and EASTRIEVE programs to assist with changes required by end users.
- Trouble shouting problems and providing solutions for these problems.
Confidential
CONTRACTOR - IDMS Data Base Administration
Duties include:
- Installation and maintenance of IDMS Systems.
- Converted a number of 10.2 Data Base environments to new releases of IDMS 12.0, and 12.01.
- Performing DBA activities including SYSGEN, OCF, IDD, SCHEMA, DMCL, SUBSCHEMA modifications
- Performing database restructures unloads/reloads, system generations, performance and tuning in IDMS 10.2 and 12.0 environments and IDMS 12.01 security administration.
- Member of security team, provided technical leadership for planning, naming conventions, and implementation of IDMS 12.0 security.
- Installed CA's UNIPACK tool kit, ADS ALIVE, IDMS SERVER and IDMS PC and provided technical leadership on implementation of these products.
- Provided technical leadership on other assigned tasks
- Worked with IDMS application group debugging IDMS COBOL AND ADSO programs.
- VSE Systems Programmer and IDMS Data Base Administration
Confidential
Duties include:
- Installing, maintained, and developed IBM DOS/VSE SP ESA and VM operating systems.
- CICS, VTAM, BTAM, NCP, Networking, VSAM, SORT, COBOL, ADSO, ASSEMBLER ETC.
- Planning and installation of new equipment and maintenance to all existing equipment and problems.
- Providing programmers and system analysts support with trouble-shooting, debugging, testing, and problem solving. Designed and wrote ASSEMBLER programs, macros and COBOL application programs using CICS MACRO AND COBOL application languages to utilize both VSAM and DATABASE files. Set up VM making use of multiple guest system features and channel-to-channel adapter, to allow communications between multiple systems and remote networks. Worked with PC LAN NETWORK and setup communications with Mainframe for uploads/downloads between the two, and EDI transmissions.
- Installed, maintained, and developed IDMS database products.
- IDMS CV, UCF, IDD, OLQ providing direction and leadership through migrations, procedural changes, and training to ease the transition from one release to another, making it as transparent as possible to the user. Designed database systems. Wrote IDMS COBOL programs to accomplish restructure, application, and technical tasks when required.
- Installed, maintained and developed other CA products.
- VOLLIE, LIBRARIAN, EASYTRIEVE, EASYTRIEVE PLUS, INTERTEST, GENERAL LEDGER
- Installed, maintained and developed other products.
- BLUELINE SOFTWARE'S MAXBACK DISK UTILITIES COMPUTER CONCEPTS INC. DOSSIER CANDLE CORPORATION'S OMEGAMON LEGENT SYSTEMS EPIC DISK/TAPE MANAGEMENT
Confidential
DATABASE ADMINISTRATOR
Duties include:
- Installation and maintenance of IDMS Systems.
- Provided direction and leadership to in-house and contract personnel as they designed and implemented five major ADSO manufacturing related systems.
- Performing DBA activities including SYSGEN, OCF, IDD, SCHEMA, DMCL, SUBSCHEMA modifications
- Performing database restructures unloads/reloads, system generations, performance and tuning IDD standards security logical and physical design monitoring and tuning IDMS and installation, maintenance, development of LADERMAN Migration product
Confidential
Duties include:
- Installed, maintained, and developed IBM DOS/VSE, DOS/VSE SP and VM operating systems. CICS, VTAM, BTAM, VSAM, SORT, COBOL, ASEMBLER ETC. Involved in planning and installation of new equipment and maintenance to all existing equipment and problems. Privided programmers and system analysts support with trouble-shooting, debugging, testing, and problem solving.
- Designed and wrote ASSEMBLER programs, macros and COBOL application programs using CICS MACRO AND COBOL application languages to utilize both VSAM and DATABASE files. Set up VM making use of multiple guest system features.
- Installed, maintained, and developed IDMS database products.
- IDMS CV, UCF, DC, IDD, ADSO, OLM, OLQ, CULPRIT providing direction and leadership in migrations, procedural changes, and training to ease the transition from one release to another, making it as transparent as possible to the user. Designed database operating systems. Wrote IDMS COBOL programs to accomplish restructure, application, and technical tasks when required.
- Installed, maintained and developed CA products.
- VOLLIE, LIBRARIAN, METACOBOL, EASYTRIEVE, EASYTRIEVEPLUS,
- DYNAMD, DYNAMT, SYSTEM ADAPTOR, SCHEDULER, INTERTEST
- Installed, maintained and developed other products.
- WESTINGHOUSE DISK UTILITIES, JOB MONITOR I AND II COMPUTER CONCEPTS INC. DOSSIER CANDLE CORPORATION'S OMEGAMON
- MSA MANUFACTURING, DCI, and IE Systems - Worked directly with a special project team as they planned conversion of in house manufacturing system. Extensive software modifications were made to these products to make them retrofit the environment. Provided the required leadership, direction and support to this team.
- SOFTWARE INTERNATIONAL now COMPUTER ASSOCIATES GENERAL LEDGER system. Provided direction, leadership, and support as System Administrator to the Accounting and DP departments, as they converted in house system and assisted with writing and installing required interfaces to other systems.
- Other duties and accomplishments:
- Wrote EASYTRIEVE and EASYTRIEVE PLUS programs to accomplish application and
- technical tasks. Involved in training of personnel, and the development of EASYTRIEVE programs to provide a reporting vehicle for Human Resource Database System.
- Taught concepts, programming, and implementation on S/360, S/370, S/36, S/4300.
- Provided management decision makers support in areas of budgeting, and purchase of hardware and software products.
- Designed, implemented, and maintained a computer scheduling system, table maintenance system, program-entity cross-reference system and program information system.
- Maintained all internal written batch and online programs.
- Operations Manager staff of nine
- Liaison between systems, programming, and operations
- Librarian Maintain and administer all master tape and disk files, program information system, programming standards and all other librarian duties.
- Developing, modifying and testing JCL procedures, backups, and recoveries.