Summary
Overview
Work History
Education
Skills
Certification
Professional Tools And Technologies
Languages
Timeline
Generic

Mahesh V P

Bangalore

Summary

Seasoned Oracle Database Specialist with over 8.5 years of experience in database administration, performance tuning, query optimization, and database development. Hands-on expertise in designing, developing, and maintaining enterprise-grade Oracle databases. Proven ability in managing database security, backup/recovery, and capacity planning. Strong experience collaborating with cross-functional teams, maintaining high-availability environments, and driving continuous improvement.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Lead Oracle Database Developer

HCLTech
09.2022 - Current
  • Led database support for a global automobile client in automotive domain.
  • Designed, developed, and optimized Oracle database schemas and structures to meet application specifications.
  • Monitored database performance, tuned systems, and resolved critical bottlenecks using AWR and SQL trace.
  • Ensured database security through access controls; managed backup and recovery strategies with RMAN.
  • Collaborated with development teams to create efficient ETL processes and database architectures.
  • Maintained comprehensive documentation including data dictionaries and standard operating procedures.
  • Provided capacity planning, data growth projections, and performance reports to management.
  • Utilized Python scripting to automate reporting tasks and enhance database monitoring.

Oracle Database Administrator / Performance DBA

Tata Consultancy Services (TCS)
04.2019 - 09.2022
  • Executed SQL performance tuning and workload analysis to enhance system efficiency.
  • Optimized queries and managed resources for production-critical systems.
  • Collaborated with developers and application teams to resolve SQL performance challenges.
  • Prepared root cause analysis reports for escalated incidents and performance issues.
  • Automated database health checks and generated performance reports using SQL.

Oracle Database Administrator / Infra DBA

Tata Consultancy Services (TCS)
03.2017 - 04.2019
  • Managed Oracle database provisioning, configuration, cloning, and refresh activities.
  • Administered core backup/recovery, patching, and migration processes.
  • Built and configured Azure Virtual Machines and installed Oracle Database and Oracle GoldenGate for application requirements.
  • Maintained high-availability environments and provided 24x7 support.
  • Supported change management, patch application, and incident resolution.

Education

Bachelor of Engineering (B.E.) - Electronics and Communication Engineering

SJB Institute of Technology
Bangalore
01.2016

Skills

Database design and development

Performance tuning strategies

Query optimization techniques

Backup and recovery solutions

Data security measures

Documentation and SOP creation

Incident management and RCA

Capacity planning and resource management

ETL process support

Collaboration with development teams

Oracle database administration (11g/12c/19c)

Certification

  • Oracle DBA 11g – Database Administration for DBA
  • Python For Everybody Specialization (Coursera)

Professional Tools And Technologies

  • Toad for Oracle
  • SQL
  • Plus
  • Oracle Enterprise Manager (OEM)
  • Data Pump
  • RMAN
  • AWR and ASH Reports
  • SQL Trace and Plan Baselines
  • Python (Basic Scripting and Data Processing)

Languages

Kannada
First Language
English
Upper Intermediate (B2)
B2

Timeline

Lead Oracle Database Developer

HCLTech
09.2022 - Current

Oracle Database Administrator / Performance DBA

Tata Consultancy Services (TCS)
04.2019 - 09.2022

Oracle Database Administrator / Infra DBA

Tata Consultancy Services (TCS)
03.2017 - 04.2019

Bachelor of Engineering (B.E.) - Electronics and Communication Engineering

SJB Institute of Technology

Similar Profiles

CREATE PROFILE
Mahesh V P