A Fortune 500 Company
Location
Bangalore | India
Job description
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 ActivityJob tags
Salary