CareerStation
TE

Mainframe DB2 - Application Development

Teamware Solutions
Bangalore ₹4-6 LPA Posted 16 Jul 2025
FULL TIME
Git
Endevor
Sql
SCCS

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.

Required Skills

GitEndevorSqlSCCS