DB2 Database Administrator_1941

Role overview

DB2 Database Administrator_1941 at Allianz

Responsibilities

• You will .
• Monitor and optimize database performance.
• Manage storage and I/O performance issues related to databases.
• Perform database tuning and manage both production and development environments.
• Monitor the effectiveness and efficiency of database system operations and recommend and implement performance improvements for databases and user applications.
• 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.

Required qualifications

• University graduate degree (mandatory). 8-10 years of relevant experience as a DB2 UDB DBA.

Preferred qualifications and skills

• Know how in IBM DB2 Purescale Feature is heavily preferred (along with work experience).
• Extremely preferable if Purescale Feature of IBM DB2 is familiar and have work experience.

Employment details

• Location: India

Application details

• Create databases and tables as per requirements from application developers.
• Engage with application vendor support until problem resolution.

About the employer

• Support Allianz Deutschland project, and take on a full-time role for the ABSd project -migration.

Benefits

• Allianz Group is one of the most trusted insurance and asset management companies in the world.

Additional role details

• One of the best opportunity to work with one of the latest customer of IBM DB2 , with Purescale feature.
• Opportunities to work closely in Ansible / Purescale 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.
• Provide support for DB2 databases as per company procedures and policies.
• Restore databases and application servers when required.
• Design logical and physical structures of the database, including storage parameters.
• Plan, document, and implement new database management system software and release upgrades upon company approval.
• Utilize table partitioning and table compression techniques.
• Use event monitors and snapshot monitors to regularly check database health.
• Experience with Ansible/PL1 , PostgreSQL know-how is an added advantage.
• Your skills .
• Experience with relational database management systems, specifically DB2 Database Adminstration Linux.
• Know-how in Ansible is essential inorder to write/customize existing playbooks (Intermediate-Advanced level preferable) .
• Shell scripting know-how – added advantage.
• 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.
• Basic knowledge in AI tools will be add on advantage.
• Caring for our employees, their ambitions, dreams and challenges, is what makes us a unique employer.
• Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us.
• At Allianz, we stand for unity: we believe that a united world is a more prosperous world, and we are dedicated to consistently advocating for equal opportunities for all.
• And the foundation for this is our inclusive workplace, where people and performance both matter, and nurtures a culture grounded in integrity, fairness, inclusion and trust.
• We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations.
• Join us.
• Let's care for tomorrow.