SME - IBM DB2 for z/OS

HCL Technologies Limited; Pune District; On-site; INR 1,100,000 - 1,500,000; Full time

Job summary

HCL Technologies Limited is seeking an experienced DB2 specialist to work with IBM DB2 PureScale, focusing on automation, backups, and performance optimization. The role involves creating databases, managing security, and coordinating with application developers and vendor support.

You will participate in upskilling in PureScale, Ansible, and Pacemaker, taking ownership of automation tasks and contributing to efficient database management across production and development environments.

Qualifications

• Experience with IBM DB2 and PureScale.
• Strong knowledge of Ansible and Pacemaker.
• Automation emphasis: shell scripting and process improvements.
• L3–L4 troubleshooting of database incidents and performance issues.

Responsibilities

• Create databases and tables as per application requirements.
• Manage backups, security, and access controls for databases.
• Monitor and optimize database performance and I/O.
• Provide production and development environment support for DB2 databases.
• Restore databases and application servers as required and engage vendor support when needed.
• Plan and implement upgrades and manage storage and tuning.

Skills

DB2 PureScale

Ansible

Shell scripting

DB2 troubleshooting

Backup and recovery

Performance tuning

Pacemaker

PostgreSQL knowledge

Tools

Ansible

Pacemaker

PostgreSQL

Job description

One of the best opportunity to work with one of the latest customer of IBM DB2 , with Purescale feature

• Know how in IBM DB2 Purescale Feature is Essential (along with work experience)
• Create databases and tables as per requirements from application developers.
• Opportunities to work closely in Ansible / Purescale/ Pacemaker implementations in IBM DB2 , and hence willingness to upskill and work in DB2 PureScale technology is essential.
• Opportunities for automations - Willingness to take ownerships in automations, process improvements with respect to Database Management is really needed, especially in Ansible + Shell scripting
• L3-L4 level troubleshooting of Database related incidents is essential
• Manage backups, security, and controls of databases.
• Control and monitor user access to the database.
• Monitor and optimize database performance.
• Provide support for DB2 databases as per company procedures and policies.
• Engage with application vendor support until problem resolution.
• Restore databases and application servers when required.
• Manage storage and I/O performance issues related to databases.
• Design logical and physical structures of the database, including storage parameters.
• Perform database tuning and manage both production and development environments.
• Plan, document, and implement new database management system software and release upgrades upon company approval.
• Monitor the effectiveness and efficiency of database system operations and recommend and implement performance improvements for databases and user applications.
• Utilize table partitioning and table compression techniques.
• Use event monitors and snapshot monitors to regularly check database health.
• Write and maintain – Ansible Roles , shell scripts for automation and maintenance.
• Implement and maintain all procedures for backup and recovery of database management systems, including audit logs of all database activities.
• Experience with Ansible/PL1 , PostgreSQL know-how is an added advantage.

Key Responsibilities

One of the best opportunity to work with one of the latest customer of IBM DB2 , with Purescale feature

• Know how in IBM DB2 Purescale Feature is Essential (along with work experience)
• Create databases and tables as per requirements from application developers.
• Opportunities to work closely in Ansible / Purescale/ Pacemaker implementations in IBM DB2 , and hence willingness to upskill and work in DB2 PureScale technology is essential.
• Opportunities for automations - Willingness to take ownerships in automations, process improvements with respect to Database Management is really needed, especially in Ansible + Shell scripting
• L3-L4 level troubleshooting of Database related incidents is essential
• Manage backups, security, and controls of databases.
• Control and monitor user access to the database.
• Monitor and optimize database performance.
• Provide support for DB2 databases as per company procedures and policies.
• Engage with application vendor support until problem resolution.
• Restore databases and application servers when required.
• Manage storage and I/O performance issues related to databases.
• Design logical and physical structures of the database, including storage parameters.
• Perform database tuning and manage both production and development environments.
• Plan, document, and implement new database management system software and release upgrades upon company approval.
• Monitor the effectiveness and efficiency of database system operations and recommend and implement performance improvements for databases and user applications.
• Utilize table partitioning and table compression techniques.
• Use event monitors and snapshot monitors to regularly check database health.
• Write and maintain – Ansible Roles , shell scripts for automation and maintenance.
• Implement and maintain all procedures for backup and recovery of database management systems, including audit logs of all database activities.
• Experience with Ansible/PL1 , PostgreSQL know-how is an added advantage.

Skill Requirements

One of the best opportunity to work with one of the latest customer of IBM DB2 , with Purescale feature

• Know how in IBM DB2 Purescale Feature is Essential (along with work experience)
• Create databases and tables as per requirements from application developers.
• Opportunities to work closely in Ansible / Purescale/ Pacemaker implementations in IBM DB2 , and hence willingness to upskill and work in DB2 PureScale technology is essential.
• Opportunities for automations - Willingness to take ownerships in automations, process improvements with respect to Database Management is really needed, especially in Ansible + Shell scripting
• L3-L4 level troubleshooting of Database related incidents is essential
• Manage backups, security, and controls of databases.
• Control and monitor user access to the database.
• Monitor and optimize database performance.
• Provide support for DB2 databases as per company procedures and policies.
• Engage with application vendor support until problem resolution.
• Restore databases and application servers when required.
• Manage storage and I/O performance issues related to databases.
• Design logical and physical structures of the database, including storage parameters.
• Perform database tuning and manage both production and development environments.
• Plan, document, and implement new database management system software and release upgrades upon company approval.
• Monitor the effectiveness and efficiency of database system operations and recommend and implement performance improvements for databases and user applications.
• Utilize table partitioning and table compression techniques.
• Use event monitors and snapshot monitors to regularly check database health.
• Write and maintain – Ansible Roles , shell scripts for automation and maintenance.
• Implement and maintain all procedures for backup and recovery of database management systems, including audit logs of all database activities.
• Experience with Ansible/PL1 , PostgreSQL know-how is an added advantage.

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026totaled $14.8billion.