Celtic Management Services
Position Title : Oracle Database Administrator L2
BAND
Location : Mumbai , India
Department Middleware
Shift/Oncall & Weekend Support
Flexible to work in shifts/ weekends/On-Call support as follows:
Shift Timings
- Morning Shift 4.30AM to 1.30PM
- Afternoon Shift 11.30AM to 8.30PM
- Afternoon Shift 1 12.30PM to 9.30PM **
- Evening Shift 2.30PM to 11.30PM
- Evening Shift 1 3.30PM to 12:30AM **
** Day light savings Period- Nov to Mar ( 1hour ahead)
** On-Call Support- To provide On-Call support services on rotational basis
- · 11.30 PM Night to 4.30 am on weekdays after end of the evening shift work (Apr to Oct).
- · 12.30 Midnight to 4.30 am on weekdays after end of the evening shift 1 shift work (Nov to Mar).
- · 00:00 AM to 11:59PM on both Saturday and Sunday
- · Weekend Support – Mandatory to work on every 3rd Saturday of given month. ( Timings From time to end time to be mentioned )
Public Holiday Support – Paris Holidays (Client Holiday) will be followed as public holidays and not India holidays.
Role Summary
As a L2 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-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
- RAC/Exadata/Exacc Administration
- 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 understanding of 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 Skills
- 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
- Banking domain experience will be added advantage · Installation, Upgrade & configuration of EBS.
Process & Tools
- ITSM tool- HP Service Now – Ticketing tool for INC/SR/Change/Problem tickets
- In-house tools · HP OMI for monitoring
- Strong knowledge on ITIL Process & Practices
Educational Qualifications
Bachelor’s degree or Master’s degree in Information/Computer technology preferred
Key Competencies:
- 5yrs (Min) to 8yrs (Max) of relevant experience in Oracle.
- The candidate should have worked in a SLA driven environment.
- Ability to work in a flexible, team-oriented and constantly changing environment.
- Good Oral and Written communication skills.
- Basic knowledge on shell/Python scripting.
- Having Oracle RAC/OCI certification will be added advantage.
- Having previous banking BAU support will be added advantage.