AWS IBM DB2 database Administrator

Key Skills/Knowledge:

IBB DB2 LUW- i.e Database administrator of DB2.Experience on installation of different versions of DB2 on Redhat Linux Environment

Good knowledge of Linux

Scheduling shell scripts on LINUX environments

Good experience in generating DDL's using DB2LOOK command on existing database and its objects.

Use RUNSTATS, REORGCHK and REORG to enhance application performance.

Good knowledge on data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.

Tuning using db2advisor and db2explain tools.

Database performance tuning by configuring database and DBM Parameters.

Configuring the HADR and monitoring the HADR databases. Purescale implementation desired

DB2architecture and Administrator, solutioning of Arctitecture. LUW, pacemaker setup(HADR) 6 to 12 both Designer and Administrator.