Job Title: DB2 DBA

Job Location: Remote

# Positions: 1

Work Eligibility: All Work Authorizations are Permitted – No Visa Transfers

What You Will Do:

Support Technology Upgrade Project

Upgrade DB2 Windows Servers

Support Windows upgrade of Database servers

Perform database backup (online, Incremental and Delta backup) and recovery tasks

Monitor daily DB backups and weekly RUNSTATS and REORGS on tables

Assist in capacity planning, space management and data maintenance activities for database system

Skills and Experience You Will Need:

Required:

Expertise to handle all DB2 DBA LUW activities, especially upgrades.

Hands-on experience DB2 installation and version upgrades on Windows.

Able to trouble shoot database issues arising from DB2 version upgrades.

Able to perform database backup (online, Incremental and Delta backup) and recovery tasks.

Able to perform monitoring daily DB backups and weekly RUNSTATS and REORGS on tables.

Able to set DB alerts using tools like Foglight.

Perform DBA DB2 support for application development team.

Can perform maintenance of DB objects like tables, table spaces, Indexes, Views, Triggers etc.

Able to update the UDB DB and DBM configuration parameters.

Good experience in DB2 Database management, performance tuning and troubleshooting.

Know how to manage DB2 database on windows OS.

Experience with PowerShell scripting.

Know how to manage HADR setups.

Working knowledge of change Management Processes and tools such as ServiceNow.

Candidate will need to be available for on-call 24×7 support as necessary