Description

Confidential Kotak Mahindra Bank Limited

Role: Database Administrator (24x7)

Reporting to: Head – Database admin

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 Indicators (KPIs) :

S/N

Key performance Indicator*

Performance Measures

Weightage

1

99.5% uptime for all the Oracle, Sybase, MySQL, Ms-Sql, Mongo and Db2 databases.

Downtime/outage reporting - daily & monthly reports

30

2

Ensure 100% backup for all the databases, Designing appropriate Database backup policy

Daily report, Successful restorations (periodic/as per business requirement) – monthly report

20

5.

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)

20

4.

Database management and support within budgeted cost

Cost saving. Review of billing details

10

5

Security. Audit and ISO recommendation implementation for all the databases

VA reports. ISO/Audit reports & findings

10

6

Patch management

Database event monitoring report,

10

Confidential Kotak Mahindra Bank Limited

Monthly report

* Note more than 6

Other Key Performance Indicators:

Area Details Measurement Criteria

Operations Ensure uptime for DB systems Daily uptime report

Handle deliverables in co-ordination

with vendor who provides managed

services so that SLA can be met

Deliverables / SLA

Resource scheduling for onsite dba

services

Shift Schedule

Ensure that no system release delay

due to DB error

Daily reports/Checklist

Tracking eod & bod status using

application tables for critical systems

Daily report

Archive log volume tracking Daily report

Monitor space at database level space details report

Review alert & error logs; corrective

action in case of any error





Daily report

Monitor various application jobs,

services & corrective action/escalation

against failure

Mails

Measure hit ratios and protect against

threshold values

Performance sheet

Ensure escalations 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

Mails

Ensure synchronization for all standby

databases at local & DR with minimal

lag

standby status report

Measure database growth and share

the trend

Monthly report

Ensure analyze/gather stats for

performance optimization

checklist

Data movement to history tables mails

Ldap db2 reorg activity in TAM setup of

netbanking

mails

Automation of jobs up to best possible

extent

mails/shell scripts

Raise SR/PMR with product companies

for internal errors/problems and followup

until closure

SR/PMR details on mail

Handle 2nd level escalations 24*7 for

all RDBMS

mails/phone calls

Ensure appropriate documentation Process manuals, SOPs,

Confidential Kotak Mahindra Bank Limited

checklists, reports, system

study, escalation matrix

Proactive communication with internal

customers

mails

Identify root cause of the problem and

implement permanent solution

Root cause analysis

Manage the emails/phones efficiently

and ensure no email/call is ignored or

unattended

Mails

Manage quality kiosk’s alerts / sms,

Monitoring mails and alerts efficiently

Mails

Attend weekly meetings with project

team and allocate resources as per

discussion

MOM

Updation of major activities sheet on

regular basis

Major activities list

Ensure appropriate action plans and

seamless execution for special tasks

Action plans, Number of

special tasks

Publish / share notices for desupported

versions of Databases and

insist for upgrade to latest/supported

version

Communication/coordinatio

n on mails

Backups

Backups as per standard policies and

business requirement

Backup report

Data restoration using tape backups as

per application and business

requirement

Mails/Approvals

Configuration of backups for new

databases

Mails

Identification of backups taking more

time and tuning those up to the best

possible way

Mails

Escalation for capacity planning to the

management

Mails

Scheduling of Special and other adhoc

backups

Mails

Re-verification of backup validity Test restorations

Backup of Uat & Dev environments

Backup of user segments

Patch





management

Ensure all patches coming from

Application team are applied on

databases and output is provided to

them

mails / monthly reports

Handle data requests for all databases mails / monthly reports

RDBMS version upgrade patches on

databases

mails / monthly reports

Confidential Kotak Mahindra Bank Limited

Bug fixing patches mails / monthly reports

Maintenance

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

license details

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 /

DB upgrade to supported/latest version Number of dbs upgraded,

email communication to

ensure necessary follow-up

Support for UAT & Development

databases

Confidential Kotak Mahindra Bank Limited

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 recent

skill set

Prepare & do presentations during

datacenter meetings

📌 Infrastructure Engineering I-SUPPORT SERVICES-CTO - In House Engineering (Thane)
🏢 Important Group
📍 Thane