Description

You will administer, design, implement, and support highly available and scalable Mainframe DB2 & IMS database solutions.

Responsibilities

• Administer, design, implement, and support highly available and scalable Mainframe DB2 & IMS database solutions.
• Implement data models, database designs, data access, and table maintenance codes.
• Implement and maintain DB2/IMS Databases using Data Partitioning and Database replication features.
• Resolve database performance, capacity, replication, and other data issues.
• Provide up to Level 2 on call support for the 24/7 DB2/IMS database environment.

Required Skills

• 5+ years applied experience in Database design/development, integration, performance monitoring & tuning, systems re-engineering, and Operations support.
• Expertise with IMS Full Function/Fast Path database implementation, REXX programming, and MQ.
• Knowledge of DB2 for z/OS along with mainframe tools: BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF.
• Experience with IBM Replication CDC, QREP, and Data Replication/streaming via CDC/QREP/MQ.
• Proficiency in database performance monitoring, analysis, and defining optimization recommendations.
• Experience with data modeling tools and operational/data warehouse design concepts.
• Familiarity with Atlassian tools like Jira and Confluence.

Preferred Skills

• Experience providing 24x7 rotational support.
• Understanding of Distributed and Static SQL workloads.

Key Skills

Education

Any Gradute