Db2 Database Administrator_1941

Allianz; Italia; In loco; EUR 55.000 - 75.000; Tempo pieno

Descrizione del lavoro

Allianz is recruiting a DB2 Database Administrator to join the Italy team. The role involves creating databases, managing backups, and tuning performance for production and development environments.

You will collaborate with developers and work on IBM DB2 PureScale initiatives while upskilling in automation and scripting. Requirements include 1–2 years of DB2 UDB DBA experience, hands-on DB2 utilities, and a strong foundation in Linux/UNIX systems.

Competenze

• University degree is mandatory.
• 1–2 years of DB2 UDB DBA experience is required.
• Experience with DB2 on Linux/UNIX and related utilities is essential.
• Willingness to upskill in DB2 PureScale and automation with Ansible/shell scripting is expected.
• Experience with backup/recovery, performance tuning, and monitoring is important.

Mansioni

• Create databases and tables per developer requirements.
• Work on Ansible/Purescale implementations with IBM DB2.
• Perform automation and process improvements with respect to database management.
• Manage backups, security, and access controls for databases.
• Troubleshoot DB2 incidents at L2-L3 level and engage vendor support as needed.
• Restore databases and application servers when required.
• Monitor storage, I/O performance and tune DB2 for production and development environments.
• Plan and implement database software upgrades with approvals.

Conoscenze

DB2 UDB DBA

Linux/UNIX DB2

DB2 utilities

Performance tuning

Automation

Shell scripting

Formazione

University graduate degree

Strumenti

Ansible

COBOL

PL1

Descrizione del lavoro

DB2 Database Administrator_1941

Azienda : Allianz Tipo Lavoro : Full Time Italy

Descrizione Lavoro - DB2 Database Administrator_1941

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.