DB2 UDB Administrator

DB2 UDB Administrator

Locations: Bangalore
Domains: Data Managment
Roles: DataBase Admin
Qualifications: Any graduate
Company: A Fortune 500 Company
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 it’s working fine)

6) Automatic database maintenance

7) SQL and Q Replication concepts

HADR setup and it’s 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

 




Submit a Resume for this Job


Upload a new Resume :

Your Resume ( .pdf, .doc, .docx, .txt files only ) :

     
Describe this Resume in 1 line. (optional)

Your Email address: