Job
Description
DB2 DBA You will Create databases and tables as per requirements from application developers. Modify the database structure according to company standards, based on inputs from application developers. Manage backups, security, and controls of databases. Enroll users and maintain system security. 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 PL/1 or COBOL programming (added advantage). Support ABSi project, participate actively in migration phases to the Allianz Deutschland project, and take on a full-time role for the ABSd project post-migration. Willingness to upskill and work in DB2 PureScale technology. Your skills University graduate degree (mandatory). Minimum of 4 years of relevant experience as a DB2 UDB DBA. Experience with relational database management systems, specifically DB2 Data Server 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. Your benefits: We believe in rewarding performance and our compensation and benefits package includes a company bonus scheme, pension, employee shares program and multiple employee discounts (details vary by location) From career development and digital learning programs to international career mobility, we offer lifelong learning for our employees worldwide and an environment where innovation, delivery and empowerment are fostered Flexible working, health and wellbeing offers (including healthcare and parental leave benefits) support to balance family and career and help our people return from career breaks with experience that nothing else can teach About Allianz Technology Allianz Technology is the global IT service provider for Allianz and delivers IT solutions that drive the digitalization of the Group. With more than 13,000 employees located in 22 countries around the globe, Allianz Technology works together with other Allianz entities in pioneering the digitalization of the financial services industry. D&I statement Join us. Let s care for tomorrow. You. IT
