Database Architects in Albany, NY 12228

Job Title:Database Architect

Location: Albany, NY 12228

Duration: 30 Months

Responsibilities

• Duties include but are not limited to the following: installation, configuration, and application support for CA IDMS. Secondary responsibilities include general z/OS support.

• Generate and administer IDMS’s CV/DC/UCF Systems.

• Administer IDMS’s Central Version and Local Mode Operation.

• Perform IDMS journal management.

• Provide performance analysis and troubleshoot system problems.

• Provide diagnostic analysis of IDMS’s DC, DB, and UCF environments.

• Provide assistance to application developers with IDMS’s Data Manipulation Language (DML).

• Perform online query database navigation.

• Provide data integrity and dictionary security.

• Perform logical and physical database design.

• Perform backup and recovery procedures for all IDMS databases.

• Create data structure diagrams.

• Navigate and compile objects using Data Dictionary Definition Language (DDDL).

• Create database schema, DMCL and subschema definitions.

Requirements

• 84 months of experience in CA IDMS database administration and maintenance.

• 60+ months experience with CV/DC/UCF system generation.

• 60+ months experience with Central Version and Local Mode operation.

• 60+ months experience developing and maintaining backup and recovery procedures.

• 60+ months experience with Data Dictionary Definition Language (DDDL) compiler as well as schema and subschema definitions.

• 60+ months experience with IDMS journal management.

• 60+ months experience with IDMS Data Manipulation Language (DML).

• 60+ months experience with data integrity and dictionary security.

• 60+ months experience data structure diagraming.

Education

• Bachelor’s Degree in Computer Science, Engineering or related discipline.