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.
• Write and maintain Perl and 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).
• Minimum of 1-2 years of relevant experience as a DB2 UDB DBA.

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.
• Manage backups, security, and controls of databases.
• L2-L3 level troubleshooting of Database related incidents is essential.
• 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.
• 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.
• Experience with Ansible/PL1 or COBOL programming (added advantage).
• Your skills .
• Experience with relational database management systems, specifically DB2 Database on Linux and UNIX.
• 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, Visual Explain, and Design Advisor tools.
• Strong skills in DB2 performance tuning and database monitoring using IBM Data Management Console or equivalent tools.
• 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.