Mainframe IMS DBA || Remote || High Priority

Greetings from IDC Technologies!! 

Please let me know your interest for the below position 

Share with me your updated resume along with expected pay rate details 

 

Title: Mainframe IMS DBA
Location: Jacksonville, FL/ Remote


  

Job Description:  

  • Database Administration
    • 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)
  • Database Design and related utilities
    • 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
  • Coding and usage of IMS reorganization utilities (including IBM, BMC, CA), including: unload, prefix resolution, reload, prefix update, secondary index build, image copy, and pointer checker
  • 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 DB recovery utility
    • How to use DBRC to generate JCL for forward recovery and point-in-time database recovery.
  • Database monitoring
    • Space management
    • Database dataset space reporting for proactive outage avoidance.
    • How to immediately fix an out of space condition for a VSAM database dataset
    • 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

Thanks & Regards

IDC Technologies


Removed

You received this message because you are subscribed to the Google Groups “CTC-requirements” group.
To unsubscribe from this group and stop receiving emails from it, send an email to ctc99requirements+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ctc99requirements/CAHCYuiabE8QVfN9oQhYKMSFkCcgoL_7ZN5dHr7TFM_tYC-oxNA%40mail.gmail.com.

Leave a Reply

Your email address will not be published. Required fields are marked *