Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Mainframe DB2 Application Development.
India Jobs Expertini

Urgent! Mainframe DB2 - Application Development Job Opening In Bengaluru – Now Hiring Confidential

Mainframe DB2 Application Development



Job description

  • Key Responsibilities:
  • Application Development and Support:
  • Develop, implement, and maintain DB2-based applications on the mainframe, ensuring they meet business requirements and performance standards.
  • Collaborate with business analysts to gather and translate functional requirements into technical specifications for DB2 applications.
  • Develop SQL queries, stored procedures, triggers, and views to support application functionality.
  • Code and test new application modules and enhancements, ensuring compliance with organizational development standards.
  • Database Design & Optimization:
  • Design, implement, and optimize DB2 database structures (tables, indexes, and views) to ensure data integrity, accuracy, and performance.
  • Optimize SQL queries for performance and scalability, minimizing resource consumption and improving response times.
  • Conduct DB2 database tuning and performance analysis to identify and resolve issues, such as slow query performance or inefficient indexing.
  • System Integration & Testing:
  • Work with integration teams to ensure smooth interaction between DB2 databases and other systems (including legacy and cloud-based systems).
  • Develop unit tests, integration tests, and system testing procedures for DB2 applications.
  • Participate in the debugging and issue resolution of application errors, ensuring timely fixes and minimal downtime.
  • Maintenance and Upgrades:
  • Perform regular system maintenance tasks, including backups, security patches, and database upgrades to ensure optimal database health and performance.
  • Ensure the integrity and security of the DB2 database by implementing appropriate access controls and data protection measures.
  • Participate in the migration and upgrade of DB2 databases to newer versions, ensuring compatibility with existing systems.
  • Collaboration & Documentation:
  • Collaborate with cross-functional teams, including developers, QA engineers, and system administrators, to deliver end-to-end solutions for DB2 applications.
  • Create and maintain technical documentation, including design documents, database schema, and user manuals, ensuring that they are up-to-date and comprehensive.
  • Provide guidance and mentorship to junior developers on best practices, debugging techniques, and DB2-related technologies.
  • Incident Management & Troubleshooting:
  • Investigate, diagnose, and resolve database-related issues and incidents in a timely manner to minimize business impact.
  • Provide on-call support for DB2-related incidents, performing root-cause analysis and implementing corrective actions.
  • Monitor DB2 databases for availability, performance, and capacity, proactively addressing any potential issues before they escalate.
  • Compliance & Security:
  • Ensure that all DB2 applications comply with organizational security policies and industry regulations (e.g., GDPR, HIPAA).
  • Implement database encryption, access control policies, and audit trails to ensure sensitive data is protected and regulatory compliance is maintained.
  • Continuous Improvement:
  • Stay current with the latest Mainframe DB2 technologies, trends, and best practices in database management and application development.
  • Suggest improvements to existing systems and processes, driving automation, efficiency, and cost reduction.
  • Contribute to the development of strategies for scalability and performance optimization across DB2-based applications.
  • Required Qualifications:
  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 3+ years of experience in Mainframe DB2 application development or similar roles, including working with COBOL, JCL, and DB2 databases.
  • Strong experience in DB2 database administration, SQL query optimization, and database design on the mainframe platform.
  • Proficiency in COBOL programming, including integration with DB2 for data access and manipulation.
  • Strong understanding of relational database management systems (RDBMS) and concepts such as normalization, indexes, joins, and ACID properties.
  • Experience with database performance tuning, query optimization, and database indexing for large-scale enterprise applications.
  • Familiarity with mainframe tools such as Endevor, Zowe, or ISPF.
  • Knowledge of JCL (Job Control Language) and its integration with DB2 and other mainframe applications.
  • Experience with version control systems (e.g., Git, SCCS) and change management tools.


Skills Required
Git, SCCS, Sql, Endevor


Required Skill Profession

Computer Occupations



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Mainframe DB2 Potential: Insight & Career Growth Guide