SME - IBM DB2 for z/OS Noida, Uttar Pradesh

Job Summary

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.

Duties and responsibilities • University graduate degree (mandatory).

• 5+ years of relevant experience as a DB2 UDB DBA with strong knowledge and handson in Purescale and Pacemakers.

• Experience with relational database management systems, specifically DB2 Database Administration Linux • Know-how in Ansible is essential inorder to write/customize existing playbooks (Intermediate-Advanced level preferable) • Shell scripting know-how – added advantage • Extremely preferable if Purescale Feature of IBM DB2 is familiar and have work experience • Experience working with GPFS feature (IBM Storage scale) is an added advantage.

• Expertise in running DB2 utilities such as Reorg, Runstats, Rebind, Export, Import, Load, Backup, Restore, and Recovery.

• Proficiency in database backup and recovery.

• Hands-on experience in database and SQL statement access plan optimization using DB2 Explain • Strong skills in DB2 performance tuning and database monitoring using Grafana or Dynatrace

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. Duties and responsibilities • University graduate degree (mandatory). • 5+ years of relevant experience as a DB2 UDB DBA with strong knowledge and handson in Purescale and Pacemakers. • Experience with relational database management systems, specifically DB2 Database Administration Linux • Know-how in Ansible is essential inorder to write/customize existing playbooks (Intermediate-Advanced level preferable) • Shell scripting know-how – added advantage • Extremely preferable if Purescale Feature of IBM DB2 is familiar and have work experience • Experience working with GPFS feature (IBM Storage scale) is an added advantage. • Expertise in running DB2 utilities such as Reorg, Runstats, Rebind, Export, Import, Load, Backup, Restore, and Recovery. • Proficiency in database backup and recovery.



• Hands-on experience in database and SQL statement access plan optimization using DB2 Explain • Strong skills in DB2 performance tuning and database monitoring using Grafana or Dynatrace

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 recent 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. Duties and responsibilities • University graduate degree (mandatory). • 5+ years of relevant experience as a DB2 UDB DBA with strong knowledge and handson in Purescale and Pacemakers. • Experience with relational database management systems, specifically DB2 Database Administration Linux • Know-how in Ansible is essential inorder to write/customize existing playbooks (Intermediate-Advanced level preferable) • Shell scripting know-how – added advantage • Extremely preferable if Purescale Feature of IBM DB2 is familiar and have work experience • Experience working with GPFS feature (IBM Storage scale) is an added advantage. • Expertise in running DB2 utilities such as Reorg, Runstats, Rebind, Export, Import, Load, Backup, Restore, and Recovery. • Proficiency in database backup and recovery. • Hands-on experience in database and SQL statement access plan optimization using DB2 Explain • Strong skills in DB2 performance tuning and database monitoring using Grafana or Dynatrace

Other Requirements

📌 SME - IBMfor z/OS (Noida)
🏢 HCLTech
📍 Noida