Mainframe DB2 - Application Development

ConfidentialBengaluru / Bangalore

30+ days ago

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

Create a job alert for this search

Application Development Application • Bengaluru / Bangalore

Related jobs

Promoted

Application Developer - Mainframe Modernization

SMARTWORK IT SERVICESBangalore

Job Title : Application Developer - Mainframe Modernization.Experience : 5- 7 Years.Location : Bangalore.Job Description : Show moreLast updated: 30+ days ago

Promoted

Senior SME - Mainframe DB2 System Programmer

ConfidentialBengaluru / Bangalore, India

At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl We are always moving forward – always pushing o...Show moreLast updated: 30+ days ago

Promoted

Architect-Mainframe IMS DB2 system support

KyndrylBengaluru, Karnataka, India

This job is with Kyndryl, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.Who We Are At Ky...Show moreLast updated: 1 day ago

Promoted

Mainframe Developer

Tata Consultancy ServicesBengaluru, Karnataka, India

Bangalore / Chennai / Hyderabad / Pune.Strong expertise in COBOL, JCL, DB2, CICS, VSAM and IMS DB / DC.Knowledge of Mainframe Utilities (Panvalet, Endevor, IDCAMS, SORT, etc. Familiarity with API enablem...Show moreLast updated: 28 days ago

Promoted

Mainframe System Programmer

DXC TechnologyBangalore Urban, Karnataka, India

Location : Any DXC India Location.Environment- Subsystem setup, Backup & Recovery and Data Sharing.Experience and Expertise in Monoplex, SYSPLEX architecture and data sharing architecture.Experience...Show moreLast updated: 22 days ago

Promoted

Senior SME - Mainframe DB2 System Programmer

KyndrylBengaluru, Karnataka, India

Promoted

SME - Mainframe DB2 System Programmer

KyndrylBengaluru, Karnataka, India

Promoted

Mainframe System Programmer - CICS

Global Talent Track Private Limited (Global Talent Track)(231)Bangalore

About GTT Data Solutions : At GTT Data, we are pioneers in shaping Dual Intelligence, seamlessly integrating Human Intelligence (HI) with A...Show moreLast updated: 30+ days ago

Promoted

Lead - Mainframe IMS DB2 System Support

KyndrylBengaluru, Karnataka, India

Promoted

Mainframe DB2 DBA Professional

ConfidentialBengaluru / Bangalore

Database Administration skills on DB2.Attend meetings and interact regularly with management, team, and clients to continuously improve services. Participate in On-Call rotation schedule.Bachelor's ...Show moreLast updated: 30+ days ago

Promoted

Mainframe Modernization Application Developer

KyndrylBengaluru, Karnataka, India

Promoted

Mainframe Z / OS System Programmer

KyndrylBengaluru, Karnataka, India

Promoted

Mainframe DB2 System Programmer

KyndrylBengaluru, Karnataka, India

Promoted

Mainframe System Programmer - DB2 / BMC MainView

People Prime World WideBangalore

About Company : Our Client is a multinational IT services and consulting company headquartered in USA, With revenues 19....Show moreLast updated: 30+ days ago

Promoted

Mainframe Developer

Alp Consulting Ltd.Bengaluru, IN

Face to Face interview Mandatory.Extensive experience working with AS400 systems, including RPG programming and DB2 databases. Proven track record in leading legacy system retirement and enterprise ...Show moreLast updated: 14 days ago

Promoted

Mainframe CICS Application Programmer

INDIGLOBE IT SOLUTIONS PRIVATE LIMITEDBangalore

Position : Mainframe CICS Application Programmer Experience : 8+ Years Location : Bangalore Show moreLast updated: 30+ days ago

Promoted

Mainframe Transformation Engineer - z / OS

Stanley David And Associates (SDNA Global)Bangalore

Description : - Develop and execute a modernization strategy for Mainframe infrastructure to drive innovation, automation, productivity, and efficiency.This includes ...Show moreLast updated: 12 days ago

Promoted

Mainframe DB2 DBA System Administrator

KyndrylBengaluru, Karnataka, India