Lead Consultant- DB2 on Mainframe

o   Must Have Skills: Evaluate
and implement new features/functions of DB2 and associated third party
products.

o   Extensive use of utilities
and Performance Monitoring tools using BMC, CA and IBM products.

o   Consultant on DB2 database
applications architecture

o   Knowledge of SMP/E and can
prepare for and apply maintenance to a DB2 subsystem

o   Engineer and execute the
processes to upgrade and/or apply maintenance to releases / versions of
mainframe database system software, and associated third party products

o   Maintain DSNZPARMs

Nice to Have Skills: Skill: Mainframe DB2
System Programmer

Job
Description:

We are looking for DB2 Systems
Programmer, who will be part of a Global team responsible for building,
configuring and maintaining the Bank’s mainframe systems. Currently we are
running the largest parallel SysPlex in the Nordic region. Our primary design
goals are service availability, efficiency and resilience, underpinned by the
architectural principle of cloned infrastructure, system configurations and
applications. Job Responsibilities

o   Maintain DSNZPARMs

o   Implement automated disaster
recovery mechanisms for Mainframe Database subsystems and associated third
party products.  Participate in all
recovery coordination activities

o   Create & modify WLM
address spaces for stored procedures as needed

o   Database security management

o   Backup/Recovery strategies

o   Strategy Reviews

o   Scalability Analysis

o   Database Architecture design
strategy

o   Planning Database maintenance
window

o   Capacity planning

o   Monitor and troubleshoot DB2
address spaces for any potential issues

o   DB2 Database configuration
across difference Mainframe LPARs.

o   Prepare and execute
housekeeping strategies for the DB2 Catalog and Directory.

o   Implement security strategy
for DB2 via RACF.

o   Troubleshoot Level 3 DB2
Database issues.

o   Provide Level 3 support to
troubleshoot/resolve system level and application problems with DB2 Database
technologies and associated Third Party products – coordinate
escalation/intervention with vendor as necessary.

o   Strong experience of
installing, customizing and maintaining Mainframe DB2 and ISV products

o   Strong experience managing
Q-replication and IBM DB2 Data Analytics accelerator product suite

o    Strong experience working with large data
sharing SysPlex environment

o    Hands-on experience of managing system
operations, problem diagnosis, performance tuning in both system and
application arena

o   Good experience with IBM DB2
Utilities, Disaster recovery and system restoration

·       Install, upgrade and administer mainframe DB2 and DB2 related
tools software.

·       Assist with testing, implementation and installation of new or
improved systems, as well as product upgrades.

·       Good knowledge on DB2 migrations and upgrades for DB2 V12.1 and
V13.1 versions.

·       Good Knowledge on Problem diagnosis related to DB2 and their DB2
tools products.

·       Strong DB2 system programming skill, DB2 recovery, maintain system
objects and ZPARM parameter configuration.

·       Good knowledge of DB2 tools installation and upgrades for IBM
utilities, Broadcom products.

·       Experience in SMPE knowledge of RSU maintenance apply procedures.

·       Experience in JCL, ISPF, DB2 related products, WLM and stored
procedures

·       Knowledge of performance monitoring and troubleshooting DB2
issues.

·       Strong skill set must be needed on DB2 data sharing experience and
failover process.

·       Good knowledge of Disaster recovery of DB2 systems includes
traditional DR and flash copy DR.

·       Interact with ticketing tool remedy, service center and other
business support areas for problem escalations, resolutions, reporting and
coordination.

·       Attend meetings and interact regularly with management, team and
clients to continuously improve services. Provide 24*7 support if needed on
the project support.

Detailed Job Description: JD – For
Heith replacement

• Should
  have experience in Mainframe CICS and MQ environment for 10+ years.
  
• Support
  the operations of the Mainframe CICS infrastructure(CICS & MQ
  series).
  
• Well
  versed with CICS resource definitions online(terminals, programs,
  bundles etc.), defining new CICS regions etc.
  
• Experience
  in upgrade of CICS TS from lower version to higher version.
  
• Knowledge
  on CICS Transaction Gateway and CICS webservices and CICSplex Operations
  
• Experience
  in vendor product install / upgrade and applying PTF for maintenance
  
• CICS
  SSL Setup Troubleshooting
  
• Experience
  in CICS Monitoring Tools - CA SYSVIEW / Omegamon / Mainview etc.
  
• Well
  versed with CICSPLEX Setup (CMAS), MRO region Setup and troubleshoot
  related issues.
  
• Experience
  and strong knowledge as a Websphere MQSeries on z/OS v7.1 / v9.0 
  
• Install
  new releases, apply PTFs to Webshere MQ on z/OS
  
• Well
  versed with MQ Clustering and MQ Objects/Channels/Queues
  
• Experience
  with upgrading IBM MQ for z/OS will be added advantage. 
  
• z/OS
  connect
  
• zIOA
  installation and configuration