pl sql developer roles and responsibilities

Strong experience in Oracle ETL data loading techniques like UTL_FILE, SQL loader, Copy Command and External tables from various business source environments.Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.Proficient in Oracle utilities and tools - SQL*loader, Export/Import, SQL*plus, SQL Developer and SQL Navigator.Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables), Records, Object types and Database Triggers.Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.

Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions.Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies.Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.

3 years of strong professional experience in Data Base Design, Data ware house, Application Development using Oracle 12c/11g, SQL, PL/SQL, Oracle Data Integration.

Pl sql developer roles and responsibilities