Having 3+ years of IT experience in DB2 UDB Administration on Aix, Linux, Unix and Windows 2000/NT Environments.
Rich experience in DB2 UDB Database administration.
Good exposure with Installation of DB2 Databases on LUW machines.
Experience in Migration and Up-gradation (Fix Packs) on existing database servers .
Hands on experience in maintaining Table-space spaces, Tables in DB2 databases running on Unix/Windows platforms
Experience in implementing Backup and Recovery strategies.
Good Experience on Restoring the database from one Linux server to another Linux server using Redirect Restore method.
Expertise in using DB2 Movement Utilities like Export, Import, Load , DB2Move and DB2look.
Expertise in getting entire DDLs for a database using db2look and creating those objects structure in Target database based on the DDL script.
Hands on experience in Cataloging the Data Bases.
Experience in using DB2 Maintenance Utilities like (Reorgchk /Reorgs /Runstats).
SQL Query Tuning using db2advisor , db2explain and db2exfmt tools.
Troubleshooting database issues using db2diag, db2pd, db2dart, db2support, db2top, Snapshots and event monitors.
Good knowledge on moving entire database objects from Source database to Target database using db2move.
Knowledge on HADR (High Availability Disaster Recovery).
Knowledge on moving databases from Windows to Linux and vice versa.
Good knowledge on Incident / Problem and Change management process.
Experience on preparing project related documents.
Highly motivated team player with strong communication, analytical and inter-personal skills.