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.
MUST HAVES
- 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 etc
- 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 HAVES
- 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
Shift and Weekend work is expected for this role. Shortlisted applicants can discuss further on the details.
- Morning Shift 7AM to 4PM
- Afternoon Shift 2PM to 11PM / 3PM to 12AM
- Evening Shift 4PM to 1AM / 5PM to 2AM