You will
- 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 heavily preferred (along with work experience)
- Create databases and tables as per requirements from application developers.
- 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.
- 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.
- Support Allianz Deutschland project, and take on a full-time role for the ABSd project -migration.
Your skills
- University graduate degree (mandatory).
- 8-10 years of relevant experience as a DB2 UDB DBA.
- 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
- 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.
- Basic knowledge in AI tools will be add on advantage.
Allianz Group is one of the most trusted insurance and asset management companies in the world. 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.