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? Apply tot his job Apply To this Job