IT - Clemson University - Database Administrator - Project Lead

• Provide hands-on IDMS Database Administration (DBA) support for application and infrastructure databases.

• Work closely with:

• Application Development Teams

• Clemson z/OS System Support Staff

• Clemson Database Administration Team

• Monitor, administer, and support IDMS databases following industry best practices.

• Ensure database availability, reliability, and operational stability.

Database Operations & Performance

• Maintain development, test, staging, and production IDMS databases.
• Develop and maintain database operational procedures and standards.
• Enable, configure, and tune IDMS features for optimal database performance.
• Monitor database performance and generate performance reports.
• Analyze database metrics and recommend performance improvements.
• Implement performance tuning strategies within the IBM z/OS mainframe environment.

Database Design & Development Support

• Advise application development and product teams on:

• Database design

• Data model extensions

• Database schema modifications

• Best practices for database implementation

• Support both native IDMS and SQL-based database environments.

• Collaborate with development teams to ensure efficient database integration.

Collaboration & Stakeholder Management

• Coordinate with:

• Third-party vendors

• Service providers

• Professional organizations

• State agencies

• Internal technical teams

• Provide technical guidance and database expertise throughout project lifecycles.

• Participate in cross-functional planning and implementation activities.

Production Support

• Participate in a 24x7 on-call support rotation.
• Troubleshoot production database issues.
• Resolve database incidents and performance problems.
• Support critical enterprise applications running on the IBM mainframe platform.

Operating Systems & Mainframe

• IBM z/OS
• IBM z-Series Mainframe

Databases

• CA IDMS
• IDMS SQL Option

Programming Languages

• COBOL
• ADS/O
• IBM High-Level Assembler (HLASM)
• VB.NET
• C#.NET
• Java
• JavaScript
• HTML
• CSS
• jQuery
• RPG

Mainframe Technologies

• CICS
• TSO
• JCL
• SQL

Required Skills (Ranked by Importance) IDMS Database Administration

• 15+ years of experience deploying and administering CA IDMS databases in IBM z/OS environments.
• Extensive experience supporting enterprise-class IDMS database environments.

IDMS SQL

• 10+ years of experience with IDMS SQL Option.

• Experience:

• Creating SQL-based IDMS databases

• Supporting relational IDMS databases

• Implementing SQL access to native IDMS databases

Security Administration

• 15+ years of experience implementing and managing IDMS security, including:

• ADS/O application security

• IDD security

• Relational database object security

Application Development

• 15+ years of experience programming against IDMS databases using:

• COBOL

• ADS/O

• Experience with both:

• Native IDMS databases

• SQL-based IDMS databases

Mainframe Programming

• 12+ years of experience with IBM High-Level Assembler (HLASM) on IBM z/OS.

Performance Monitoring

• 10+ years of experience using IDMS Perfmon for:

• Online monitoring

• Performance reporting

• Database performance analysis

Additional Skills

• Strong understanding of enterprise IT development and implementation projects.

• Experience with:

• Technical project planning

• Resource allocation

• Effort estimation

• Excellent written and verbal communication skills.

• Experience presenting technical information to project managers and executive leadership.

• High level of integrity and accountability.

• Strong decision-making and problem-solving skills.

• Ability to work effectively with cross-functional teams and stakeholders.

• Strong interpersonal and relationship management skills.

Preferred Skills

• RACF Security Administration.

• Application Change Management experience.

• Healthcare industry experience.

• Experience managing:

• Protected Health Information (PHI)

• Personally Identifiable Information (PII)

• Medicaid Management Information System (MMIS) experience.

• Medicaid operations experience.

• Public sector or State Government experience.

Required Education

• Bachelor's degree in:

• Information Technology

• Computer Science

• Business

• Related technical field

• Equivalent professional experience may be considered in lieu of a degree.

• Master's degree preferred.

Required Certifications

• No certifications required.