Oracle Dba L2 - Mumbai - Netmagic It @ Netmagic It Services

• 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 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