15+ years hands on development using Oracle SQL/PLSQL.
Strong experience with oracle functions, procedures, triggers, packages & performance tuning.
Hands-on Advanced PL SQL concepts like Collections, Performance Tuning, Bulk collect, Partitions.
Experience in Dynamic SQL, Records, Exception Handling, and PL/SQL Tables.
Experience with SQL Performance Tuning for Oracle RDBMS using Cost-Based Optimization (CBO), Explain Plan, and HINTS.
Strong knowledge about creating complex and efficient queries in Oracle SQL.
Ability to troubleshoot and debug the application to fix defects and identify root causes.
Familiarity working with other RDBMS databases like MS SQL, My SQL, etc.
Experience in database designing with normalization concepts.
Database design and modeling using ERD tools and Converting ERD diagram to database design.
Even though I primarily work with 'Oracle' database, I'm very much comfortable work on other RDMSs like MYSQL,MSSQL,POSTGRESQL etc.