Specialist_Oracle DBA

Job description

This role would be responsible for project deliveries, which include environment build, application deployment, application patching/release, and release migration activities as part of life cycle. Also in addition, housekeeping & troubleshooting of the issues with respect to infrastructure (like database instances, oracle application server instances, WebLogic Administration,  Unix/Linux servers – used to host database, OAS), is also part of the responsibilities.

 

Individuals are expected to provide proactive support like performance monitoring, tuning advices, interaction with development team to improve the applications performance/ resolve issues.

 

·  Managing Oracle 11g and 12c, 19c databases on ExaCs, OCI, Oracle Linux and LINUX environments.
·  Performing all forms of database maintenance and administrative activities; installing, configuring, patching and upgrading Oracle server software, applications and related products.
·  Automating routine maintenance tasks as appropriate utilizing OEM, Shell scripting and PL/SQL batch processing;
·  Support the production environment on 11g,12c, 19c databases on Oracle Linux and RHEL.
·  Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
·  Manage, troubleshoot and resolve oracle database and applications issues.
·  Perform database and application tuning through the use of AWR and ADDM
·  Experience with Oracle enterprise manager 13c
·  Assist the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance.
·  Experience in RAC and Multi-tenant (CDB-PDB) environments and performance tuning as well.
·  Perform and develop the PL/SQL code for automation process.
·  Working knowledge of Exadata
·  Manager and troubleshoot and resolve Oracle database and Performance its issues.
·  Familiars with Cloud platform (preferred OCI, AWS, Azure)
·  Experience on WebLogic Administration – Forms and Reports
·  Exposure to PostgreSQL database administration is required

 

 

Must Have:

Qualification:

·  University Graduate degree (Btech, B.E)
·  Knowledge of ITSM tools like Service Now
·  Oracle Database Administration Certification
·  Linux Administration
·  Excellent command over written and spoken English (mandatory)
·  Good understanding of Network and Storage concept
·  ITIL Foundation certification (preferred)

Primary Skills :

 

·  Oracle 11g and 12c, 19c databases Administration on ExaCs, OCI, Oracle Linux and LINUX environments.
·  Installation, configuration, patching and upgrading Oracle database software, applications and related products.
·  Troubleshooting skills and resolve oracle database and applications issues.
·  Perform database and application tuning through the use of AWR and ADDM
·  OEM tool skills
·  Performance tuning and optimization
·  Perform and develop the PL/SQL code for automation process.
·  Working knowledge of Exadata
·  Familiars with Cloud platform (preferred OCI, AWS, Azure)
·  Experience on WebLogic Administration – Forms and Reports
·  Exposure to PostgreSQL database administration is required
·  Knowledge of SQL, PLSQL
·  Awareness of Unix / Linux platforms Change/Problem /Incident Management Process

 

Additional Skills:

·  Networking knowledge
·  Understanding of storage
·  Understanding of Windows, Linux systems
·  Understanding of scripting languages, Ansible, Shell etc
71820 | 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:

·        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 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 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