Data Base Administrator Resume Indianapolis, Indiana - Hire IT People

SUMMARY:

11+Years of Experience onZ/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 SQL Performance analyzer, OMEGAMON, CA-Erwin, BMC Change and Catalog Manager, IBM DB2 Admin Tool, BMC Remedy, Service Now, JIRA, SPUFI, QMF,CA7,Toad-Oracle, SQL Server, Mainview, Endevor, Abend-Aid, File-Aid, HPSM(PEREGRINE),

TECHNICAL SKILLS:

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, SQL Performance analyzer, OMEGAMON, BMC Remedy, SPUFI, QMF, CA7, HPSM (PEREGRINE), CA-Erwin,Toad,SQLServer,Mainview, Endevor, Abend-Aid,File-Aid, JIRA, RASCOE, DB2 Table Editor

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, Indiana

Data Base Administrator

Skills: DB2 V11, JCL, z/OS

Tools: IBM Admin Tool, SQL Performance analyzer, OMEGAMON, JIRA,SPUFI/QMF

Confidential, Windsor, CT

Onsite Lead

Skills: DB2 V10, JCL, z/OS, IMS DB

Tools: BMC Change Manger, BMC Catalog Manager, Servicenow,SPUFI/QMF, Apptune, CA7,CA-Erwin, Mainview, Abend-Aid,File-Aid, TOAD,SQL Server

Confidential, Hartford

Tech Lead

Skills: DB2 V10, JCL, z/OS, IMS DB

Tools: BMC Change Manger, BMC Catalog Manager,Apptune, HPSM, SPUFI/QMF, CA7, Endevor,CA-Erwin,BMC Remedy, Mainview, Abend-Aid,File-Aid

Confidential,

Tech Analyst

Skills: DB2 V9, JCL, z/OS

Tools: IBM DB2 Admin Tool, BMC Remedy, BMC Database Adviser, SPUFI/QMF, CA7,CA-Erwin, Mainview, Abend-Aid,File-Aid

Confidential

Specialized Info Engineer

Skills: DB2, JCL, z/OS

Tools: IBM DB2 Admin Tool, BMC Remedy, SPUFI/QMF, CA7,CA-Erwin, Mainview, Abend-Aid,File-Aid

Confidential

Team Member

Skills: DB2 V8, JCL, z/OS

Tools: IBM DB2 Admin Tool, BMC Remedy, BMC Database Adviser, SPUFI/QMF, CA7,CA-Erwin, Mainview, Abend-Aid,File-Aid

Responsibilities:

Working on 24*7 Production OnCall Support
Knowledge on DB2 Systems tasks like converting DB2 V11 from CM to NFM
Knowledge on 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/ SQL Performance Analyzer 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!

Data Base Administrator Resume

Indianapolis, IndianA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship