Objectives

DB2 Infrastructure Knowledge: Strong understanding of DB2 infrastructure components, including storage tuning, tablespace management, buffer pool configuration, and I/O optimization to ensure efficient resource utilization and sustained database performance.
AWS: Expertise on AWS concepts and managing servers hosted on AWS platform.
Performance Tuning and Optimization: Persistently observe database performance and undertake query tuning activities to boost efficiency. Detect and address performance bottlenecks through query optimization and resource distribution.
Health Monitoring and Troubleshooting: Utilize tools like AWS CloudWatch and Dynatrace to monitor database health. Diagnose and resolve database issues to reduce downtime and ensure seamless operations.
Collaboration with Application Team: Partner closely with the Application Team to support SQL-related tasks and optimize database queries. Aid in the integration of applications with DB2 LUW databases.
DB2 Migration: Experience with server migrations, stored procedures, triggers, and complex queries.
Backup and Recovery: Develop and manage backup strategies to safeguard data and ensure its availability. Conduct regular tests of recovery procedures to confirm that data can be swiftly restored in the event of a failure.
Security and Compliance: Establish security protocols to protect databases and ensure adherence to organizational policies and industry standards. Perform regular security audits and apply necessary patches to defend against vulnerabilities.
Coordination with Central Team: Work in tandem with the Central team to oversee AWS infrastructure and Dynatrace services, ensuring thorough management of database performance and health.
Knowledge and exposure in AI ,LLM.

Database Management and Maintenance: Supervise the functioning and upkeep of DB2 LUW databases to guarantee their reliability and effectiveness. Carry out regular database administration tasks, such as applying updates and patches

Qualification:

DB2 Expertise and Certification
SQL Knowledge
Linux Administration Skills
Performance Tuning and Optimization
Backup and Recovery Strategies
ITSM Tools Familiarity (e.g., ServiceNow)
Network and Storage Understanding
Strong Written and Spoken English
Collaboration and Communication Skills
Security and Compliance Awareness
Problem-Solving and Troubleshooting Abilities
ITIL Foundation Knowledge (Preferred)
AI knowledge preffered

Primary Skills :

DB2 LUW Administration (Versions 10.5, 11.1, 11.5)
DB2 z/OS Administration (Versions 11, 12, 13)
Installation, Configuration, Patching, and Upgrading DB2 Software
Troubleshooting and Issue Resolution
Database and Query Performance Tuning
Monitoring Tools Proficiency (e.g., AWS CloudWatch, Dynatrace)
Automation Scripting (e.g., Shell, Python)
Cloud Platform Familiarity (e.g., AWS, Azure)
Understanding of Network and Storage Concepts
Exposure to SQL and Advanced DB2 Features
Knowledge of Unix/Linux Administration
Change/Problem/Incident Management Process

Additional Skills:

Networking Knowledge
Storage Management Expertise
Proficiency in Unix/Linux Administration
Experience with Automation Tools (e.g., Ansible, Puppet)
Knowledge of Cloud Infrastructure (e.g., AWS, Azure)
Database Security Best Practices

Proficiency in Scripting Languages (e.g., Python, Shell)

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 11,000 employees located in 20 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

1 Job for Database Performance Tuning in India

Database Administration_3085