Oracle Database Administrator_ 202

Duties and Responsibilities

Understanding the requirement from each Customers and implement the solution as per service offering description and technical specification.

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.

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: 

• Use OEM Cloud Control for database monitoring & alerting.

• Develop and manage DB automation scripts (Shell, Ansible, Python) for operational tasks.

·       Experience   : 10+ years relevant experience

·       Skills             : Oracle Database administration

·                              Knowledge of SQL, PL/SQL

·                              Shell scripting, Ansible,

·                              Performance Tuning

Key Competencies

·       Cloud Platforms: OCI, AWS RDS for Oracle, ExaCS

·       Scripting Language: SQL, Shell Scripting, Ansible

·       Monitoring Tool : Oracle Enterprise Manager

·       Databases: Oracle 19c

·       Database Features : Active Dataguard, Real Application Cluster (RAC) , Automatic Storage Management (ASM)

·       Security: TDE, Database Auditing

·       Request/Incident Tracking : Service Now, Jira

 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. 
We at Allianz believe in a diverse and inclusive workforce and are proud to be an equal opportunity employer. We encourage you to bring your whole self to work, no matter where you are from, what you look like, who you love or what you believe in.
We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, disability or sexual orientation.
Great to have you on board. Let's care for tomorrow.