DB2 DBA

Highbrow LLC; United States; Remote; USD 100,000 - 130,000; Full time

Job summary

A leading technology firm seeks a DB2 Database Administrator (DBA) to support critical upgrades and ensure optimal database performance. Responsibilities include managing upgrades, daily backups, and troubleshooting DB issues on Windows servers. Candidates should have expertise in DB2 and be available for on-call support. Join a dynamic team and make a significant impact on database management.

Qualifications

• Expertise in DB2 DBA activities, especially upgrades.
• Hands-on experience with DB2 installation on Windows.
• Good experience in performance tuning and troubleshooting.

Responsibilities

• Support Technology Upgrade Project and upgrade DB2 Windows Servers.
• Monitor daily DB backups and perform recovery tasks.
• Assist in capacity planning and data maintenance.

Skills

DB2 Installation

Database Management

Performance Tuning

Troubleshooting

PowerShell Scripting

HADR Management

Tools

ServiceNow

Foglight

Job description

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