Overview
Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 6 Month(s)
Skills
DB2 DBA
UDB DB
Powershell
database backup
Job Details
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.