Verified Job
IT / Software / Data Analyst
Oracle DBA L3
IT / Software / Data Analyst
#250705
Remote / WFH
Job Description
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
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
