The opportunity  
  We’re looking for PLSQL Technical Consultant (Senior) 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  7 to 11 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