Komplete Teleservices

5 jobs near Columbus, OH

Mainframe IMS Application DBA - Phoenix, AZ (priority) / NJ / NC / TX / FL / VA / IL(Hybrid - 3 days

Komplete Teleservices

Chicago, IL โ€ข On-site

Other

Posted 5 days ago


Job description

We are seeking an experienced Mainframe IMS Application DBA (IMS DBA Analyst) to manage and
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
Experience with Performance and Tunning
Required Skills & Qualifications:
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.