Information Security I-SUPPORT SERVICES-CTO - Support Services

Kotak Mahindra Bank; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Kotak Mahindra Bank Limited is seeking an experienced Database Administrator for a 24x7 role in Mumbai. You will manage Oracle, Sybase, Ms-Sql, MySQL, Mongo and Db2 databases, monitor performance, coordinate DR site replication, and ensure backups and health checks are in place.

Reporting to the Head of Database Admin, you will drive SQL tuning, vendor liaison, and incident management with outsourced DBAs and IT teams to keep critical systems available and secure.

Responsibilities

• Managing and monitoring of Oracle, Sybase, Ms-Sql, MySQL, Mongo and Db2 databases
• 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
• Vendor management for handling database problem/escalation/application support
• Outsourced DBAs coordination and DR/production support

Job 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. 12 RTB (Run the Bank) Support Team
13. 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
3. 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. 4. Database management and support within budgeted
   cost
   Cost saving. Review of
   billing details
   10
5. 5 Security. Audit and ISO recommendation
   implementation for all the databases
   VA reports. ISO/Audit
   reports & findings
   10
6. 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
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

Requirements: