EY EA Middleware - Infra-Oracle SQL/PLSQL Performance Tuning Consultant 

India, Maharashtra, Pune 

269510276

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

• Experience in SQL tuning and optimization using explain plan and SQL trace files
• 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
• 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
• 3 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

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 exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.