Consultant - Databases

About the role

An individual with the technical skill and experience in General Databases around Db2, Datacom, IDMS and Data Base Management Systems (DBMS). Displaying a broad range of disciplines, environments, and DBMS best practices within the DBMS practice or, the individual may possess skills and technical experience in DB2/IMS/IDMS software. Provides assistance and recommendations to management and clients on DBMS / Datacom topics pertaining to the architectural design and development of applied systems and software services for DBMS/Datacom. Consultant is a requirement for this position. Ability to travel to client sites is required for this position.

Responsibilities

• Installation, configuration, and application support for Datacom
• General z/OS support for Broadcom DB2 tools software
• Generate and administer Datacom Systems
• Administer Datacom
• Provide performance analysis and troubleshoot system problems
• Provide diagnostic analysis of Datacom environments
• Provide assistance to application developers with Datacom Data Base Manipulation
• Perform online query database navigation
• Provide data integrity and dictionary security
• Perform logical and physical database design
• Perform backup and recovery procedures for all Datacom databases
• Create data structure diagrams

Skills

• 24-36 months of experience in CA Datacom database administration and maintenance
• 24+ months experience with Datacom system patching and maintenance
• 24+ months experience developing and maintaining backup and recovery procedures
• 24+ months experience with Data Dictionary Definition Language (DDDL) compiler as well as schema and subschema definitions
• 24+ months experience with Datacom journal management
• 24+ months experience with Datacom Data Manipulation
• 24+ months experience with data integrity and dictionary security
• 24+ months experience data structure diagraming

People and Communication Skills