Oracle Database Administrator

Responsibilities :

- Ensure proper housekeeping is carried out to avoid outage

- Daily report

- Initiation of tuning for various application in coordination with respective Application owner

- Mails

- Periodic health check review and parameter tuning of databases statspack/awr/monthly reports

- Creation of various test setups to test application tuning as per requirement

- Mails

Audit and Compliance :

- Implementation of baseline hardening & closure of security finding from DB point of view

- CA/VA report

- Handling of various internal and external audits

- Mails, audit reports

- Ensure closure of all audit findings for databases

- Mails, audit reports

- Maintain up-to-date db inventory along with all details inventory

- Reconcile & maintain record of rdbms licenses

- Ensure appropriate documentation and certify for ISO 270001 surveillance audit

- CM forms, Third party access forms, privileged user details, access control matrix, audit report

- Adherence to processes and policies

- Ensure closure of pending VAs and CAs IT security dashboard

- Maintain all necessary records for audit purpose

- Access control matrix, evidences, etc.

- RBI audit Mails, audit reports

Reports :

- Ensure all checklists received from database admin team

- Daily checklists

- Monthly report to Senior Mgmt by 2nd of every month

- Monthly report

- Database uptime report for critical applications

- Daily report

- Publish performance gain reports wherever tuning is done by/as per app dba

- Timely update in Major activity report

Projects :

- Support for UAT & Development databases

- Oracle license utilization tracking

- Execution of projects initiated by project team

- Close known vulnerabilities proactively

- Maintain & Update Documentation ops manuals, sop, exceptions, deviations, stop/start services

Soft skills :

- Coordination with various teams for day to day operations

- Understand application & business requirement

- Quick response time

- Reports in neat and accurate format

- Working and interacting with others to accomplish team goals

- Express ideas and concerns clearly

- Team meetings and knowledge sharing sessions as per predefined frequency

- Learn new technologies, acquire new skill set

- Prepare & do presentations during datacenter meetings