/>
IdentityI have over 8 years of real-time industry experience working extensively with Oracle SQL and PL/SQL development. My expertise lies in designing, developing, and optimizing database solutions that support business-critical applications and reporting needs.
SQL Development: Proficient in writing complex SQL queries, joins, subqueries, views, and analytic functions for data extraction, transformation, and reporting. Skilled in query optimization and performance tuning using EXPLAIN PLAN, indexing strategies, and Oracle optimizer techniques.
PL/SQL Programming: Hands-on experience in developing stored procedures, functions, packages, triggers, and advanced PL/SQL constructs. Adept at using bulk processing (BULK COLLECT, FORALL) to handle large data volumes efficiently.
Database Design & Management: Strong knowledge of relational database design, normalization, partitioning, constraints, and schema management. Worked on implementing data models, indexing strategies, and archival/purging processes.
Performance Tuning & Optimization: Experienced in tuning long-running queries, minimizing context switches between SQL and PL/SQL, and leveraging tools like DBMS_XPLAN, AWR reports, and profiler utilities.
Sector V,
Kolkata
Certified
