IDMS Database Administrator

The IDMS DBA is responsible for working closely with application development teams, Clemson z/OS system support staff and the Clemson Database Administrators to provide IDMS DBA support for application and infrastructure databases. Duties include:

• Hands-on IDMS monitoring and application support in ways that are consistent with IDMS best practices.
• Collaboration with Clemson''s database administration team to maintain test, staging, production databases and the development of operations procedures for database management.
• Enable and tune IDMS features to optimize the performance of databases in the context of the mainframe environment. Generate and analyze performance data, recommend courses of action and implement best solutions to achieve optimum performance.
• Coordinating with outside entities, including vendors for other systems/services, providers, professional associations, and other State agencies.
• Advising development and product teams on best approaches for required data model extensions and/or changes.
• Participate in a 24x7 on-call support rotation.
• Other duties as assigned. Clemson is seeking an IDMS professional with the knowledge and experience along with comparable communication and interpersonal skills to enable success on this high-visibility project. Environment and Tools: VB.Net, C#.Net, Java, Javascript, CSS, HTML, JQuery, Cobol, CICS, SQL, TSO, JCL, ADSO, Assembler, RPG

15+ years of experience with IDMS deployment and operations in a z/OS environment on a z-series IBM mainframe computer. 10+ years of experience with IDMS SQL option. Be able to create and support IDMS databases that are deployed using the relational model with SQL syntax. Understand the implementation of SQL access to native IDMS databases. 15+ years of experience with deployment of IDMS security, including security of ADS/O application structures, IDD and relational database objects. 15+ years of experience with application programming for the IDMS database, both native and SQL, using the COBOL and ADS/O programming languages. 12+ years of experience with IBM High Level Assembler on the z/OS operating system. 10+ years of experience with IDMS Perfmon online monitoring and report generation.

Preferred Skills. RACF security knowledge. Knowledge of application change management. Healthcare industry experience and/or experience managing PHI/PII data Medicaid Management Information System (MMIS) experience Medicaid operations experience. Public sector experience is a plus., The IDMS DBA role has four major attributes: Database deployment and administration leadership, project management skills, people skills, and domain knowledge in enterprise class application development projects. Candidates must display excellence in all areas.

• 15+ years of experience with IDMS deployment and operations in a z/OS environment on a z-series IBM mainframe computer.
• 10+ years of experience with IDMS SQL option. Be able to create and support IDMS databases that are deployed using the relational model with SQL syntax. Understand the implementation of SQL access to native IDMS databases.
• 15+ years of experience with deployment of IDMS security, including security of ADS/O application structures, IDD and relational database objects.
• 15+ years of experience with application programming for the IDMS database, both native and SQL, using the COBOL and ADS/O programming languages.
• 12+ years of experience with IBM High Level Assembler on the z/OS operating system.
• 10+ years of experience with IDMS Perfmon online monitoring and report generation.

Additional Skills:

• Understanding of IT development and implementation projects.
• Project planning experience, including effort estimation on technical tasks and resource allocation.
• Strong written and oral communications skills, including the ability to give presentations to project management.
• Impeccable integrity. This project will have very high visibility and will impact significant expenditures of public funds. Candidates must be confident with their abilities to make correct decisions and the courage to speak out when necessary.
• Willingness and ability to effectively engage with people and organizations on a continuous basis.