Mainframe IMS Application DBA

Komplete Teleservices
Chicago, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Chicago, United States of America

Tech stack

Adaptable Database Systems
Adobe InDesign
API
Backup Devices
Big Data
Business Software
Customer Information Control System (CICS)
Databases
Data Integration
Data Integrity
Data Recovery
Data Sharing
IBM DB2
Database Design
Database Storage Structures
Distributed Systems
Monitoring of Systems
Job Control Language (JCL)
Rexx (Programming Language)
IBM Information Management System
Microsoft Visio
Performance Tuning
Software Engineering
Systems Integration
Z/OS
Tso/ispf
Scripting (Bash/Python/Go/Ruby)
System Availability
Control Structures
Data Language Interface
Database Performance
Indexer
Database Migration
Performance Monitor
Omegamon
Database Replication
Database Monitoring
Data Inconsistencies
ServiceNow

Job description

support IMS database environments in a high-availability enterprise setting. This role is responsible for database design support, performance optimization, data integrity, and backup/recovery operations for mission-critical applications running on IBM z/OS. Install, configure, and maintain IMS database environments (IMS DB) Support and manage different IMS database types: o Full Function DB o Fast Path DB o HALDB (High Availability Large Databases) Perform database administration activities: o Database definition, allocation, and dataset management o REORGs and space management to maintain performance Manage IMS control structures: o DBD, PSB, ACB libraries, and IMS Catalog Execute and support IMS utilities: o Load / Unload o Reorganization o Image Copy o Recovery utilities (e.g., DFSURGL0, DFSUICP0) Monitor database performance and resolve issues: o Access path inefficiencies o Space constraints o Application-related data issues o Abends and data inconsistencies Collaborate with: o Application development teams (DL/I access, database design) o IMS System Programmers (performance and tuning) o Operations teams (batch and online processing) Participates in design, development and implementation of complex Databases or maintenance and support of the infrastructure supporting IMS databases, often using new technologies and emerging methodologies.

Manages multiple, moderately complex projects and may direct activities of a team related to special initiatives or operations. Routine accountability is for technical knowledge and capabilities as a team member or as an individual contributor. Design technical solution to match business application requirements Create process flow charts and related procedural documentation. Perform database recovery of all types (Image Copy recovery, PIT recovery). Provide independent application development support

Requirements

Minimum 7 years of DBA experience supporting IMS databases in a z/OS environment using Sysplexed Data Sharing. Must have knowledge of Full Function, Fast Path and HALDB databases using Secondary Indexing, Logical Relationships, Sparsing Routines (Assembler), Replication, Compression, Encryption. Database performance and tuning, Database monitoring and troubleshooting, Physical database design and build, Backup and recovery Strong experience with IBM z/OS environment Hands-on experience as IMS Application DBA (IMS DB) Experience with IMS utilities and DB maintenance activities Experience troubleshooting: o Database abends (Uxxx, S0Cxx) o Data corruption or integrity issues Familiarity with: o JCL, TSO/ISPF, SDSF, REXX o Batch and online IMS environments (IMS DB/DC) o IMS Database Administration Utilities, BMC utility and monitoring tools or equivalent. Preferred Qualifications: Experience integrating IMS with: o DB2, CICS, MQ, and distributed systems Experience with performance tools (e.g., OMEGAMON, MainView) Exposure to IMS modernization (APIs, z/OS Connect) Knowledge of scripting/automation (REXX) Experience in large-scale IMS database migrations or consolidation Exposure to data replication or data integration solutions Experience in regulatory/compliance-driven environments (SOX, PCI, etc.) Management procedures and/or tools (ISPW, Service Now). Experience with VISIO a plus.

Apply for this position