Oracle DBA L3

Designation / Position Title : Oracle DBA L3

Years of experience : 6-12 Years

Notice Period : Immediate to 15days

Working Mode: Work from Office

Shifts : Morning or evening shift - No night shift

Primary Responsibilities

· Work in a 24 X 7 Environment (NOC).

· Extend technical support to Clients over email and phone.

· Carry out the advance level of troubleshooting for databases

· Ensure that the tickets raised per shift are closed as per SLA and if not escalate as per the escalation Matrix defined

· Technically update the tickets in ticketing system for all the issues handled / worked upon

· Ensure that change requests are implemented as per defined timelines

· Following up with Vendors – whenever required & resolve issues by minimizing downtimes.

· Performance analysis of databases using native & monitoring tools.

· Carry out dB upgrades as and when required after approval from team lead / customer.

· Carry out one time implementations of databases as and when required as per Implementation Requests

· Work with intra departmental teams to isolate & troubleshoot customer issues (OS/Cloud/DB/Apps etc...)

· Ensure dB backups are happening regularly & report & act on failures immediately.

· Perform DR Drills L3 team.

· Timely execution of SIP related task allocated by Team lead

· Prepare pro-active performance reports

· Work towards automation of day to day tasks.

· Carry out patch updates at regular intervals & ensure you stick to the patching policy defined.

· Adhere to shift timings and shift handover process

· Prepared Incident Reports for S1 incidents (to be attached to RCA reports.

· Should be willing to learn, adapt & work on at least 2 different databases.

· Review Key L3 team in providing reports

Technical Skills

· Candidate should be well versed with all Oracle database administration activities for a variety of applications using, Oracle+i, 10g & 11g on various flavors of UNIX, LINUX and Windows environments

· More specifically, the activities will include database creation, configuring Standby/Data guard databases and RAC installation, migration and upgrade of oracle databases, database performance and tuning, implementation of backup/recovery scripts, RMAN, 24x7 support.

· Backup & Recovery procedures

· Expertise in supporting Oracle RAC

· Database performance tuning & monitoring tools

· Experience on High availability clustering

· Disaster-Recovery experience including Data guard Environment would be added advantage

· Basic Shell scripting

Oracle Certified Professional (OCP) would be an advantage