Tejas Pawar (TSP)

Oracle PL/SQL Developer | Power BI Data Analyst (PL-300) | 3+ Years @ TCS

Talent

MumbaiMember since 26 May 2026

Stored ProceduresFunctionsTriggersPackagesCursorsREF CursorsException HandlingBulk CollectFORALLDynamic SQLCollectionsSQL Query OptimisationPerformance TuningIndexingPartitioningExecution Plan AnalysisETL ProcessesData ModellingData MigrationDisaster RecoveryDatabase SecurityAgile/ScrumCode ReviewTechnical DocumentationCommunication

Hire this person

Send a job offer directly to this candidate

Stored ProceduresFunctionsTriggersPackagesCursors

About

Oracle PL/SQL Developer with 3+ years of experience at Tata Consultancy Services, specialising in Oracle Database 19c development, SQL query optimisation, and database performance tuning. Proven expertise in designing and optimising PL/SQL packages, stored procedures, functions, triggers, cursors, and exception handling.

Microsoft Certified

Power BI Data Analyst (PL-300) with hands-on experience in ETL processes, data modelling, and data migration. Adept at Agile/Scrum delivery and cross-functional collaboration to deliver secure, scalable, high-quality database solutions.

Experience

Oracle PL/SQL Developer - Tata Consultancy Services (TCS) - Mumbai, Maharashtra

(2022-10)

Designed, developed, and optimised Oracle PL/SQL packages, stored procedures, functions, and triggers on Oracle 19c, improving code reusability and reducing deployment errors by 30%.
Implemented advanced PL/SQL constructs — cursors, REF cursors, exception handling, Bulk Collect/FORALL, dynamic SQL, and collections — reducing average query execution time by 40%.
Developed and optimised complex SQL queries using indexing, partitioning, and execution plan analysis to improve query performance by up to 50%.
Collaborated with application developers to design database schemas, scripts, and data models enabling seamless integration across 5+ enterprise applications.
Implemented ETL processes and data migration strategies, successfully migrating 10+ GB of legacy data with zero data loss and 99.9% uptime.
Managed database backup, disaster recovery, and database security protocols, reducing system downtime by 25% through proactive monitoring.
Provided technical support and defect resolution across Dev/QA/Production environments, resolving 95% of reported issues within SLA timelines.
Created and maintained technical documentation (knowledge base articles, troubleshooting guides), improving team onboarding time significantly.
Contributed to Agile/Scrum sprints and code reviews, driving a 20% reduction in post-release defects.
Deployed production-ready applications across multiple environments with rollback procedures ensuring smooth releases.