facebook tracking

DB2 Mainframe Consultant

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

Operational 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 


  • 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


  • 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


Remote (Europe)

Usually responds within 2 hours

Or, know someone who would be a perfect fit? Let them know!

Job categories

28013 Madrid Directions View page

Lisbon, Portugal

1150-234 Lisbon Directions View page

Why work with us?

Recruit4.Work was built on four core values, and they are as relevant today as the day we began: honesty and clarity, proactivity, long-term relationships, and knowledge.

  • Honesty and clarity

    We ensure these values are the basis of our interaction with everyone; clients, candidates, suppliers and each other.

  • Proactivity

    We are creative and solutions driven and don’t rely on existing methods. We are flexible, open to change and constantly question the status quo

  • Long-term relationships

    We develop relationships with a view to forming successful and sustainable long term partnerships of mutual benefit.

  • Knowledge

    We continually build upon our in-depth understanding of the disciplines and sectors in which we operate.


Recruit4.work will do more than just finding that absolute professional for you. We judge the person also at their personal and contactual abilities.

Will he/she fit within your organisation structure? Is he/she a real team player, will he/she show enough leadership to lead a larger unit, is it a real personality, and will he/she estimate that very special procedures characterizing your organisation?

A company specialized in recruitment and selection will take those aspects seriously in the profile. 

Recruit4.work is such a company.


Applicant tracking system by Teamtailor