Senior DBA consultant Resume

PROFESSIONAL SUMMARY

Total of 10+ year work experience as DB2 Database administrator.
Currently working as a Senior DB2 DBA consultant at JP MORGAN CHASE.
Having hands - on experience in DBA activities like implementing Database design, Data Maintenance, Authorization and privileges for DB2 access.
Regular backup and recovery activities.
Experience in operational 24/7 support, best practice troubleshooting, monitoring.
Experience in DB2 tools like Detector, IDAA (DB2 accelerator), Query optimization using EXPLAIN.
Acquired in-depth knowledge of DB2, DB2 stored procedures.
Knowledge of COBOL, JCL, VSAM, CICS.
Good team player with excellent communication and interpersonal skills

TECHNICAL SKILLS

Programming Languages: COBOL

Operating systems: ZOS, OS/390, Windows XP.

Databases: DB2.

Mainframe Tools: TSO/ISPF, SPUFI, QMF, DB VISUALIZER, DATA STUDIO, ADVANCED QUERY TOOL, ACCELERATOR, DETECTOR, FILE-AID.

PROFESSIONAL EXPERIENCE

Confidential

Senior DBA consultant

Responsibilities:

Handles the authorization of DB2 objects to Users, applications and utilities.
Creating DB2 tables, Views and other DB2 objects depending upon the application group requirement.
Modify object definitions.
Regular backup and recovery.
Load and Unload utilities.
Starting and stopping of DB2 database, Queiscing, Resume and Refresh.
Monitoring the object.
Production support.