DBA Resume

SUMMARY:

I have got around 10 Years experience in the area of Database Administration as DB2 UDB DBA. I have worked on version 7, 8, 9.1 9.5. I am certified Advanced Database Administrator by IBM. I have worked on 24*7 Production Support environments as well on new server setup for application development. I have done complete setup of HADR db with TSA. Further I have also given support in advance technologies like replication and DPF. I have extensive experience in performance tuning. I have been involved in supporting SAP Database environment. I have also been involved in designing and deployment of EMC Snapshot backup. I have also has given ADABAS DBA support and has good understanding of Mainframe environment.
Managing and maintaining the database integrity all the database environments - Production, Staging, QA and Development 24*7 involving High Availability Technologies like BCU, DPF, VERITAS Cluster, SAN Replication, SQL and Q-Replication with more than 2000 plus databases.
More than 2 years experience in leading the leading UDB Team in Onsite-Offshore Model.
Extensive experience in implementing process models in team for Incident and change management.
Providing the Database Support for the application performance outages, job fail and performance issues. Tuning SQL quires for optimal performance. Preparing Root cause Analysis document for application performance degradation and implementing the changes in the system.
Applying Fix packs on the db environment and keep the Software level up to date.
Extensive experience in Coordinating with System support team like Unix Admin, Network, Admin, TSM team and Application Designer for new DB Sever build.
Implemented HADR with TSA solution on more than 40 plus databases.
Tuning database parameters for memory, locks, transaction log and buffer pool for optimal performance of database.
Doing POC implementing the initiatives for improving the database environment and application performance improvement and reducing the Total Cost of Ownership.
Maintaining the database images and optimizing the database backup performance.
Extensive experience in Creating, alerting and modifying the database dashboard scripts for the proactive database maintenance
Problem Analysis using tools like Performance Expert.
Working with Application Support and performing database maintenance activities like reorg, Run stats
Capacity Planning and management of database server with Unix system support, Network, SAN and TSM.
Extensive experience in database migration and upgrade. Some of the migration project work includes UDB 7.1 to UDB 9.7 and DBMS migration from Oracle v9.1 to UDB v9.1.
Provide database support for Server Maintenance with the activities like stopping/starting replication services and stopping and starting db services.

TECHNICAL SKILLS:

Operating Systems: Aix, ZOS,Redhat Linux

Languages: Shell Scripts, NATURAL, COBOL

Databases: Db2 UDB v7,8.2,9.1,9.5,9.7, 10.5, ADABAS 7.2 and Oracle

Tools & Utilities: IBM Utilities for DBA, TSA, IBM MTK, Performance Expert, Cron,SQL and Q-Replication, Blade Logic, EMC Networker, Sysmantec Netbackup

Domain Knowledge: Automobile OEM,BFSI

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

Worked on EMC snapshot backup technology to implement in all large databases.
Worked on NMDA EMC database technology in DB2, Oracle and Max DB.
Migrated SABRIX database from Oracle to DB2.
Created database capacity report for storage addition.

Confidential

Responsibilities:

Created the scripts for HACMP start and stop.
Supported Basis for SAP Implementation.
Worked with Basis for setting up SOLMAN monitoring.
Created multiple scripts to augment SOLMAN monitoring.
Created database capacity report

Confidential

Responsibilities:

Took KT and built the team for database support for Offshore operations.
I am part of the Availability Command Centre (ACC) to provide the 24*7 to provide Production support for numerous applications accessible via UDB Database.
Created multiple scripts for standardizing the operations.
Developed software upgrade plan

Confidential

Responsibilities:

Worked as Offshore Co-coordinator for the UDB team for more than 6 months.
Supporting Database Architect for physical implementation of Logical design.
Performed a complete setup of HADR db with TSA setup for new application support.
Monitoring Tablespaces, file system and coordinating with the Application Team and BA for capacity planning for the Database.
Automated the db alerts and backup reports for Management.
Performed Migration for Tivoli database from Oracle to UDB.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship