Mainframe IMS Database Administrator/ IMS DBA

PDSSOFT INC.; Dearborn (MI); On-site; USD 70,000 - 90,000; Full time

Job summary

PDSSOFT INC. is looking for a skilled database professional in Dearborn, Michigan, with expertise in HDAM, HIDAM and IMS utilities. The role requires proficiency in various programming languages, including JCL and COBOL.

The candidate will perform critical database definition activities, as well as backup and recovery operations to ensure data integrity and availability. Strong problem-solving skills and familiarity with high availability environments are essential.

Qualifications

• Strong knowledge of hierarchical databases and IMS utilities.
• Experience with backup and recovery procedures in high availability environments.
• Familiarity with programming languages such as JCL, COBOL, and SQL.

Responsibilities

• Manage database definition activities and database integrity.
• Conduct backup and recovery activities and reorganization tasks.
• Utilize IMS tools for job scheduling and monitoring.

Skills

HDAM, HIDAM, DEDB

JCL

COBOL

Assembler

SQL (DB2 integration)

RAC(security)

Automation scripting

Tools

IMS Connect

Main View

OMEGAMON

SDSF

Job description

Database Skills

• HDAM, HIDAM, DEDB, Full Function, Secondary Index, HALDE, Fast Path, Hierarchical databases, Logical databases, Physical databases

IMS Utilities

• Image Copy, Recovery, HD Reorg, Pointer Checker, Index Rebuild, Database Load, Database Unload, Change Accumulation, Log Analysis, Batch utilities

IMS Tools

• IMSPOC, OPC scheduling tool, TSO/ISPE, SDSF, RAC(security), DBRC (Database Recovery Control), IMS Connect, OMEGAMON, Main View, monitoring tools

IBM z/OS (2.3+), JES2/JES3, VTAM, RACE, SMP/E, CICS integration, MQ integration, Parallel Sysplex, high availability environments

Programming Languages

• JCL, COBOL, Assembler, REXX, CLIST, PL/I, SQL (DB2 integration), scripting for automation

Database Definition Activities

Backup & Recovery / Reorganization

• Disaster recovery, Image copy scheduling, Recovery jobs, Reorg strategies, Index rebuilds, Pointer validation, Change Accumulation, Log replay, Failover procedures

8Space Management & Dataset Allocation

• VSAM datasets, Dataset allocation, Space abends, Secondary extents, Dataset growth patterns, Storage optimization, Catalog management, SMS rules, HSM migration

• Abend analysis, SOC7, SOC4, U0777, U0888, Space-related abends, Dataset contention, Deadlocks, Log analysis, Dump reading, Job log review, Controlled restarts