All offersKrakówDataDB2 zOS Database Specialist
DB2 zOS Database Specialist
new
Data
HSBC Service Delivery

DB2 zOS Database Specialist

HSBC Service Delivery
Kraków
Type of work
Full-time
Experience
Mid
Employment Type
Permanent
Operating mode
Hybrid

Tech stack

    SQL
    regular
    DB2
    regular
    redhat
    nice to have
    REXX
    nice to have

Job description

Some careers shine brighter than others.

If you’re looking for a career that will help you stand out, join HSBC, and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.


Your career opportunity


We work in partnership with the Infrastructure Architecture Function to set the vision and roadmap for all technologies across Infrastructure Delivery and to deliver Service designs in support of business IT programmes. 

We can categorize Enterprise Infrastructure in the following key areas:

• We as Enterprise Platform services. securely store and maintain the infrastructure services of our internal and external customer in accordance with compliance and standards. This includes technologies such as: Mainframe, UNIX and Linux servers Windows and storage, backup recovery solutions as well as technologies such like: Java application servers, databases hosting and messaging services.

• We also run some important programmes, most notably, our Service Change Lifecycle Programme, will be delivering benefits in the way we work with you in the business to estimate, plan and deliver the work effectively.


What you’ll do


  • Database utilities/housekeeping (Copy, Reorg, Runstats, Unload, etc), database recovery, database objects space monitoring,
  • Support/apply database physical object change requests by customers.
  • Advise internal customers about database best practices (Objects definition, data manipulation, etc.)
  • Process automation and pro-active monitoring the production environment
  • Work on alerts, incidents, problems and fulfilment requests
  • Support Db2 System Programmers checking Db2/Tools after upgrades/patches.
  • Supporting DB2 zOS and DB2 LUW while being on on-call (training will be offered if needed)
  • Performance and tuning (Enhance SQL statements access path to reduce execution time, suggesting SQL statements modification, creating/modifying indexes when necessary, suggesting table reorganization, etc.)


What you need to have to succeed in this role


  • Very good knowledge of DB2 z/OS on Mainframe 
  • Knowledge of SQL performance tuning
  • Very good knowledge of database maintenance tasks like backup/restore.
  • Very good knowledge of corresponding client software connections, z/OS to LUW crossloads, JCL, ISPF, IWS Scheduler
  • Team player in an international team
  • Good knowledge of English (written and spoken)
  • Knowledge/experience working with collaboration tools (Jira, Confluence, Service Now)


Nice have: 

  • REXX, Broadcom CA Tools for utilities or Toad for database admin for DB2 on Mainframe
  • Knowledge on DB2 LUW on RedHat Linux systems
  • Knowledge of German language (spoken and written) would be a plus.
  • Puppet, Ansible, Jira, Agile skills


What we offer


  • Competitive salary
  • Annual performance-based bonus
  • Additional bonuses for recognition awards
  • Multisport card
  • Private medical care
  • Life insurance
  • One-time reimbursement of home office set-up (up to 800 PLN).
  • Corporate parties & events
  • CSR initiatives
  • Financial support with trainings and education
  • Social fund
  • Flexible working hours 
  • Free parking



If your CV meets our criteria, you should expect the following steps in the recruitment process:


  • Online behavioural test
  • Telephone screen
  • Zoom interview with the hiring manager