Summary
Overview
Work History
Education
Skills
Certification
Projects Highlights
Notice Period
Personal Information
Timeline
Generic

Mahesh V P

Bangalore,Karnataka

Summary

8+ years of total experience across SQL development, Oracle database management, and performance tuning. Strong focus on writing optimized SQL/PLSQL code, supporting data-driven applications, and assisting in query performance improvements. Adept at automating tasks using basic Python scripting and familiar with Azure cloud basics, including setting up virtual machines and Oracle environments. Proactive learner with hands-on experience in both development and support roles, capable of contributing effectively in cross-functional technical teams.

Overview

9
9
years of professional experience
1
1
Certification

Work History

SQL Developer & Data Support Engineer

HCLTech
09.2022 - Current
  • Developed and optimized complex SQL queries, stored procedures, and functions using Oracle SQL and PL/SQL.
  • Conducted SQL tuning to improve report generation and data extraction processes.
  • Automated routine data validation and reporting tasks using SQL jobs and lightweight Python scripts.
  • Created scheduled SQL scripts for automated batch processing and reporting.
  • Used Python scripting for file processing, report automation, and simple data transformations.
  • Supported application teams with SQL performance troubleshooting using execution plans and SQL Trace.
  • Delivered ad-hoc data requests using efficient SQL extraction techniques.
  • Managed SQL script versioning using Git.
  • Participated in monthly release cycles and coordinated data validations.
  • Supported basic ETL processes and contributed to data migration activities.

Oracle Performance DBA and SQL Developer

Tata Consultancy Services (TCS)
03.2017 - 09.2022
  • Specialized in SQL query tuning and database performance monitoring using AWR, ASH, and SQL Trace.
  • Recommended SQL query optimizations through rewrites, hinting, and indexing improvements.
  • Managed SQL Plan Baselines for performance stability in production environments.
  • Collaborated with application teams to address SQL performance issues during major releases.
  • Automated daily/weekly performance reports using SQL scripts.
  • Conducted RCA and incident management for critical database performance incidents.
  • Exposure to Oracle on OCI environments during performance assessments.

Oracle DBA

Tata Consultancy Services (TCS)
03.2017 - 06.2019
  • Managed Oracle database administration including user management, tablespace monitoring, and RMAN backups.
  • Handled database cloning and refresh activities.
  • Applied PSU patches and collaborated with infra teams during downtime.
  • Managed Data Pump export/import tasks and day-to-day database health monitoring.
  • Supported 24x7 production environments and participated in weekend patch cycles.

Education

Bachelor Of Engineering - Electronics and Communication

SJB Institute of Technology

Skills

  • Oracle SQL
  • PL/SQL
  • Oracle 11g
  • Oracle 12c
  • Oracle 19c
  • TOAD
  • SQL
  • Plus
  • RMAN
  • SQL Loader
  • AWR
  • ASH
  • SQL Trace
  • Execution Plans
  • SQL Plan Baselines
  • Python
  • Azure
  • Git
  • ETL Concepts
  • Data Analysis
  • Data Validation

Certification

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

Projects Highlights

  • Automated SQL reporting process using Python scripts to handle CSV parsing and report generation.
  • Provided SQL tuning support during critical data migration project for a banking client.
  • Built Azure VM and installed Oracle database and Goldengate to support application setup.

Notice Period

35 days, True

Personal Information

  • Title: SQL Developer
  • Availability: 35 days - Negotiable

Timeline

SQL Developer & Data Support Engineer

HCLTech
09.2022 - Current

Oracle Performance DBA and SQL Developer

Tata Consultancy Services (TCS)
03.2017 - 09.2022

Oracle DBA

Tata Consultancy Services (TCS)
03.2017 - 06.2019

Bachelor Of Engineering - Electronics and Communication

SJB Institute of Technology

Similar Profiles

CREATE PROFILE
Mahesh V P