Mainframe DB2 - Application Development

Teamware Solutions

2 - 6 years

4 - 6 Lacs

bengaluru karnataka india

Posted:21 hours ago| Platform: Foundit logo

Apply

Skills Required

sccs zowe

Work Mode

On-site

Job Type

Full Time

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.