Db2 Udb Administrator Job in Shreyas Technologies
Db2 Udb Administrator
- Bengaluru, Bangalore Urban, Karnataka
- Not Disclosed
- Full-time
- Permanent
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
Fresher
2 - 4 Hires