Db2 Udb Administrator Job in Shreyas Technologies

Experience: 3 - 8 yrs

JD for Db2 UDB:

1) Database fundamentals (architecture,Threads/process, Instance, Database, tables, row, Tablespace, Containers, SMS, DMS)

2) New features in the available DB2 UDB edition ( e.g. New features in V9, V9.5, V9.7, V9.8)

3) Automatic Storage setup

4) Table partitioning

5) STMM ( How to enable and disable, how to see if its working fine)

6) Automatic database maintenance

7) SQL and Q Replication concepts

HADR setup and its monitoring

9) Backup and recovery at advanced level( recovering dropped table, rebuilding a database, cross node recovery)

10) Database partitioning feature and how to implement

11) HACMP

12) Configuring TSM for a database

13) Configure database for archival logging

14) Incremental backup and restore

15) Database upgrade/migration

16) Install Fixpack and rollback in minimum time

17) Enable Deep Compresssion

18) Offline and online reorg recovery from a database failure

19) Work with PMR support on crtical issues

20) Advance locking concepts ( resolve locks and dealocks, should be able to suggest methods to resolve deadlocks)

21) Query Tuning

22) Scripting

23) Federation setup

24) Diagnosting and trouble-shooting concepts

25) Database House keeping Activity