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

Job 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. • 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 • 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 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 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 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 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 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 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