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