Oracle Exadata Database Administrator

As a dba resource of his /her team, he /she:

. Takes up technical tasks and support day to day BAU tasks/Incidents/RFC's.

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

MUST HAVE

. RAC/Exadata/Exacc Administration

. Oracle Apps DBA with expertise and working knowledge on R12.1.x / R12.2.x environment

. Sound Knowledge on 12c & 19c EBS databases along with RAC

. Troubleshooting knowledge on critical problems and areas like CM, Apache, Database et

. Knowledge on OCI,DBASS utilities

. Exacc patching (DOM0,DOMU,GRID,DATABASE)

. Installation, Upgrade & configuration of Oracle software.

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

. Must have Oracle ASM/ACFS implementation skills.

. Good understand of ANSIBLE/PYTHON/UNIX scripts .

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

. Good understanding on performance tuning in Oracle database.

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

. Expertise in query fine tuning and troubleshooting.

. Implement backup and recovery of Oracle DB.

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

. Good in Impact Analysis of DB

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

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

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

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

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

. Responsible for installation, upgrades (Database, EXACC and RAC), patches, SR support, database tuning.

. 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

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

GOOD TO HAVE

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

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

. Banking domain experience will be added advantage

. Automations