DB2 DBA Admin

TechDigital Group; Phoenix (AZ); On-site; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Db2 Database Administrator to manage and optimize database systems. This role involves patching, upgrading, and securing Db2 databases, as well as developing backup and recovery strategies. You'll be responsible for designing database objects and ensuring high availability while collaborating with IBM DB2 Support for issue resolution. Join a dynamic team where your expertise will contribute to the stability and performance of critical database systems, making a significant impact on the organization's success.

Qualifications

• Extensive experience with Db2 database management and patching.
• Strong skills in database backup, recovery, and security administration.

Responsibilities

• Patch and upgrade Db2 database products, ensuring smooth operations.
• Develop and implement backup and recovery strategies for databases.

Skills

Db2 database management

Database backup and recovery

Database design and modeling

High Availability (HADR)

Database security administration

Tools

Db2

Job description

Job Description:

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.