Durga Devi V Email & Phone Number

Chennai, Tn, In

Bengaluru, Karnataka, India

 Over 4 years of experience in PL/SQL and Oracle SQL development. Involved in all phases of the Software Development Life Cycle (SDLC), including analysis, design, development, testing, implementation, and maintenance, consistently meeting tight deadlines and delivering quality work. Strong understanding of RDBMS principles and proficient in using Oracle SQL's DDL, DML, DCL, and TCL statements. Highly skilled in writing complex queries utilizing group functions, set operators, joins, subqueries, and analytical functions. Designed, developed, and maintained Oracle database objects such as tables, views, synonyms, materialized views, sequences, and indexes. Developed complex database objects, including stored procedures, functions, packages, and triggers, using SQL and PL/SQL. Familiar with tools like SQL*Loader and External Tables for loading data from external files into Oracle tables. Extensively used Exceptions for error handling and Cursor/Ref Cursor for retrieving multiple records from tables within PL/SQL blocks. Expertise in developing applications using advanced Oracle features like collections, dynamic SQL, and robust exception handling. Skilled in using bulk collections (FORALL, LIMIT, BULK EXCEPTION HANDLING, BULK BINDS) to reduce context switching between SQL and PL/SQL engines, thereby enhancing performance and simplifying data retrieval. Excellent understanding of SQL statement optimization techniques such as Explain Plan, Oracle Hints, and Table Partitioning, along with proficiency in data performance tuning. Strong knowledge of built-in packages like DBMS_MVIEW and extensive experience with UNIX shell scripting.