Team Member-it Infrasupport Services

2 days ago

Thane, India Kotak Mahindra Full time

**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.

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

  • Team Member-it Infrasupport Services

    6 days ago

    Thane, India Kotak Mahindra Full time

    Network Team Member Job Description - Department- Information Technology- Location- Mumbai- Number of Positions- 1- Reporting Relationships- Senior Vice President- Position Grade- Associate Vice President- Support in driving Vendor onboarding list basis regulations. Finalizing vendor risk scorecard basis various risk parameters for 300+ vendors - Manage...

  • Team Member-it Infrasupport Services

    6 days ago

    Thane, India Kotak Mahindra Full time

    **Job Role: DC Monitoring, Patching & Project managemen**: - **Job Requirements**: - 5 Years as working on Infrastructure monitoring, patching & automation products preferably BMC products (TSOM, TSA, Discovery). - End to end life cycle of managed environments (manage from and to) covering installation, configuration, management, support and...

  • Team Member-it Infrasupport Services

    2 days ago

    Thane, India Kotak Mahindra Full time

    **Grade **:M3/M4 **Year of Experience**: 4 to 8 Years **Location : - **Mumbai **Job Description: Summary: Overseeing and performing front line adherence to the Kotak Bank’s ‘IT Risk and Control Framework’. Maintaining an independent view of the material technology risk, information security risk, information management risk, third-party risk, and...

  • Team Member-it Infrasupport Services

    2 days ago

    Thane, India Kotak Mahindra Full time

    **Job Description**: **JD For Linux**: - Installation of most common Linux flavors i.e. RHEL, Ubuntu - Implementing security measures and patching for OS. - Ability to configure and manage SAN boot disk as well as physical servers. - Ability to mitigate active system problems by understanding their nature and implementing resolution steps. - Understanding...

  • Team Member-it Apps Ctbsupport Services

    2 weeks ago

    Thane, India Kotak Mahindra Full time

    Personality TraitsTeam player - Salary range: - **(CTC) Rs.12 lakhs - Target Companies- Banking Sector Companies i.e. HDFC Bank, ICICI Bank, AXIS, YES Bank**Job Title** **Project Manager / Team Member** **Level** **M3** **Division** **IT** **No of positions** **1 - Job Role- Team Leader - IT Applications (Compliance & Infrastructure Facility)**Job...

  • Team Member-it Securitysupport Services

    2 days ago

    Thane, India Kotak Mahindra Full time

    Job Title: ServiceNow Developer **Job Description**: As a ServiceNow Developer at Kotak Mahindra Bank Ltd, you will be responsible for developing and customizing solutions on the ServiceNow platform to meet the unique needs of our organization. This role will require expertise in ServiceNow development, a strong understanding of IT service management, and...

  • Team Member-it Apps Ctbsupport Services

    4 days ago

    Thane, India Kotak Mahindra Full time

    **Role**:Squad lead/Agile PM/Tech Manager **Functional Area**:Technical project manager/Scrum Master/Squad lead **Relevant experience: 7-10 years **Roles & Responsibilities**: - Will be responsible for managing one of the squads for Salesforce implementation under K-Force Service Transformation project. - Define project scope and schedule while focusing...

  • Team Member

    1 week ago

    Talegaon, Thane, Maharashtra, India The Brand Landmark Full time

    **Position**: Team Member **Location**: [Talegaon] **Job Type**: Full-time - Part-time **About Waffle Castel**: Waffle Castel is a rapidly growing food brand, known for serving freshly prepared waffles and desserts with an unforgettable customer experience. Our vision is to deliver high-quality products with excellent service. **Key Responsibilities**: -...

  • Team Member

    2 days ago

    Thane, India 1441 Pizzeria Full time

    **Duties & Responsibilities**: Should be keen to make pizzas, take orders, and serve customers. Handling cash efficiently. Cheerfully greeting guests as they arrive and interacting with them. Following consistent standard operating procedures that positively impact the restaurant's overall operations. Achieving highest customer satisfaction ratings by...

  • Team Member

    1 week ago

    Thane, India Sapphire Foods Full time

    Join Our Team at KFC Thane!Positions Available: Blue Collar Staff (Full-time & Part-time)Are you ready to be a part of a fast-paced team and work with one of the leading brands in the QSR industry? KFC is hiring for full-time and part-time positions in Thane. Whether you are looking for steady income or flexible hours, we have opportunities for you!Positions...