Mainframe IMS Database Administrator/ IMS DBA

Mainframe IMS Database Administrator

Dearborn,MI

Job Description:

• 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

Mainframe Environment

• 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

DBDGEN, PSBGEN, ACGEN, Segment definitions, PCB definitions, Application Control Blocks, Schema changes, Access path definitions, Database tuning

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 Handling & Troubleshooting

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