Join EY's Consulting Team as a PL/SQL Technical Consultant and play a key role in expanding our advanced PL/SQL service offering. This position is ideal for someone passionate about Oracle application development and eager to contribute to a leading global firm.

This is a remarkable opportunity to integrate into a dynamic leadership group within our Consulting practice. You'll be instrumental in nurturing a new service line and shaping its future success. Embrace a role where you can drive innovation and deliver exceptional value to clients.

Support client requirements in Oracle application development and maintenance, leveraging advanced PL/SQL expertise. Maintain a proactive, solution-oriented approach, with a readiness to acquire new technologies to meet client needs. Ensure proficiency with source code control systems for efficient development workflows. Collaborate with senior leadership to understand business objectives and contribute to the successful execution of project workstreams.

Engage with clients to understand their challenges and deliver effective Oracle database solutions. Contribute to project planning and execution, ensuring timely and high-quality deliverables. Foster strong relationships with stakeholders through clear communication and technical insight.

Possess a strong foundation in SQL, including concepts like Group By, Joins, Surrogate Keys, Constraints, Datatypes, and Indexes. Demonstrate extensive experience in designing and developing Oracle objects. Showcase expertise in crafting complex SQL queries and utilizing advanced functions. Proven ability to develop PL/SQL Packages, Procedures, Functions, Triggers, Views, and manage Exception Handling for intricate data manipulation.

Exhibit proficiency in SQL tuning and optimization techniques, utilizing tools like explain plan and SQL trace. Understand and apply partitioning, hints, and indexing strategies for peak performance. Experience with Direct Load and Conventional Load using SQL Loader is essential. A solid grasp of Oracle Database Architecture is required.

This role calls for a Computer Science degree or equivalent educational background, coupled with 4 to 6 years of dedicated development experience. Strong analytical and debugging capabilities are paramount. A good understanding of advanced PL/SQL and performance tuning methodologies is crucial. We seek candidates with a positive, learning attitude, excellent communication skills, and robust analytical acumen.