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