Team Member-it Infrasupport Services - Mumbai, Maharashtra, India - Kotak Mahindra

Kotak Mahindra

Verified Company

Mumbai, Maharashtra, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Confidential Kotak Mahindra Bank Limited

Role:
Database Administrator (24x7)

Reporting to:
Head - Database admin

Role & Responsibilities:

Managing and monitoring of all the Oracle, Sybase, Ms-Sql, MySQL, Mongo and Db2 databases, Management of all SRs, PMRs and calls.
Project initiation and execution as per business requirement
Data replication with minimum lag at DR site; Keeping DR databases up to date
Performance tuning of the databases
Ensuring that all the databases backup taken and health check maintained
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

Database administrators
Unix system administrators
Windows system administrators
Storage administrators
IT operation team
IT Projects Team
Application Support Teams
Application vendor teams
Respective Project Managers
End Users
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