Required Technical Skill Set:

We are looking for a developer with strong experience in PL/SQL and Oracle RDBMS

Must-Have:

• Strong knowledge PL/SQL fundamental concepts and Oracle RDBMS
• Strong knowledge in query optimization and performance tuning
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE
• Involved in Development and Created PL/SQL stored procedures, functions, packages, cursors and triggers.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Developed materialized views for data replication in distributed environments
• Should have experience of end to end Application Development lifecycle
• Experience in Agile delivery methodology

Good-to-Have:

? Degree level qualification in a relevant subject.

? Experience in Agile delivery methodology