IBM Mainframe DB2 Database Administrator Resume

SUMMARY

10+ Years of Experience on Z/OS - IBM Mainframe DB2 Database Administrator (DBA) in Banking, Finance, Insurance (BSFI), Retail domain with strengths in Data Base administration, DB2 Systems tasks, 24*7 Production Support, Database Objects Design, Data Maintenance, Backup and Recovery, Utilities
Specific technical Knowledge in Mainframe technologies i.e. Z/OS, COBOL, JCL, DB2, VSAM, MVS, TSO/ISPF, CICS, and SAS.
Extensively working on tools like CA-Erwin, BMC Change and Catalog Manager, IBM DB2 Admin Tool, BMC Remedy, Service Now, SPUFI, QMF, CA7,Toad-Oracle, SQL Server, Mainview, Endevor, Abend-Aid, File-Aid, HPSM(PEREGRINE),

SKILLS SUMMARY

Operating Systems: Z/OS,MVS /ESA,Windows XP, Win 8

Programming Languages: COBOL, SAS

Control Languages: JCL

Database Packages: DB2, VSAM, IMS DB

OLTP: CICS

Tools: BMC Change Manger, BMC Catalog Manager, IBM DB2 Admin Tool, BMC Remedy, SPUFI, QMF, CA7, HPSM (PEREGRINE), CA-Erwin,Toad,SQL Server,Mainview, Endevor, Abend-Aid,File-Aid, JIRA, RASCOE, DB2 Table Editor

PROFESSIONAL EXPERIENCE

IBM Mainframe DB2 Database Administrator

Confidential

Responsibilities

Working on 24*7 Production OnCall Support
Working on DB2 Systems tasks like converting DB2 V11 from CM to NFM
Working as Secondary DBA for DB2 Systems tasks like Maintain the DB2 Catalog/Directory (Analysis, Backup, Recover, Reorg, etc), Migration, and PTF Installation with SMP/E
Analyze the DB2 Performance thru SMF trace and tuning the same whenever it’s necessary.
Worked with CA-Erwin to extract Logical model and convert into physical model.
Working on DDL/DML/DCL whenever it’s required right from Lower regions to Production.
Worked on DB2 V11 Pre/Post Migrating activities.
Working on space saving activities like drop obsolete database/table space, Free packages, Free plans
Working on activists like table space compression, Index space compression
Porting of Data from DB2 to Oracle, SQL Server/ Oracle to DB2 thru Procedures/Toad
Staging the Grants/Revoke/Free statements in home grown security tools
Worked on Projects which includes converting Batch Image copies to BMC Online Image copies and Batch Reorgs to BMC Online Reorgs.
Taking care of Pre/Post work for Sunet of Obsolete DB’s and working with CA-Endevor to archive the Obsolete DB2 Jobs/Procs/Parms.
Supporting Few IMS DB tasks like health Check of objects in DBRC/SYSPLEX, PSBGEN, AGBGEN, Generating Online/Batch IMS Image copy and IMS Reorg jobs and deleting the DBRC entry as when required
Supporting IMS Unload, Load,Copy and ripp-off Policies from Production to test and Purge the policies when required.
Setting up DBA maintenance jobs Reorg, Runstats, Copy, Modif Recovery etc for brand new objects and Scheduling them in CA7.
Raising RFC/Change ticket for every test/Production Activity and supporting all Production activities which will occur in Off-Business Hours/Business Hours and on weekends.
Involved in running Data Consistency Utilities like Check.
Involved in running Back up Utilities like Copy, Recover, Quiesce, Modify Recovery
Involved in running Data Organization Utilities like Load, Unload, Reorg, Runstats
Monitoring the DB2 space and Tuning the DB2 Unused Space and space management.
Involved in Performing Data Definition Tasks Like Creation of Storage Group, DataBase, Table space, Tables, Indexes, Views, Alias, Synonyms, Alter Objects, Drop Objects.
Supporting the development team for monthly/weekly releases and assisting for any issues.
Brainstorming with Team for issue clarification & resolution.
Attending Daily, Weekly and Monthly status meetings & preparing Status Report, MOM, Task Cick-Off Report
Attending DB2 COE meetings and workshops/ trainings

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship