Oracle Cloud Infra Admin Oracle Database Developer SQL /PLSQL Senior

Skills and attributes for success

• SQL Concepts – Group By / Joins/ Surrogate Keys / Constraints/ Datatypes / Indexes

• Experience in designing and developing Oracle objects such as Experience with SQL queries (Scalar subqueries, inline views, outer joins, hints, and analytic functions

• Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views, Collections and Exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle 

• Experience in SQL tuning and optimization using explain plan and SQL trace files 

• Partitioning, Hints and Indexing strategy for optimal performance 

• Experience in Direct Load & Conventional Load using SQL Loader 

• Should have good understanding Oracle Database Architecture 

• Prior consulting experience preferred

To qualify for the role, you must have

• Computer Science degree or equivalent

• 4 to 6 years of development experience

• Strong analytical and debugging skills

• Good understanding of advanced PL/SQL and performance tuning

• Should have positive and learning attitude, Good Communication, Strong Analytical skills