Job Description

Position Title

Oracle Database Administrator L2

BAND

Location

India

Department

Middleware

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

·         Architect HA and DR Solutions for PAAS services like Exadata, Autonomous Databases (ATP,ADW),

 RAC & Data guard).

·         Installation, Upgrade & configuration of Oracle/EBS software.

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

·         Must have Oracle ASM/ACFS implementation skills.

·         Good scripting skills to automate regular DBA admin tasks.

·         Expertise on backup utilities like RMAN, EXPDP/IMPDP, CRSCTL, SRVCTL, Netbackup and Networker.

·         Patching of Oracle DB/EBS Apps (EXACC and Non-EXACC DB). 

·         Good understanding on performance tuning in Oracle database.  

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

·         He will be customer facing for all operational issues and activities.

·         Should have capability to install and configure RAC Servers under Oracle DB and EBS Apps technology.

·         Expertise in query fine tuning and troubleshooting.

·         Implement backup and recovery of Oracle DB/EBS Apps.

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

·         Good in Impact Analysis of DB Change / DB Design Change etc.

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

·         Strong experience on configure and troubleshoot golden gate replication components.

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

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

·         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 (EBS, Database, EXACC and RAC), patches, SR support, database tuning,

concurrent manager administration, cloning

Oracle EBS knowledge/experience added advantage.

·         Capable of delivering under critical environment pressure, resolve complex production issues & provide support when required;

·         Excellent verbal and written communication skills;

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

Shift/Oncall & Weekend Support

Flexible to work in shifts/ weekends/On-Call support as follows:

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

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/EBS administration.

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