Oracle Database Administrator Netmagic Solutions✓Mumbai

Job Description

Primary Responsibilities:

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

• Extend technical support to Clients over email and phone.

• Carry out the advanced 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 the 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 under guidance of 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 parameters & assist L3 team in providing reports

Technical Skills :

• Candidate should be well versed with all Oracle database administration activities for a variety of applications using, Oracle9i, 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