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 strong 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.
Valuable experience with JCL.
Experience with CICS and CICS-DB2 applications.
Strong understanding of DB2 database concepts, including:
Tables and indexes
Primary/foreign keys
Views
Referential integr

📌 Mainframe (Bengaluru)
🏢 SPG Consulting
📍 Bengaluru