Job Description – Mainframe DB2 Application Development

Position

Mainframe DB2 Application Developer

Experience

4–8 Years

Job Summary

We are looking for an experienced Mainframe DB2 Application Developer with strong hands-on expertise in COBOL, DB2, JCL, SQL, and CICS. The candidate will be responsible for developing, enhancing, testing, and supporting enterprise Mainframe applications with a robust focus on DB2 application development and performance.

Key Responsibilities
- Develop, enhance, and maintain Mainframe DB2 applications using COBOL and SQL.
- Analyze business and technical requirements and translate them into application solutions.
- Develop and optimize DB2 SQL queries, stored procedures, and database programs.
- Design and maintain DB2 tables, indexes, views, and other database objects.
- Develop COBOL programs with embedded DB2 SQL.
- Create and maintain JCL for batch processing and application execution.
- Develop and support CICS-DB2 online transactions where required.
- Perform DB2 data analysis, troubleshooting, and performance tuning.




- Analyze SQL access paths and recommend appropriate indexing and query optimization.
- Handle DB2-related production issues, job abends, data issues, and application failures.
- Perform unit testing, integration testing, regression testing, and defect resolution.
- Participate in code reviews and ensure adherence to Mainframe development standards.
- Support application releases, deployments, and production implementation activities.
- Prepare technical documentation and support knowledge-transfer activities.
- Collaborate with Business Analysts, QA teams, Application Support, and other technical teams.

Required Skills
- Strong hands-on experience in IBM DB2 application development.
- Strong programming experience in COBOL.
- Excellent knowledge of DB2 SQL.
- Good experience with JCL.
- Experience with CICS and CICS-DB2 applications.
- Strong understanding of DB2 database concepts, including:
- Tables and i

📌 Mainframe (Pune)
🏢 SPG Consulting
📍 Pune