Senior Oracle Database Developer

EY-Consulting Advanced PL/SQL - Technical Consultant Job Summary

Were looking for PLSQL Technical Consultant to join the leadership group of our Consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

Responsibilities

• Support client needs in Oracle application development/support using Advanced PL/SQL
• Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements
• Working knowledge of a source code control system
• Interact with senior leaders, understand their business goals, contribute to the delivery of the workstreams

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