L2 Oracle Database Administrator - Oracle RAC Module

Job Description :

- Takes up technical tasks and support day to day BAU tasks/Incidents/RFCs.

- Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.

- Proposes service improvements for all Oracle/EBS services supported throughout the organization.

- Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.

- Works in line with policies based on LEAN-CA-CIB best practices.

- Actively engages during any high severity issue and drives for issue resolution.

- Reviews technology changes to identify potential risks.

- Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.

- Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.

- Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects.

- Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.

- Guarantees the production readiness.

- Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role.

- Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.

Key Responsibilities :

Technical Expertise :

Must Have Skills :

- Should be strong experience in Oracle RAC and Data guard

- Should have working experience on 12c,19c and above Pluggable and Container databases.

- In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM).

- Installation, Upgrade & configuration of Oracle software.

- Should have knowledge of Oracle RAC installation and configuration & management.

- Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc.

- Must have good Handson experience with patching (Database/GRID)

- Must have Oracle ASM/ACFS implementation skills.

- Strong experience on configure and troubleshoot physical standby database using dataguard broker.

- Expertise on backup utilities like RMAN, EXPDP/IMPDP, and Networker.

- Implement backup and recovery of Oracle databases for various scenarios.

- Proven experience with Databases auditing

- Should have knowledge of Oracle OEM 12C/13C.

- Administration over DB Objects including Tables, Clusters, Views, Procedures etc.

- Good understanding of core support processes and change management, maintain documentation standards.

- Capable of delivering under critical environment pressure, resolve complex production issues & provide support when required.

- Proven track record for BAU tasks

- Excellent verbal and written communication skills;

- Good understanding of UNIX/Python/shell/Ansible scripts.

- Independent and strong team player with good inter-personal skills.

Good to Have Skills :

- Banking/Financial domain experience

- Exadata/Exacc Administration

- Knowledge on OCI,DBASS utilities

- Exacc patching (DOM0,DOMU)

- Good scripting(shell/ANSIBLE/PYTHON) skills to automate regular DBA admin tasks.

- Oracle EBS knowledge/experience added advantage.

- Strong experience on configures and troubleshoot golden gate replication components.

- EBS Administration

- Installation, Upgrade & configuration of EBS.