Lead Administrator

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:

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.

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.

Oracle Database Admin