Z/OS Mainframe IMS DB2 Database Administrator

Kyndryl

Jan 27, 2025

Job
Full-time
Expert Level
Software Engineering
IT & Cybersecurity
Melbourne
Quick Apply

AI generated summary

You need a bachelor's degree or equivalent, 10+ years in IMS/DB2 admin, expertise in BMC/IBM tools, knowledge of DB2 performance, DR, troubleshooting, and strong automation skills.
You will manage, design, and optimize IMS and DB2 databases, coordinate recovery and security, perform day-to-day maintenance, support critical applications, and collaborate with team members.

Requirements

Bachelor's degree required and/or equivalent work experience.
10+ years of professional experience in IMS and DB2 database administration.
BMC COPE and IBM tools for IMS and DB2.
IMS and DB2 systems programming support is a plus
Extensive experience with the following:
Knowledge of the best practices of software management, maintenance and documentation
Establishing policies and procedures pertaining to database management, DR, maintenance and utilization
Evaluating change requests and determine impact to assigned clients
Vendor consultations for problems and questions
DR recovery of application objects
Troubleshooting and solving production database issues
Demonstrated ability to respond quickly and effectively to support requests from client
Supporting customer for after hours on-call
Deep knowledge of IMS database organization using access methods of VSAM and OSAM
Full function database organization types
HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
Definition and use of LOGICAL databases
HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
Fast Path databases (DEDBs)
Broad knowledge of DB2 for Z/OS database components and concepts
DB2 Program Preparation, Bind and Locking
DB2 Storage Concepts
DBD source coding and DBDGEN
PSBGEN source coding and PSBGEN
How databases are processed using secondary indexes (PROCSEQ=)
Correct usage of PROCOPT= to minimize database locking
ACBGEN
Online Change
IMS commands related to ACB and FORMAT changes
DB2 Entity Relationship Modeling and Normalization
DB2 Referential Integrity
DB2 and IMS Omegamon monitor
Coding and usage of IMS and DB2 DBA utilities (including IBM, BMC, CA)
Unload
IMS DB Prefix resolution
Reload
IMS DB Prefix update
Secondary index build
Image copy
IMS DB Pointer checker
IMS Performance Analyzer
Online and batch reorganization
DB2 RUNSTATS
DB2 SQL Performance optimization
Proficient in DB2 for z/OS DDL, DML, DCL
Experience with IBM DB2 V12+ and IMS V15
Experience with IBM DB2 Administration Tool.
Experience with a database performance monitoring tools like Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation
REXX, ISPF, CLIST, or other database automation development skills/experience.
Experience with DB2 triggers
Experience with IBM Infosphere Data Replication (CDC) for IMS
Experience with IBM DB2 performance management and tuning;
Support planned (disaster recovery) and unplanned (emergency) database recovery activities
Knowledge of log archive and change accumulation utilities
How to perform a log archive on demand
Knowledge of IMS and DB2 DB recovery utilities
How to use DBRC to generate JCL for forward recovery and point-in-time database recovery
Space management
Database dataset space reporting for proactive outage avoidance.
How to immediately fix an out of space condition for a VSAM database dataset
Experience with Omegamon for IMS and DB2
Identification and resolution of performance issues
Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
Extracting information from IMS logs using DFSERA10 and related utilities DFSUTR20 and DFSUTR30
Use of DFSDDLT0 utility to access data
Program/transaction monitoring – Familiarity with usage of IBM's IMS performance Analyzer product is a plus
Using DBRC to monitor database activity

Responsibilities

The Database Administrator creates, maintains, designs, monitors and troubleshoots client IMS databases and DB2 objects.
Proficient with IBM IMS and DB2 database management utilities, develop and implement database recovery mechanisms and procedures for both IMS and DB2 components, and coordinate security measures to safeguard IMS and DB2 database integrity.
To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs.
To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS systems and tools upgrades.
To provide DBA support to a list of critical applications that use DB2 z/OS and IMS databases/transactions.
The successful candidate will perform IMS database and DB2 object changes coupled with administration and tuning to support our customers' IMS and DB2 environments.
The individual will need to work with vendor personnel to achieve timely solutions of database problems.
The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.
The successful candidate will be called upon to perform a variety of IMS and DB2 database optimizations that will include general reporting and analysis of the efficiency of the IMS database and DB2 objects configuration and periodic review of IMS database and DB2 objects performance.
Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
To ensure that all databases and environmental changes are appropriately tested and implemented in such a manner that there is no impact to the systems and clients.
The individual will need to participate in on-call responsibilities.

FAQs

What is the main responsibility of a Z/OS Mainframe IMS DB2 Database Administrator at Kyndryl?

The main responsibility is to manage and administer IMS and DB2 databases, ensuring their performance, security, disaster recovery, and alignment with business operations.

What qualifications are required for this position?

A Bachelor's degree and/or equivalent work experience, along with 10+ years of professional experience in IMS and DB2 database administration, are required.

What skills are essential for a successful candidate in this role?

Essential skills include extensive knowledge of IMS database organization, DB2 database components and concepts, database design, performance optimization, and various DBA utilities, as well as troubleshooting capacity and the ability to work closely with vendor personnel.

Are there opportunities for career growth at Kyndryl?

Yes, Kyndryl offers a path for career growth from Junior Administrator to Architect, along with training and upskilling programs that provide hands-on experience and learning opportunities.

Is experience with IBM tools for IMS and DB2 necessary?

Yes, proficiency with BMC COPE and IBM tools for IMS and DB2 is required for this position.

Will I be required to work on-call?

Yes, participation in on-call responsibilities is a requirement for this position.

Does the job involve collaborating with other teams?

Yes, the role requires working closely with various teams to coordinate database project plans and ensure alignment with organizational goals.

What kind of training and certifications does Kyndryl provide?

Kyndryl offers access to training programs for certifications across major platforms including Microsoft, Google, Amazon, and more.

Are diversity and inclusion important at Kyndryl?

Yes, Kyndryl values diversity and inclusion, actively creating a workplace that welcomes individuals from various cultures, backgrounds, and experiences.

What are some of the disaster recovery responsibilities for this position?

Responsibilities include developing strong backup and recovery plans, conducting planned and unplanned database recovery activities, and ensuring that all procedures protect database integrity.

Kyndryl

We design, build, manage and modernize the mission-critical technology systems that the world depends on every day.

Consulting

Industry

10,001+

Employees

2021

Founded Year

Mission & Purpose

We have the world’s best talent that design, run, and manage the most advanced and reliable technology infrastructure each day. Together, we think holistically about the health of these vital technology ecosystems. We are a focused, independent company that builds on our foundation of excellence by creating systems in new ways. Bringing in the right partners, investing in our business, and working side-by-side with our customers to unlock potential. We're raising the bar. Our experience speaks for itself: We have 90,000 highly skilled employees around the world serving 75 of the Fortune 100. But our purpose is what drives us: Advancing the vital systems that power human progress. Because when a digital ecosystem is healthy, it can more readily adapt and support continuous growth and that opens up a world of possibility for everyone. Together, we are the heart of progress.