Mainframe (DB2 DBA) Admin

Mainframe (DB2 DBA) Admin

Location: Cleveland, Ohio

Duration: Long term Contract

Description:

Database Administrator This Senior Database Administrator is responsible for designing, developing, and implementing infrastructure to provide highly-complex, reliable, and scalable databases to DLI's mainframe IMS (OSAM, HALDB), DB2 and VSAM databases.

• The Database Architect needs to be familiar with a variety of the mainframe database technologies, concepts, methodologies, practices, and procedures and rely on experience and judgment to plan and accomplish goals. The Database Architect is able to perform a variety of complicated tasks with minimal or no direct supervision.
• They assist in defining system and application architecture and provide vision, problem anticipation, and problem solving ability to organization. They consult with the client and the development support staff to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.

Role Description:

• Possesses extensive knowledge of one or more mainframe database systems, and is capable of hands-on work in all phases of database design and management.
• Design, develop, and implement infrastructure to provide highly-complex, reliable, and scalable database to meet the organization's objectives and requirements.
• Analyzes organization's business requirements for database design, and implements changes to database as required.
• Performs systems analysis on database, and resolves performance, capacity, and replication issues as necessary.
• Provides detailed design and specification documentation, including flowcharts, for all aspects of the databases.
• Works with the application support staff to develop methodologies, report views, queries, and table replications
• Ensures that all the data is in the proper format.
• Participates in the identification, prioritization, and development of technical initiatives and strategies.
• Develops and maintains database standards and naming conventions.
• Keeps up-to-date on relevant mainframe emerging database architectures, technologies, and methodologies, and attends training classes as necessary.
• Actively participates in the extract and load of IMS and DB2 data for all Disaster Recover Exercise Programs
• Actively participate in the Disaster Recovery effort if required
• Assist as directed in the data conversion effort to a new Benefits application database

Skill

• Data dictionary analysis and design and data model analysis design
• 4 year college degree or equivalent technical study.
• Experience supporting application system development life cycle
• Business systems analysis and design experience
• Administration and scripting experience
• IBM DB2 experience
• IBM IMS experience