Oracle PL/SQL & Backend Engineer

Pranav
Bakare

mrcaption49

5 years crafting high-performance database solutions

Meticulous Oracle PL/SQL Developer delivering resilient database solutions for Vodafone Idea's 218M+ user base and Accelya's global airline cargo platform. Expert in performance tuning, secure architecture, and CI/CD-driven deployments.

Get In Touch View Work Download Resume
Available for new opportunities
5
Years Exp.
218M+
Telecom Users
7
Airline Clients
50+
PL/SQL Scripts
Nexsys IT · Accelya Aviation
7 Global Airlines · Dec 2024–Present
~1 yr
TCS · Vodafone Idea
218M+ Users · Aug 2021–Dec 2024
3.5 yr
Telecom Aviation Cloud DevOps Backend Performance
01

Technical Skills

🗄️ Databases
Oracle 19cSQL PL/SQLPostgreSQL MongoDB AtlasRedis
⚙️ Backend
PythonDjango Django RESTRESTful APIs Celery
☁️ Cloud & DevOps
AWS EC2AWS S3 AWS RDSLambda CloudWatchDocker KubernetesHelm ArgoCDTerraform GitLab CI/CDLinux
🔧 Tools
SQL DeveloperPL/SQL Developer LiquibaseGradle PostmanJIRA
02

Work Experience

Dec 2024 — Present
Nexsys IT Consulting
Private Limited
Oracle PL/SQL Developer
Client: Accelya — SkyChain & Offer & Order
EKEmirates UAUnited Airlines AYFinnair SASScandinavian Airlines AMAeroméxico
  • Pioneered high-availability PL/SQL solutions for global airline cargo platform, ensuring resilient high-volume booking-to-delivery transaction processing.
  • Implemented SSO/MFA integration and Fine-Grained Access Control (Oracle VPD, DBMS_RLS) enforcing dynamic row-level security and enterprise compliance.
  • Refactored 40+ PL/SQL packages using layered reusable architecture, reducing technical debt across cargo modules.
  • Led enterprise performance tuning using ASH, AWR, ADDM — delivering 30–40% faster query performance in high-volume transactional workloads.
  • Designed Indexing & Partitioning architectures — reducing full-table scans by 60% and improving booking query response by 45%.
  • Orchestrated PL/SQL memory optimizations using PRAGMAs — reducing PGA memory by 35%.
  • Architected GitLab CI/CD pipelines integrated with Liquibase for version-controlled multi-stage database deployments.
Oracle VPDASH/AWR/ADDM BULK COLLECTGitLab CI/CD LiquibasePRAGMAs
Aug 2021 — Dec 2024
Tata Consultancy Services
System Engineer
Oracle PL/SQL Developer
Client: Vodafone Idea (VI) — 218M+ Subscriber Base
  • Managed and optimized Oracle databases for India's top telecom provider serving 218M+ users — ensuring peak performance and high availability.
  • Engineered and fine-tuned 50+ PL/SQL scripts, stored procedures, functions, cursors, and triggers.
  • Devised fast-refresh Materialized Views with MV logs — reducing query latency by 80% while ensuring near real-time data availability.
  • Engineered high-performance bulk processing reducing SQL-PL/SQL context switches by 45% for telecom transaction workloads.
  • Orchestrated enterprise ETL workflows using MERGE, DBMS_SCHEDULER, SQL Loader, UTL_FILE — automating 90% of recurring tasks.
  • Spearheaded zero-downtime database migrations across DEV, UAT, PROD — maintaining 99.9% uptime.
  • Automated partition lifecycle management — reducing storage consumption by 25%.
CBO / EXPLAIN PLANMaterialized Views ETL WorkflowsPartition Mgmt Zero-Downtime
03

Personal Projects

01
Full Stack Web App
Django Photo Album

Cloud-native photo management app with authentication and full CRUD. Containerized with Docker and deployed on Kubernetes with self-healing, highly available infrastructure.

DjangoDocker KubernetesPython
2025 View details →
02
Full Stack Web App
Django Blog App

Feature-rich blog platform with CRUD, search & tag filtering. AWS infrastructure provisioned with modular Terraform and automated with Ansible for repeatable deployments.

DjangoTerraform AnsibleAWS S3PostgreSQL
2025 View details →
03
E-Commerce · CI/CD
Django PayPal

Secure e-commerce platform with PayPal integration for product management, order processing, and transaction validation. GitLab CI/CD + Docker automate all deployments.

DjangoPayPal API GitLab CI/CDDocker
2025 View details →
Projects /
04

Certifications

☁️
Google Cloud Platform
Associate Cloud Engineer Certification
🛒
Udemy
Django with React — An Ecommerce Website
🔥
Udemy
MERN From Scratch 2023 — eCommerce Platform
🚀
Udemy
GitLab CI/CD: Pipelines, CI/CD and DevOps
🌐
Coursera
The Bits and Bytes of Computer Networking
🤖
Coursera — Stanford University
Machine Learning
05

Awards & Recognition

TCS · 2024
Contextual Master Award
Tata Consultancy Services
TCS · 2023
On The Spot Award
Tata Consultancy Services
06

Education

Bachelor of Engineering
Information Technology
K. K. Wagh Institute of Engineering Education and Research, Nashik
Savitribai Phule Pune University, Maharashtra
2017 – 2021
8.66
CGPA
07

Let's Connect

Looking for an experienced Oracle PL/SQL Developer & Backend Engineer? I'm open to full-time roles, consulting, and exciting new challenges.

+91 96891 52948 +91 70570 62625 pranavsb49@gmail.com LinkedIn Linktree
Crafted with precision & care. © 2026 Pranav Bakare