At EY, we’re all in to shape your future with confidence. 

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. 

Join EY and help to build a better working world. 

EY-Consulting – Advanced PL/SQL - Technical Consultant

The opportunity

We’re 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.

Your key 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

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

Support, coaching and feedback from some of the most engaging colleagues around

Opportunities to develop new skills and progress your career

The freedom and flexibility to handle your role in a way that’s right for you

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.