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 offer a hybrid work model which recognizes the value of striking a balance between in-person collaboration and remote working incl. up to 25 days per year working from abroad 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. We oversee the full digitalization spectrum – from one of the industry’s largest IT infrastructure projects that includes data centers, networking and security, to application platforms that span from workplace services to digital interaction. In short, we deliver full-scale, end-to-end IT solutions for Allianz in the digital age. D&I statement Allianz Technology is proud to be an equal opportunity employer encouraging diversity in the working environment. We are interested in your strengths and experience. We welcome all applications from all people regardless of gender identity and/or expression, sexual orientation, race or ethnicity, age, nationality, religion, disability, or philosophy of life. Join us. Let´s care for tomorrow. You. IT 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. We at Allianz believe in a diverse and inclusive workforce and are proud to be an equal opportunity employer. We encourage you to bring your whole self to work, no matter where you are from, what you look like, who you love or what you believe in. We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, disability or sexual orientation. Join us. Let's care for tomorrow. Show more Show less
