Previous Job
Senior IDMS/DB2 Database Administrator
Ref No.: 17-00206
Location: Pittsburg, Pennsylvania
Position Type:Contract
Start Date: 06/19/2017
Scientific Client , the world leader in serving science, is seeking a Senior IDMS and DB2 Database Administrator (DBA) to join our dynamic database services team. The candidate must have a minimum of 7 years' experience providing support for the CA IDMS and IBM DB2 databases in a high performance, high availability environment. Candidate must be able to demonstrate strong tuning, troubleshooting, and issue resolution skills, be versed in full life-cycle database support, as well as possess good written and verbal communications skills. Experience with IBM z/OS, assembler for z processors, IDMS compilers, COBOL, IDMS SQL, DB2 SQL, CA-Easytrieve, and production database support experience are required. An overall, general knowledge of information technology and an ability to resolve complex problems and proactively provide solutions is expected. Experience supporting databases for large applications is a plus.

Key Responsibilities
  • Work with applications teams to understand and satisfy complex database requirements
  • CA IDMS and IBM DB2 database installation, configuration, and management in an IBM z/OS environment
  • Implement, configure, and support IDMS and DB2 databases including patching and upgrades using CA-Chorus and IBM SMP/e
  • Provide database performance tuning, and assist with application tuning tasks
  • Ensure database compliance with various audit standards, and adherence to strict change control policies
  • Perform database backup, recovery, and refreshes
  • Automation of routine database tasks
  • Troubleshoot and resolve complex issues in a dynamic environment

  • Minimum 7 years CA IDMS and IBM DB2 database administration experience in an IBM z/OS environment
  • Experience with IDMS schema and subschema compilers, and on-line and batch dictionary editors (OCF/IDD/IDMClientF/IDMSDDDL).
  • Experience with IDMS utilities for REORG, TUNE INDEX, PRINT SPACE, and PRINT INDEX
  • Experience with DB2 utilities for LOAD, COPY, REORG, and RESTORE
  • Experience with IDMS Central Version configuration and tuning
  • CA Chorus use
  • DML command format and options
  • Assembler for z processors
  • IDMS system exits and Database Procedures
  • Strong working knowledge for z/OS as it applies to IDMS
  • IDMS ADS/Online complier and ADS/Trace operation
  • COBOL, with emphasis on IDMS DML navigation usage
  • Easytrieve
  • Culprit
  • IDMS SQL Usage
  • Understanding of SMS
  • Strong troubleshooting and issue resolution skills
  • Experience with database backup, recovery, and refreshes required
  • Excellent verbal and written communications skills required
  • Knowledge of the following preferred:
    1. TSO/ISPF
    2. MVS Utilities and SuperSession
    4. SMP/E
    5. CA SysView
    6. SDSF

BS Computer Science, Information Technology, or equivalent experience.