DB2 DBA

Job Title: DB2 DBA

Job Location: Remote

# Positions: 1

Duration: Short Term

Key Technology: DB2, DBM configuration, Foglight

Job Responsibilities:

• 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 Required:

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.

Recruiter Submission Template:

Full Name:

Degree Major with University and Completion year:

Last 4 Digit SSN Number:

DOB:

Vaccination Status:

Any pre-planned vacations planned in the next 90 days?

Have you ever lived in State of Ohio?

Contact Number:

E mail Id:

LinkedIn Id:

Full Address (Street, City, States, Zip Code)

Notice period: (in weeks):

Current work authorization status (US Citizen, Green Card, etc.)

Expected Hourly Rates on W2?