DB2 Database Administrator_1941

Allianz; India; On-site; INR 600,000 - 900,000; Full time

Job summary

Allianz Group is a leading global insurer and asset manager. This role involves hands-on DB2 administration, including creating databases, tuning performance, and implementing PureScale features with Ansible integrations.

You will work on backups, security controls, and incident troubleshooting, collaborating with developers and vendor support to ensure database health across production and development environments.

Qualifications

• University degree is mandatory.
• 1–2 years of relevant experience as a DB2 UDB DBA.
• Experience with DB2 on Linux/UNIX.
• Expertise in DB2 utilities and backup/recovery.

Responsibilities

• Create databases and tables per application requirements.
• Work on Ansible/Purescale implementations in IBM DB2 environment.
• Automate processes with shell and Perl scripts.
• Manage backups, security, and controls of databases.

Skills

DB2 UDB DBA

DB2 on Linux/UNIX

DB2 Utilities

Backup & Restore

Performance Tuning

Ansible

Shell scripting

Perl scripting

COBOL

PL/1

Education

University degree

Tools

DB2 Explain

Design Advisor

IBM Data Management Console

Job description

You will

• One of the best opportunity to work with one of the latest customer of IBM DB2 , with Purescale feature
• 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
• 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.
• 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 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.
• Experience with Ansible/PL1 or COBOL programming (added advantage).
• Support Allianz Deutschland project, and take on a full-time role for the ABSd project -migration.

Your skills

• University graduate degree (mandatory).
• Minimum of 1-2 years of relevant experience as a DB2 UDB DBA.
• 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.

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.