SME - IBM DB2 for z/OS (163545)

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.

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

Other Requirements