Specialist-Application Operations_Specialist-Application Operations_D-1941
Pune, MH, IN
DB2 Database Administrator
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.
- 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 important.
- 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 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.
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. We are united by a shared commitment: to put our customers first and at the center of everything we do. Their needs inspire our thinking and guide our actions. Together, we can build an environment where everyone feels empowered and confident to explore, grow and shape a better future – for our customers and for 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. The foundation for this is our inclusive workplace, where people and performance both matter, and where integrity, fairness, inclusion and trust are at the heart of our culture. We therefore welcome applications regardless of race, 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.
Note: Having different strengths, experiences, perspectives and approaches is an integral part of Allianz‘ company culture. One means to achieve this is a regular rotation of Allianz employees across functions, Allianz entities and geographies. Therefore, Allianz expects from its employees a general openness and a high motivation to regularly change positions and collect experiences across Allianz Group.
