Mainframe Database

Key Responsibilities

• Design, develop, and maintain mainframe database systems
• Work with DB2 / IMS / VSAM databases on mainframe platforms
• Write and optimize SQL queries, stored procedures, and batch jobs
• Perform database performance tuning and optimization
• Monitor database health, backups, and recovery processes
• Support COBOL-based applications interacting with databases
• Troubleshoot data-related issues and ensure data integrity
• Collaborate with application developers and system teams
• Maintain documentation for database structures and processes

Required Skills & Qualifications

• Bachelor’s degree in Computer Science, IT, or related field
• Strong knowledge of IBM Mainframe environment (z/OS)
• Experience with DB2, IMS DB, and VSAM
• Proficiency in COBOL, JCL (Job Control Language)
• Strong SQL and database design skills
• Understanding of batch processing and scheduling tools
• Familiarity with data backup, recovery, and security practices
• Good debugging and problem-solving skills

Preferred Qualifications

• Experience with CICS (Customer Information Control System)
• Familiarity with RACF security
• Knowledge of Endevor / Changeman (version control tools)
• Exposure to mainframe modernization or migration projects
• Experience with performance tuning tools and utilities
• Understanding of distributed systems integration