Team Member-it Infrasupport Services

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.

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

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

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 mínimal 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 follow-up 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

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 de-supported versions of Databases and insist for upgrade to latest/supported version

Communication/coordination on mails

Backups

Backups as per standard policies and business requirement

Backup report

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 Ap