Oracle Database Administrator

Role: Oracle Database Administrator (24x7)

Location: Mumbai/ Navi Mumbai

Years of Experience: 8 to 14 Years

Role & Responsibilities:

1. Managing and monitoring of all the Oracle, Sybase, Ms-Sql, MySQL, Mongo and Db2 databases, Management of all SRs, PMRs and calls.

2. Project initiation and execution as per business requirement

3. Data replication with minimum lag at DR site; Keeping DR databases up to date

4. Performance tuning of the databases

5. Ensuring that all the databases backup taken and health check maintained

6. Database hardening and version upgrade.

7. Vendor management for handling database problem/escalation/application support

Reporting Structure: who is reporting to you:

Outsourced DBAs (Oracle, Sybase, MySQL, Ms-Sql, Db2, Application dba, RAC Admin, Bangalore DBA Team and Oracle ACS Support.)

Interfaces: whom do you interact daily with

1. Database administrators

2. Unix system administrators

3. Windows system administrators

4. Storage administrators

5. IT operation team

6. IT Projects Team

7. Application Support Teams

8. Application vendor teams 9. Respective Project Managers

10. End Users 11. DRM Team

12 RTB (Run the Bank) Support Team

13 Cloud Support Teams.

Key performance Indicator*

• 99.5% uptime for all the Oracle, Sybase, MySQL, Ms Sql, Mongo and Db2 databases - Downtime/outage reporting - daily & monthly reports
• Ensure 100% backup for all the databases, Designing appropriate Database backup policy - Daily report, Successful restorations (periodic/as per business requirement) monthly report
• Continuous monitoring of the databases and its consistency, SR management, Database fine tuning to enhance performance - Daily checklist, Standby status report, Release of production and report databases. Performance report (hit ratios)
• Database management and support within budgeted cost- Cost saving. Review of billing details
• Security. Audit and ISO recommendation implementation for all the databases - VA reports. ISO/Audit reports & findings
• Patch management- Database event monitoring report

Other Key Performance Indicators:

• Ensure uptime for DB systems
• Handle deliverables in co-ordination with vendor who provides managed services so that SLA can be met
• Resource scheduling for onsite dba services
• Ensure that no system release delay due to DB error
• Tracking eod & bod status using application tables for critical systems
• Archive log volume tracking
• Monitor space at database level
• Review alert & error logs; corrective action in case of any error
• Monitor various application jobs, services & corrective action/escalation against failure
• Measure hit ratios and protect against threshold values
• Ensure scalations are triggered on time and to the appropriate persons
• Identification of area where further tuning/enhance is require to smoothen the DB management and ensure corrective action
• Ensure synchronization for all standby databases at local & DR with minimal lag
• Measure database growth and share the trend
• Ensure analyse/gather stats for performance optimization
• Data movement to history tables
• Ldap db2 reorg activity in TAM setup of netbanking
• Automation of jobs up to best possible extent
• Raise SR/PMR with product companies for internal errors/problems and follow up until closure
• Handle 2nd level escalations 24*7 for all RDBMS
• Ensure appropriate documentatio
• Proactive communication with internal customers
• Identify root cause of the problem and implement permanent solution
• Manage the emails/phones efficiently and ensure no email/call is ignored or unattended
• Manage quality kiosks alerts / sms, Monitoring mails and alerts efficiently
• Attend weekly meetings with project team and allocate resources as per discussion
• Updation of major activities sheet on regular basis
• Ensure appropriate action plans and seamless execution for special tasks
• Publish / share notices for de supported versions of Databases and insist for upgrade to latest/supported version

Audit and compliance:

• Implementation of baseline hardening & closure of security finding from DB point of view
• Handling of various internal and external audits
• Ensure closure of all audit findings for databases
• Maintain up-to-date db inventory along with all details
• Reconcile & maintain record of rdbms licenses
• Ensure appropriate documentation and certify for ISO 270001 surveillance audit
• Adherence to processes and policies
• Ensure closure of pending VAs and CAs
• Maintain all necessary records for audit purpose
• RBI audit

Patch management:

• Ensure all patches coming from Application team are applied on databases and output is provided to them
• Handle data requests for all databases
• RDBMS version upgrade patches on databases
• Bug fixing patches

Backups:

• Backups as per standard policies and business requirement
• Data restoration using tape backups as per application and business requirement
• Configuration of backups for new databases
• Identification of backups taking more time and tuning those up to the best possible way
• Escalation for capacity planning to the management
• Scheduling of Special and other adhoc backups
• Re-verification of backup validity
• Backup of Uat & Dev environments
• Backup of user segments

Maintenance:

• Ensure proper housekeeping is carried out to avoid outage
• Initiation of tuning for various application in coordination with respective Application owner
• Periodic health check review and parameter tuning of databases
• Creation of various test setups to test application tuning as per requirement

Projects Support:

• DB upgrade to supported/latest version - Number of dbs upgraded, email communication to ensure necessary follow-up
• 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.

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

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 data center meetings