Job ID :
6899
Company :
State of Iowa
Location :
WALNUT, IA
Type :
Contract
Duration :
1 yr
Salary :
open
Status :
Active
Openings :
1
Posted :
10 Apr 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com
OCIO IDMS System Database Administrator with RECENT work on an IDMS upgrade, preferably to version 18.

The agency is looking for a highly motivated DBA with some programming experience  that works well with customers and team members for a robust and expanding set of IDMS legacy systems.  This individual will need to be comfortable doing senior level systems support including:

 -  upgrades, performance tuning, 
 - maintaining indexes, 
 - expanding systems, 
 - working with mainframe system engineers, 
 - providing day to day customer support.  

The contractor will also be required to work some off hour’s shifts and may be required to be on call.  

The agency is looking for an individual who is a self-starter, who is willing to research and stay current on IDMS version and who is willing to learn new technologies featured with each new version of IDMS and share with the group.  

This job offers the opportunity to continue to expand and improve IDMS.

Duties Include:

* Define and modify IDMS database definitions (DDL).
* Define and modify physical structures (files, DMCL).
* Perform database changes (restructure, unload/reload, etc.).
* Ensure that appropriate backup procedures are in place.
* Perform data recovery, including rollback and roll forward. 
* Use online monitors to resolve run-time problems.
* Maintain security definitions.
* Migrate ADS and DC-COBOL programs to QA and production.
* Assist users with utilities (maintain index, print space, etc.).
* Assist users with planning for size and performance.
* Assist users with questions and problems.
* Maintain database-specific JCL and documentation.
* Serve as backup for IDMS systems programmer.
* Occasional overtime and on-call required.


Initial contract funding is for 1 year, but a longer 3-5 year engagement is anticipated.



Required/Desired Skills-

Skill
Required / Desired
Amount
of Experience
Knowledge of IDMS database structures
Required
8
Years
Experience using IDMS DBA utilities
Required
8
Years
Extensive JCL experience
Required
8
Years
Ability to independently research and resolve problems
Required
8
Years
IDMS system programming experience
Required
8
Years
Monitor/tune CV and batch performance (SYSGEN, DMCL buffers, etc.)
Required
8
Years
Experience with relational IDMS
Highly desired
 
 
Experience installing and upgrading software for IDMS and third-party products
Highly desired
 
 
Monitor/tune CV and batch performance (SYSGEN, DMCL buffers, etc.)
Highly desired
 
 
Preform database changes (restructure, upload/reload, rollback and roll forward, etc)
Highly desired
 
 
Experience and ability to migrate ADS and DC-COBOL programs to QA and production
Highly desired
 
 
Maintain in house-developed web service software
Highly desired
 
 
Experience with ADS and COBOL
Highly desired
 
 
Skills with other database platforms a plus (DB2, SQL Server, Teradata
Desired
 
 
IDMS Upgrade Experience (preferably to version 18)
Required