Data Engineer Mainframe Db2 z/OS DBA (m/f/d)

Ticino
Start date: asap
Reference number: 848980/1
Lancer la candidature

Project information

  • Workload: 80-100%

Responsibilities

  • Support Db2 Environments; Integrate external vendor products and interfaces into the Mainframe landscape;Establish recovery routines for infrastructure and business data using products suites from IBM and BMC; Assist and advise database object design to business applications.
  • Design models and templates to provide best practices in data migration efforts.
  • Review logical models and provide physical database designs in support of Business initiatives.
  • Database object installations across all application landscapes (Development, QA, Production).
  • SQL performance reviews and approvals for all application release packages utilizing Changeman Approvals line-item sign-off.
  • Incident and Problem Management related to Db2 usage for Business applications and Operations.
  • Identify and introduce new Db2 functions to Business applications for possible integration into their respective mainframe software environments.
  • Support the implementation of Db2 Certificate-based security for technical accounts connecting to Db2 environments (QA and Production).
  • Implement and support ESL Data layer components such as SQLJ Java Stored Procedures within Changeman SCM.
  • Assist TDM (Test Data Management) team in populating QA environments with obfuscated data; Db2 support for Content Manager (IBM Document Management System) and assist in regular software updates.

Profile

  • Solid experience Db2 for z/OS V11 thru v13
  • Knowledge in COBOL Db2 programming interfaces
  • IBM Utilities Suite: Image Copies, Reorgs, Runstats, Load, Unload
  • BMC Utilities and Toolsets: Image Copies, Reorgs, Runstats, Load,Unload
  • CATALOG MANAGER for Db2 - Execute DDL or query Db2 Catalog,, CHANGE MANAGER for Db2 - Manage changes to Db2 objects/structures, DASD MANAGER for Db2 - Manage or monitor Db2 physical object, RECOVERY MANAGER for Db2, CHANGE ACCUM for Db2, LOG MASTER for Db2
  • SYSTEM and SQL PERFORMANCE for Db, MAINVIEW Db2
  • SQL Knowledge and Performance Tuning
  • Db2 PSQL Native Stored Procedures
  • IBM z/OS, TSO
  • IBM JCL

Benefits

  • A highly motivated team and an open way of communication
  • A very renowned company
  • Fascinating, innovative environment in an international atmosphere

About Hays

True financial experts are rare, in great demand and therefore have a high market value. Whether it's in Accounting, Controlling, Corporate Banking, Interim Management, Treasury or Risk Management – Hays will open doors for you and advise you completely free of charge regarding your next career move. By drawing on your interests and personal expertise, we will find the right job for you. Register with us and reap the benefits of interesting job offers that match your skills and experience. We look forward to hearing from you!

Staffing process for freelance specialists

  1. Analysis of qualifications
  2. Telephone or personal interview
  3. Contact with customers
  4. Contract with Hays
  1. 1    
  2. 1. Analysis of qualifications

    We carry out a detailed analysis of your technical qualifications on the basis of your CV, your application documents and your profile.

  3. 2
  4. 3
  5. 4

Contact at Hays

+41 44 225 50 00
Reference number : 848980/1
Lancer la candidature