DB2 Lead DBA Resume

SUMMARY:

8+ years of experience in DB2 UDB Database Administration. Involved in analyzing, designing and maintaining DB2 v8, 9.5, 9.7, 10.1 databases on AIX and Linux servers.
8+ years of IT Experience in database administration and support
Worked on Installation, configuration and upgradation of DB2 software and related products
Worked on Data center migration for a large insurance customer
Proficient in daily support activities which include maintaining backups, monitoring logs, checking locking issues and contentions, scheduling and database administration activities.
Co - ordinated and actively worked in database version migrations DBA support team
Experienced in supporting critical production databases and worked on 24*7 production support.
Ability to work independently or as an effective team player
Proficient in writing shell scripts
IBM Certified DB2 LUW DBA

TECHNICAL SKILLS:

Operating System: Windows 95/98/NT/XP, AIX 5.1, AIX 7.1, RHEL 6.6

Scripting Languages: Unix Shell Script, DOS scripts, Rexx scripts.

Databases & Tools: DB2 v8.2 in AIX 5.1, DB2 v9.7 in AIX 6.1, DB2 10.1 in REHL 6.6 and Windows 2008 Server

Middleware: WebSphere 7.1 Network Deployment ND

Web Languages: HTML, Java Script

PROFESSIONAL EXPERIENCE:

Confidential

DB2 Lead DBA

RESPONSIBILITIES:

Installation and Configuration of DB2 UDB (ESE) version 10.1, Installation of latest fixpack on DB2 10.1
Instance creation, instance upgrade and new databases creation
Installing / configuring the new licenses
Involved in setting up STMM in DB2 1.01
Involved in setting up AUTORESIZE feature in DB2 10.1
Implementing DB2 health check scripts
Strong exposure to Database backup & recovery concepts (offline and online backups)
Design of new databases and maintaining database objects
Manage different database objects like bufferpools, tablespaces, tables, indexes, views, constraints
Manage the database backup, restore and refresh
Worked with data movement utilities Export, Import and Load
Strong exposure in DB2 utilities like db2look, db2move, Runstats, Reorgchk and Reorg
Database monitoring using db2pd & db2top
Working with DDL and DML statements
Troubleshooting Deadlock issues.
Managing Database user privileges (granting & revoking permissions)
Managing SMS and DMS Tablespaces
Table space management - Adding, dropping, extending, reducing and resizing table space containers
Support and perform data fixes and correction in production environment
Database backup & recovery (offline & online backups, Full, Incremental)
Performing redirected restores
Setting up HADR and Tivoli Systems Automation TSA
Involved in Catalog and Uncatalog of databases and nodes
Support and Perform Disaster Recover test on HADR/TSA environments
Performing Daily Database Heathcheck
Resolving Database maintenance job abends and Application batch job failures
Monitoring db2diag and notify logs
Strong exposure in writing Shell scripts

Confidential

DBA Lead

RESPONSIBILITIES:

Installation and Configuration of DB2 UDB (ESE) version 9.7
Actively involved in Data Centre migration for Manulife Japan
Instance creation, instance upgrade and version migration (v9.1 to V9.7)
Migration involved DB2 migration from v8.1 to 9.7 (both AIX and windows)
Strong exposure of installing Fixpack to DB2 in both AIX and Windows environments
Installing / configuring the new licenses
Involved in Range partitioning of Tables & indexes.
Involved in Table and Index compression
Involved in setting up STMM in DB2 9.7
Involved in setting up AUTORESIZE feature in DB2 9.7
Strong exposure to Database backup & recovery concepts (offline and online backups)
Design of new databases and maintaining database objects
Manage different database objects like bufferpools, tablespaces, tables, indexes, views, constraints
Manage the database backup, restore and refresh
Worked with data movement utilities Export, Import and Load
Strong exposure in DB2 utilities like db2look, db2move, Runstats, Reorgchk and Reorg
Database monitoring using db2pd & db2top
Working with DDL and DML statements
Troubleshooting Deadlock issues.
Managing Database user privileges (granting & revoking permissions)
Managing SMS and DMS Tablespaces
Table space management - Adding, dropping, extending, reducing and resizing table space containers
Database backup & recovery (offline & online backups, Full, Incremental)
Performing redirected restores
Setting up HADR and LogShipping
Involved in Catalog and Uncatalog of databases and nodes
Support and Perform Disaster Recover test on HADR/logshipping environments
Performing Daily Database Heathcheck
Resolving Database maintenance job abends and Application batch job failures
Monitoring db2diag and notify logs
Involved in WebSphere application server ND installation and fixpack installation in AIX servers
Strong exposure in writing Shell scripts, DOS and Rexx scripts
Configuring and troubleshooting WebSphere Application Server, TX Series CICS, CTG, and Micro Focus COBOL
Involved in Monthly Metrics report and Weekly status reports

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship