Oracle DBA_2051

Job Responsibilities

Database Performance & Optimization:

• Advanced knowledge of Oracle Database Architecture
• Perform advanced SQL tuning, indexing, partitioning, and query optimization.
• Use AWR, ASH, SQL Profiles, and SQL Baselines to troubleshoot performance issues.
• Optimize memory, CPU, and storage configurations for Exadata, Oracle RAC, and Cloud environments.

OS Basic (Linux RedHat/Oracle), Storage Basic concepts, Networking Basic concepts

High Availability & Disaster Recovery

• Maintain Data Guard, Oracle RAC and RMAN-based backup/recovery strategies.
• Ensure zero-data-loss disaster recovery using Flashback Technology, Snapshot Standby.

Conduct disaster recovery (DR) drills and failover testing for compliance.

Automation & DevOps Integration

• Develop and manage DB automation scripts (Shell, Ansible, Python) for operational tasks.
• Use OEM Cloud Control for database monitoring & alerting.

Leadership, Documentation & Stakeholder Management

• Mentor colleagues within the squad and provide technical leadership for database arena.
• Maintain runbooks, SOPs, and knowledge base for database operations.
• Collaborate with infrastructure Squad for seamless database integration.
• Act as a trusted advisor for customer, providing structured communication on technical requirements and queries.
• Information Security Responsibilities:

All employees are expected to adhere to the Information Security policies day in and day out.

• Report any ISMS events / incidents as per the reporting procedures.
• Shall be aware of all ISMS principles and guidelines
• Database Backup and Recovery

Qualification, Experience And Skills

Qualification : Any Bachelor Degree

Experience : 10+ years relevant experience

Skills : Oracle Database administration

Knowledge of SQL, PL/SQL

Shell scripting, Ansible,

Performance Tuning

High Availability (HA) and Disaster Recovery (DR) options for Oracle Database

Certification : OCP,OCI Certifications

A fundamental grasp of AI tools will be an added benefit.

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.

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. And the foundation for this is our inclusive workplace, where people and performance both matter, and nurtures a culture grounded in integrity, fairness, inclusion and trust.

We therefore welcome applications regardless of 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 Executive employees across functions, Allianz entities and geographies. Therefore, the company expects from its employees a general openness and a high motivation to regularly change positions and collect experiences across Allianz Group.