Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Personal Details
Timeline

Deepak Bhagat

Database SME-Architect

Summary

Database Manager and Technical Architect leading Oracle database operations, architecture, and performance tuning for banking production environments. Directs Oracle RAC, ASM, and Data Guard work across 9+ database migration or upgrade projects per year, backup and recovery, security, and 30+ planned and executed DR drills per year that reduce DR switchover from 30 minutes to 5 minutes. Guides 21+ DBAs through audit readiness, low-downtime change execution, and production issue resolution.

Overview

3
3
Languages
2
2
Certifications
21
21
years of professional experience

Work History

Database Manager and Technical Architect

Tech Mahindra Limited
07.2024 - Current
  • Database Manager and Technical Architect for Banking customers with Team of 23 Oracle DBAs for Administration and Performance tuning.
  • Handled BAU and audit requirements, designed robust architecture for migrations and server upgrades.
  • Successfully Completed cross-platform migrations for databases.
  • Managing Team of DBAs for production implementations and new requirements.
  • Managed database architecture design and implementation to enhance data accessibility.

Database Team Lead

Tata Consultancy Services Limited
01.2014 - 07.2024

Database Team Lead of 14 Oracle DBAs for Administration and Performance tuning.

  • Complete Database Migration from Old storage to new storage at DC and DR sites.
  • Executed core banking server migrations from old hardware to Oracle M8, S7 servers, planning app/web/db server setups with cluster and DR site configurations.
  • Testing, Implementation, Performance Tuning of TDE on Corebanking database.
  • Planned and executed implementation of database security products, including TDE, DB Vault, and AVDF.
  • Catering Audit requirements for the client coming from RBI and in-house vendors.
  • DR drill planning and execution for a client.
  • Conducted analysis and troubleshooting of performance issues in client production environments, enhancing system reliability.
  • Catering Audit requirements for the client coming from RBI and inhouse vendors.

Database Technology Manager

Kotak Mahindra Bank Ltd
02.2010 - 01.2014

Database technology manager for Oracle, Ms-sql and Sybase databases.

  • Managed all Kotak Mahindra Bank databases across production, UAT, and DEV environments.
  • Oracle database performance tuning using tuning tools like AWR, ADDM, SQL trace, Query adviser for SQL query and segment adviser.
  • Planned and handled migration activities for Core banking Flexcube to Finale.
  • Led vendor production DBA team for database maintenance activities, ensuring minimal downtime and optimal performance.
  • Oracle database hardening and communicating with IT Security team for smooth hardening process without affecting production working.
  • Implemented Oracle Failsafe on Windows environment.
  • Coordinated DR drills for various applications, including RTGS and NEFT, to validate disaster recovery processes.

Lead DBA

Tata Consultancy Services Limited
09.2007 - 02.2010

Worked as Lead DBA in Core Banking production Support.

  • Executed core banking DR-drill activity to ensure operational readiness and disaster recovery effectiveness.
  • Involved implementation and upgradation of the total core banking solution software. It involves supporting and maintaining operations of over 1500 branches spread across India.
  • Resolved the critical Post Upgrade RAC & Database issues in critical applications.
  • Involves implementation and upgradation of the total core banking solution software. It involves supporting and maintaining operations of over 1500 branches spread across India.
  • Maintenance of Oracle 10g XE database at branches/clients.
  • Trained client DBA team on database maintenance and daily operational activities to strengthen support capabilities.

Assistant Consultant

Flexcel International Private Limited
01.2006 - 07.2007
  • Served as Assistant Consultant in Database Administrator role.
  • Managed 8i and 9i databases for clients LKB (Lord Krishna Bank), FIC (First India Credit), SBM (State Bank of Mauritius), ensuring optimal performance and reliability.

Leo Circuit Boards Pvt Ltd
05.2005 - 01.2006
  • 6 Months of Experience in Desktop Level Support.

Education

B.E. - Electronics and Telecommunication

Mumbai University, Mumbai
01-2004

HSC -

Mumbai Board, Mumbai
01-2000

First Class

SSC -

Maharashtra Board, Mumbai
01-1998

Distinction Class

Skills

  • Oracle SQL
  • Shell scripting
  • Oracle RAC
  • Linux
  • Windows
  • Oracle ASM
  • Oracle Enterprise Manager
  • RMAN backup & recovery
  • Oracle GoldenGate
  • Database team leadership
  • Production support coordination
  • Audit requirements management

Affiliations

  • AWS Certified Solutions Architect Associate – SAA C03
  • Oracle Certified Professional – Database Administration

Certification

AWS Certified Solutions Architect Associate – SAA C03

Personal Details

  • Father’s Name: Abhimanyu Bhagat
  • Sex: Male
  • Contact Nos.: +91- 9987301257

Timeline

Database Manager and Technical Architect - Tech Mahindra Limited
07.2024 - Current
Database Team Lead - Tata Consultancy Services Limited
01.2014 - 07.2024
Database Technology Manager - Kotak Mahindra Bank Ltd
02.2010 - 01.2014
Lead DBA - Tata Consultancy Services Limited
09.2007 - 02.2010
Assistant Consultant - Flexcel International Private Limited
01.2006 - 07.2007
- Leo Circuit Boards Pvt Ltd
05.2005 - 01.2006
Mumbai University - B.E., Electronics and Telecommunication
Mumbai Board - HSC,
Maharashtra Board - SSC,
Deepak BhagatDatabase SME-Architect