DB2 DBA Admin

Responsibilities include:

• Db2 database products patching such as version upgrades and applying fixpacks.
• Installing and uninstalling Db2 products.
• Developing backup and recovery strategy, including database backup and data recovery.
• Using database maintenance utilities such as runstats and reorgs.
• Supporting DB2 services stop/start/validation activities during OS patching and OS maintenance.
• Setting up and administering High Availability (HADR).
• Applying new Db2 features to the database.
• Setting up and administering Db2 Purescale.
• Working with IBM DB2 Support for fixes for known errors.
• Data modeling and database design, including tables and index management for all types of tables.
• Designing DB2 objects such as tables, indexes, views, triggers, and constraints to support application design and development efforts.
• Building databases by creating instances, databases, tablespaces, bufferpools, tables, indexes, views, and other database objects.
• Administering Db2 security by granting and revoking privileges to users for access.