DB2 Administrator

Description :

- Having good knowledge in Db2 architecture

- Having good experience to create objects like table and index creation requested by the application team

- Good experience in backup strategies like an online and offline backup.

- Good experience in restore database and apply logs up to point in time

- Good experience to create tablespace management like adding and resizing..

- Good experience in data movement utilities

- Granting permissions at the user level

- Checking DB health check (Monitoring tools) PD, TOP

- Good exp in offline reorg/online reorg

- Creating an instance and install DB2 products

- Having HADR knowledge -working

- Performance tuning(time issues)

- Performing redirect restore between different servers

- Tuning DBM and DB level configuration parameters

- Knowledge in replication setups (SQL and Q) primary to standby

- How to tune queries- explain (current indexes)/advise plan(indexes)

- UPGRADING DB Versions / Rollback plan

- Perform database maintenance