Senior Oracle Developer / Oracle Lead

Job Description

Oracle PL/SQL / Oracle SQL - MUST (Should have Basic understanding of concepts and features of Oracle PLSQL , SQL – Joins, SQL Loader, External Table, UTL_FILE, Cursors, Exception Handling, Collections, Forall & save exceptions, Triggers, Oracle Queues, ORDS APIs, Performance Tuning, Analytical Functions, ETL , Unix Commands, Package utilities over standalone methods, Simple queries, Explicit Cursor Functionality and scenario (eg. Query to match the timeframe and get most stable price, Scenario to tune the performance for Deleting the records, Development Tools, SQL – Correct the data (eg Female to Male and Male to Female), Equi and Non-equi joins, Oracle Forms / Reports, Pro C / UNIX Shell Scripting, foreign key constraints, SQL – Analytical function use. Must be excellent in writing SQL Queries and Good in PLSQL Concepts, has worked on variety of oracle PLSQL tasks and knows the basics of them, should have skills to write solution as per requirement, Should be able to answer for some scenario based logical questions, Able to write normal sub-query and simple pl/sql block, Able to write the code snippet for the problems UNIX - Basic UNIX commands MUST have Knowledge of Basic SQL & PLSQL queries Tables, constraints, indexes, views, sequences and synonyms Packages, procedures, functions, triggers and using cursors, ref cursors, dynamic SQL with bind variable, bulk dml using pl/SQL arrays, nested tables and v-arrays. People management as well as Hands-on technical experience SQL-loader, external tables and Oracle AQs Solid SQL query writing and PL/SQL skills, problem solving and performance tuning for OLTP system Experience in working on Unix based OS with some hands-on exposure to Shell scripting Must have solid development experience in Oracle PL/SQL, SQL, Performance tuning and transaction management. Agile Awareness

Required Skills