Database Administrator Resume

SUMMARY:

Ambitious and dedicated versatile DBA seeking a position as a DB2/ZOS or IMS Database Administrator.

TECHNICAL SKILLS:

Hardware/Software skills: MVS Z/OS, DB2/ZOS V10 in NFM, IMS V11, SQL, $AVRS, SAR, DB2 DATABASE TOOLS, ENDEVOR, ACF2, ISPF, RACF, SDSF, BMC Tools and BOOLE & BABBAGE, MAINVIEW, TERMINAL EMULATION HOD, OPTIMIZATION SERVICE CENTER, Erwin model manager, OMMEGAMON for DB2ZOS, MS Tools/Windows/Outlook, Top Secret, AS/400

EMPLOYMENT:

Confidential

Database Administrator

Confidential

Database Administrator

Confidential

Database Administrator

Confidential

Lead Scheduler

Confidential

Senior Scheduler

Responsibilities:

Work with the technical and application development staff to design and implement databases in support of the business application development efforts
Maintain DB2 and IMS databases to meet performance standards.
Make DDL(Data Definition Language) structure changes and corrections when required to DB2 databases.
Performed structural changes to the IMS databases such as adding new segments, fields and also adding 2nd dataset groups and other changes when required.
Built new IMS and DB2 databases when implementing new applications or adding a new database to a current application.
Maintain, operate, upgrade and make necessary changes to the DB2 databases to maximize performance.
Maintained and managed space consumption for the IMS and DB2/ZOS database platforms.
Assist with capacity planning and DASD management.
Assists in the design, test, implements, maintains and controls the organization’s physical and relational database maintenance and control structures.
Assisted in the design, tested and implemented, maintained and controlled the organization’s IMS and DB2 databases on the respective platforms.
Recovered, performed database reorganizations, pointer checkers and image copies in support of the IMS databases in all IMS regions.
Performed consistent off hour support for IMS and DB2/ZOS problems and issues and in addition implementations of new structural and required changes in production and also in test regions.
Performed restores/recoveries for IMS and DB2/ZOS when required to correct production issues for IMS and DB2 outages.
Monitors the performance of databases(for DB2/ZOS and IMS) and performs and corrective action where appropriate
Recovers, performs back up procedures, tunes and handles database reorganizations
Performs database recovery procedures to ensure that they are consistent with the current operation.
Maximize efficiency and minimize outages.
Performed extensive HDAM tuning of IMS databases to maximize the best performance.
Performed batch back out procedures when required and also repaired log files when necessary.
Ensures Referential Integrity of DB2 databases.
Provided off hour support for database change implementations.
Provided Disaster recovery support for DB2ZOS and IMS DB.
Extensive experience in IMS DB and DB2ZOS as a Database Administrator in health insurance & Bank/Finance industries.
Assisted in DB2 Version 8, 9 and 10 Upgrade migrations and in addition several IMS migrations including the latest migration for IMS to version 11.
Grant/Revoke temporary security access and implement security authorizations on the DB2 platform.
Maintained that all DB2 databases both production and all the test environments were being backed up and RUNSTATS were executing when required.
Implemented new Native Stored Procedures and Cobol stored procedures.
Implemented Bi - Annually the BCBSA ITS release for Confidential which consisted of DB2 database structural changes and native stored procedure creations.
Implemented the CMS releases for Confidential from a DB2 perspective.
Implemented Automatic table space database reorganizations, backups and RUNSTATS.
Unload & Load of data procedures.
Troubleshoot DB2 issues working with applications staff.
Troubleshoot IMS DB and DC issues when required and resolved problems with the respective applications areas.
Worked extensively with IMS online transaction issues, programs and online PSB issues.
Performed PSB GENS both online and batch and handled ACBGEN builds for online PSBs and also handled the online changes.
Extensive experience in IMS with DBRC and IRLM.
Performed several off hour upgrade, SQL tuning and applications support work assistance when needed for DB2.
Perform table space partitioning with DB2 tables.
Supported DB2 platforms for the Social Security Administration for the Confidential .
Several years experience working on the AS/400 platform with Confidential system.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship