For an exiting new assignment we are looking for a freelance DB2 Mainframe Consultant (with LUW) to start as soon as possible.

Tasks

• Create or modify application database objects through data definition language (DDL) scripts that shall be delivered


• Upload data into application databases following procedures that shall be delivered


• Set up backups and other housekeeping


• Monitor the mailboxes / JIRA


• Monitor the company incident system


• Report database performance and communicate


• Performance improvement changes


• Deliver the information requested by client


• Deliver DBA expertise


• Restore/recover database objects


• Apply emergency security and stability patches (PDFs)


• Apply routine maintenance upgrades


• Apply product version upgrades


• Perform periodical health check-up exercises


• Set-up and scheduling of housekeeping scripts to reorganize


• Perform a periodical test database recovery exercise (DR)


• Restore a full production backup into a test sandbox every 6 months


• Restore data from production into development environments for testing purposes


• Priority 1 Incidents


• Priority 2 Incidents


• Production changes

Requirements

• English C1


• Customer facing


• Good communication skills


• Team player


• Capable of working independently


• Keep calm under pressurized conditions


• Experience in Operating highly critical production systems


• Working in shifts (cover between 07:00-19:00)


• Working in a virtual team, but still work well and in a disciplined manner with minimal supervision


• Working in weekends when required and on-call (on rota basis)


• Ability and willingness to strictly follow procedures and customer process

Desirable

• Experience of CDC and/or Classic SQL replication


• Experience with CA-Tools, Thread Terminator, Detector, Log Analyzer


• Experience with IBM Optim and DB2 Admin Tool


• Experience with IBM Data Studio


• Experience of DB2 LUW, especially DB2 zOS - > DB2 LUW migrations.

Summary of mandatory requirements

• Experience: DB2 on z/OS DBA with 5 + years of experience in supporting production and development environments.


• Languages: English


• Start: This is a freelance position. We are looking for freelancers that are able to start ASAP.


• Duration: 31/12/2021 (+ possible extension)


• Location: Remote work allowed but only from Europe. ? preferred locations are Madrid, Spain or Portugal

Location

Remote (Europe)