Joe Raja Email & Phone Number

Having 3+ years of experience in Oracle SQL AND PL/SQL Developer.• Involved in SDLC (Software Development Life Cycle) which involves requirements gathering analysis, design, development, implementation, maintenance and support.• Expertise in using DDL, DML, TCL, DCL Statements in Oracle SQL.• Having good experience in handling Oracle database object such as tables, views, synonyms, materialized views, sequence and indexes.• Strong knowledge in writing complex queries which includes joins, subquery, group functions, set operators and analytical functions.• Extensive experience in data migration techniques using PL/SQL procedures, functions, SQL*LOADER.• Developed Complex database objects like Stored Procedure, Functions, Packages and Triggers using SQL and PL/SQL.• Extensively used Cursor/Ref cursor to fetch multiple records from table inside the PL/SQL block and Exceptions to handle the error.• Experience in application development using various advanced features of Oracle like Collections, Autonomous transactions, Dynamic SQL and Exception handling.• Having good knowledge in bulk collections (FORALL, LIMIT, BULK EXCEPTION HANDLING) for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Having good knowledge in Supplied Packages (UTL_FILE, DBMS_MVIEW).• Having knowledge in UNIX basic commands.• Expertise in data performance tuning and Optimization of SQL statements using Explain plan, Index, Oracle Hints, Table partitioning.• Experience in SQL Performance Tuning using Cost-Based Optimization (CBO).

• 

  Back End Developer

  Novac Technology Solutions

  Sep 2023 - Present - Chennai, Tamil Nadu, India

• 

  Srv Matriculation Higher Secondary School Samayapuram

  Mechanical Engineering