Overview
Remote
Full Time
Contract - W2
Contract - Independent
Contract - Long term
Skills
DB2
DBA
Job Details
Job Title: DB2 DBA
Location: Remote
Duration: Long term
Tax Term: W2
Responsibilities:
Required:
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.