Job Description

Duties and ResponsibilitiesUnderstanding the requirement from each Customers and implement the solution as per service offering description and technical specification.Database Performance & Optimization:xc2xb7 Advanced knowledge of Oracle Database Architecturexc2xb7 Perform advanced SQL tuning, indexing, partitioning, and query optimization.xc2xb7 Use AWR, ASH, SQL Profiles, and SQL Baselines to troubleshoot performance issues.xc2xb7 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.

xc2xb7 Conduct disaster recovery (DR) drills and failover testing for compliance.xc2xb7 Automation & DevOps Integration:

• Use OEM Cloud Control for database monitoring & alerting.

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

xc2xb7 Experience : 10+ years relevant experiencexc2xb7 Skills : Oracle Database administrationxc2xb7 Knowledge of SQL, PL/SQLxc2xb7 Shell scripting, Ansible,xc2xb7 Performance TuningKey Competenciesxc2xb7 Cloud Platforms: OCI, AWS RDS for Oracle, ExaCSxc2xb7 Scripting Language: SQL, Shell Scripting, Ansiblexc2xb7 Monitoring Tool : Oracle Enterprise Managerxc2xb7 Databases: Oracle 19cxc2xb7 Database Features : Active Dataguard, Real Application Cluster (RAC) , Automatic Storage Management (ASM)xc2xb7 Security: TDE, Database Auditingxc2xb7 Request/Incident Tracking : Service Now, Jira73644 | IT & Tech Engineering | Professional | Allianz Technology | Full-Time | Permanent Warning: When posting this job advertisment on an external job board, the length of the following fields combined must not exceed 3950 characters: "External Posting Description", "External Posting Footer"Your benefits:xc2xb7 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 abroadxc2xb7 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)xc2xb7 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 fosteredxc2xb7 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 teachAbout Allianz TechnologyAllianz Technology is the global IT service provider for Allianz and delivers IT solutions that drive the digitalization of the Group. With more than 13,000 employees located in 22 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 statementAllianz 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. Letxc2xb4s care for tomorrow

Allianz