Infrastructure Engineering I-SUPPORT SERVICES-CTO - In House Engineering

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 new
skill set
Prepare & do presentations during
datacenter meetings