SUMMARY:

• Confidential 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.
• Extensive experience of Database administration of DB2 versions 7 - 10 (zOS, AIX, SOLARIS, RED HAT)
• Extensive experience in requirements gathering and business rules analysis using a variety of techniques and a conceptual/logical/physical database modeling. I have been an integral part of every phase (analysis, design, testing, and implementation) of database and data integration projects, production support, application support.
• Experience in design, architecture, and hands on database system construction experience to include SQL construction and testing, database system troubleshooting and performance tuning, database configuration and administration (e.g. DBA tasks), and application testing.
• Windows Server 2000, Windows Server 2003, Windows Server 2008, AIX, SOLARIS, RED HAT, zOS, MVS, DOS VSE, SUSE.

TECHNICAL SKILLS:

• DB2 (zOS) Version 8
• DB2 (zOS) Version 9
• DB2 (zOS) Version 10
• DB2 (LUW) Version 8
• DB2 (LUW) Version 9
• DB2 (LUW) Version 10
• IMS version 9
• IMS version 10
• IMS version 11
• JCL
• REXX
• Confidential utilities
• BMC utilities
• CA PLATINUM
• Confidential Data Studio
• BMC Catalog Manger
• BMC ALTER
• BMC Performance\Monitoring
• COBOL
• CICS
• VSAM
• BASH shell script
• KORN shell script
• PERL
• Industry Application:
• Insurance
• Banking
• Government (various agencies)
• HealthCare

PROFESSIONAL EXPERIENCE:

DB2 DBA\QREP ADMIN

Confidential

Responsibilities:

• Application DBA suppor 3 TEST and 8 PROD environments
• Supported production\UA batch cycle 24X7
• QREP admin responsible for the LEGACY QREP (12 subsystems)

DB2 DBA

Confidential

Responsibilities:

• Database maintenance and tuning
• Responsible for nightly processing
• Utilities
• 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.
• Supported production batch cycle 24X7
• 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

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 (mainframe & AIX)

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).

DB2 DBA (mainframe)

Confidential

Responsibilities:

• Database monitoring using automatic scripts, manually.
• 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.
• Performed database performance improvement by making use of different performance tools.

IMS\DB2 DBA (mainframe)

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 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.
• 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.
• Working closely with Operations, Batch Operations and System Programming (zOS)

Senior Mainframe Programmer

Confidential

Responsibilities:

• Systems support. The goal was to keep the system running until the new one was stable enough to start processing - COBOL\CICS\VSAM.

DB2 DBA (mainframe, AIX, SOLARIS)

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).
• Installation and creation of database instance on multiple SOLARIS and zLINUX servers
• Tuning and supporting development and QA environments for the different agencies within USDA who used the Data Warehouse within their systems.

DB2 DBA (AIX), AIX SYSTEM Administrator, MQ Series Administrator (AIX)

Confidential

Responsibilities:

• DBA responsibilities
• AIX responsibilities
• MQ responsibilities
• Mainframe conversion assistance.
• Q-REP setup, processing, monitoring, testing.