DB2 DBA- Performance Tuning_3085

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