Allianz

Oracle DBA_2051

Allianz  •  Pune, IN (Onsite)  •  26 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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.

Allianz

About Allianz

The Allianz Group is one of the world's leading insurers and asset managers with more than 100 million private and corporate customers in nearly 70 countries. We are proud to be the Worldwide Insurance Partner of the Olympic & Paralympic Movements from 2021 until 2032 and to be recognized as one of the industry leaders in the Dow Jones Sustainability Index.

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. Join us and together, let’s care for tomorrow.

Credits: https://www.allianz.com/en_GB/credits-allianz-se.html

Follow us on:

Twitter: twitter.com/Allianz

Instagram: https://www.instagram.com/teamallianz

Facebook: https://www.facebook.com/AllianzCareers

Glassdoor: https://www.glassdoor.de/%C3%9Cberblick/Arbeit-bei-Allianz-EI_IE3062.11,18.htm

Allianz Data Privacy Statement for Social Media:

https://www.allianz.com/en/privacy-statement.html#social-media

Allianz Careers Data Privacy Statement: https://careers.allianz.com/en_EN/footer/data-privacy.html

LinkedIn Privacy Policy: https://www.linkedin.com/legal/privacy-policy

LinkedIn General Terms: https://www.linkedin.com/legal/user-agreement

Industry
Finance & Insurance
Company Size
10,000+ employees
Headquarters
Munich, DE
Year Founded
Unknown
Social Media