Job ID :
7807
Company :
State of Iowa
Location :
DES MOINES, IA
Type :
Contract
Duration :
1 Year
Salary :
Open
Status :
Active
Openings :
1
Posted :
27 Aug 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com
Int. type- Both Phone and In Person.

Short Description:  The Database Administrator (DBA) is responsible for data analysis and database management.

Complete Description:  The agency is looking for a highly motivated individual 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, and providing day to day customer support.  This individual 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.

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


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.


Skill
Required / Desired
Amount
of Experience
Knowledge of IDMS database structures
Required
15
Years
Experience using IDMS DBA utilities
Required
15
Years
Extensive JCL experience
Required
15
Years
Ability to independently research and resolve problems
Required
15
Years
IDMS system programming experience
Required
15
Years
Monitor/tune CV and batch performance (SYSGEN, DMCL buffers, etc.)
Required
15
Years
Experience with relational IDMS
Highly desired
 
 
Experience installing and upgrading software for IDMS and third-party products
Highly desired
 
 
Perform 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