IMS\DB2 DBA (mainframe) Resume

SUMMARY

He is an outstanding DB2 DBA that possesses expertise in DB2 version 7/8/9/10, performance tuning, capacity planning and monitoring, data security, backup and recovery procedures, execution plans, statistics, stored, replication, high availability, disaster recovery, SDLC, SQL statements designing and optimization.

PROFESSIONAL EXPERIENCE

IMS\DB2 DBA (mainframe)

Confidential

Responsibilities:

Hands on experience in managing index, blocking, troubleshooting deadlocks and other performance bottle necks.
Monitor integrity and performance of the database using Profiler, tuning advisor, statistics, DMVs.
Experienced with disaster recovery
Troubleshoot, research, and resolve technical and data integrity issues.
Maintaining documentation of processes and configurations that are newly created or changed.
Created objects, views, indexes.
Created and scheduled Maintenance plans (integrity check, backups, update statistics, shrink database, cleanups).
Created Packages/Plans

DB2 DBA (mainframe & Solaris\AIX)

Confidential

Responsibilities:

Installation / Configurations of DB2 Version 9 and DB2 Connect (Solaris\AIX).
Create backup strategies, compression and encryption of backups, backup restore testing.
Database monitoring using automatic scripts, manually.
Disaster recovery planning and configurations, replication, Log Shipping, Mirroring.
Troubleshoot, research, and resolve technical and data integrity issues.
Managing documentation of processes and configurations that are creating or changed.
Understanding the client issues and providing On - Call and On-Site support to the clients.
To proactively monitor the database systems to ensure secure services with minimum downtime.
Implemented trigger and stored procedures (COBOL\PERL) and enforced business rules via checks and constraints.
Created objects, views, indexes.
Performed database performance improvement by making use of different performance tools.
Ensure data recovery, maintenance, data integrity, and space requirements.
Create and implements different backup and disaster recovery scenarios.
Ensure backup/recovery, installation & upgrades of RDBMS.

IMS\DB2 DBA

Confidential

Responsibilities:

Create backup strategies, compression and encryption of backups, backup restore testing.
Database monitoring using automatic scripts, manually.
Disaster recovery planning and configurations, replication, Log Shipping, Mirroring.
Troubleshoot, research, and resolve technical and data integrity issues.
Understanding the client issues and providing On-Call and On-Site support to the clients.
To proactively monitor the database systems to ensure secure services with minimum downtime.
Created objects, views, indexes.
Performed database performance improvement by making use of different performance tools.
Ensure data recovery, maintenance, data integrity, and space requirements.
Create and implements different backup and disaster recovery scenarios.
Advise application programmers on database related issues (such as SQL, access path etc.)
Performance tuning on the system level using ZPARMS (zOS) and database configuration parameters (AIX).