- 4.6+ Years Oracle PL/SQL Developer With: Enterprise-scale database systems (218M+ users – Vodafone Idea) Airline domain product platform (Accelya – 200+ global carriers) Advanced performance tuning (AWR, ASH, ADDM) Bulk processing (BULK COLLECT, FORALL) Advanced security (VPD, FGAC, DBMS_RLS) CI/CD for Database (Liquibase + GitLab + Gradle) ETL frameworks, SQL*Loader, External Tables Scheduler automation (DBMS_SCHEDULER + Cron) Materialized Views (Fast Refresh) Partitioning & Archival Framework PRAGMA usage & Autonomous Transactions
Here is your ~500-word professional summary
Pranav Bakare is a results-driven Oracle PL/SQL Developer with over 4.6 years of hands-on experience in designing, developing, and optimizing enterprise-grade database systems. He possesses deep expertise in Oracle Database development, performance tuning, and high-volume transaction processing across telecom and airline industry domains. His professional journey spans large-scale production environments supporting millions of users, where performance, scalability, and data integrity are mission-critical.
Currently working as a Software Engineer at Nexsys IT Consulting, contributing to Accelya’s airline cargo platform trusted by 200+ global carriers, Pranav plays a key role in engineering modular, high-performance PL/SQL solutions. He has designed and revamped over 40 parameterized PL/SQL packages, procedures, and functions using advanced concepts such as overloading, encapsulation, PRAGMA directives, and autonomous transactions. His work emphasizes maintainability, modularity, and execution efficiency in complex enterprise environments.
He has strong expertise in performance engineering using Oracle’s diagnostic tools such as AWR (Automatic Workload Repository), ASH (Active Session History), and ADDM (Automatic Database Diagnostic Monitor). Through systematic SQL tuning, optimizer analysis, indexing strategies, and partitioning techniques, he has achieved measurable improvements including 30–40% faster query performance and significant storage optimization. His experience includes working extensively with BULK COLLECT, FORALL, Global Temporary Tables (GTTs), and pipelined table functions to optimize large-scale data processing and reduce context switching.
Pranav has also implemented secure database frameworks using Oracle Virtual Private Database (VPD), DBMS_RLS for fine-grained access control (FGAC), and audit triggers leveraging PRAGMA AUTONOMOUS_TRANSACTION to ensure tamper-proof transaction logging. His contributions have strengthened data governance, compliance, and row-level security enforcement in enterprise applications.
Beyond core PL/SQL development, he has engineered automated ETL pipelines using staging tables, MERGE statements, SQL*Loader (direct-path loading), External Tables, and UTL_FILE for efficient data import/export operations. He has also built metadata-driven archival frameworks using dynamic SQL (EXECUTE IMMEDIATE) and Oracle data dictionary views to automate schema-agnostic DDL/DML processes.
A strong advocate of DevOps for databases, Pranav has architected multi-stage CI/CD pipelines using GitLab, Liquibase, and Gradle to enable version-controlled, automated database deployments across multiple environments including UAT, TRG, and PROD. His structured deployment strategy has resulted in zero post-production failures for extended periods.
Earlier at Tata Consultancy Services, he supported one of India’s largest telecom platforms serving over 218 million users, where he engineered high-performance database solutions, automated job scheduling using DBMS_SCHEDULER and Cron, and reduced debugging time by 40% through a centralized exception-handling framework.
In addition to database specialization, Pranav possesses full-stack capabilities in Python/Django, along with cloud exposure to AWS, GCP, Docker, and Kubernetes, allowing him to understand end-to-end application architecture. This hybrid expertise enables him to design database solutions aligned with modern distributed systems and scalable cloud-native environments.
Overall, Pranav is positioned as a Senior Oracle PL/SQL Developer with strong expertise in performance optimization, database architecture, security implementation, CI/CD automation, and enterprise-scale system engineering.
Top comments (0)