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
Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.