Oracle DBA - L2

Job Designation: Oracle DBA - L2

Department: Operations

Reporting To: Team Lead - Database administration

Work Shift: Rotational

Location: Mumbai


Primary Responsibility:

  • 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


Mandatory 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


Typical Years of Experience:

  • 3+ relevant years of experience


Mandatory Skills:

  • Good communication skills and motivated
  • Team Player



Join Netmagic

Send us your profile and resume at careers@netmagicsolutions.com