Oracle DBA

Location: Chennai

Core Responsibilities

Administer and support Oracle databases across production and non-production environments.

Manage and troubleshoot Oracle RAC Data Guard ASM and Grid Infrastructure.

Perform SQL and database performance tuning using AWR ASH and execution plan analysis.

Execute backup recovery and recovery validation using RMAN.

Implement Oracle security controls including access management TDE and SQL encryption.

Perform database and Grid Infrastructure patching and upgrades using OPatch OPatchAuto DataPatch and Release Updates.

Support database migrations platform upgrades refreshes and cloud transformation initiatives.

Develop and troubleshoot SQL PL/SQL Shell and automation scripts.

Support incidents root cause analysis change execution and problem management.

Maintain runbooks and standards and drive automation and continuous improvement.

Platform / Technical Scope

Oracle Database 12c 19c and 21c

Oracle RAC Data Guard ASM and Grid Infrastructure

RMAN and Oracle Enterprise Manager (OEM)

SQL PL/SQL TDE and Oracle security

OPatch OPatchAuto DataPatch and Release Updates

Red Hat Enterprise Linux and Oracle Linux

AWS Azure or OCI experience preferred

R

Areas of responsibility

Triaging and resolution of tickets-Perform initial triage for high priority incident tickets (P2 tickets) which may have an impact across one or more processes and resolve priority incident (P3) tickets within defined SLAs.

Create log of incidents and Document observations and related root causes to support in evaluation of mitigation measures.

Resolution of service Requests-Fulfil software/hardware/network service requests within agreed timeline ensuring timely completion and adherence to SLAs while maintaining quality and accuracy in request handling.

SLA Monitoring-Monitor SLA timelines for entire lifecycle of high priority incident tickets (P2 tickets). Escalate as needed and participate in weekly or monthly service review meetings with clients and internal teams.

Change request execution-Create change requests as per the priority of the incident tickets in adherence with the defined guidelines.

Present changes for approval with rollback plans in change approval meetings. Execute approved changes and document post-implementation outcomes.

Incident Analysis-Analyse nature of incidents to support root cause analysis and related service improvement plans.

Contribute towards development of mitigation action to reduce repeat incidents by identifying patterns of issues noted.