Senior Oracle Database Developer

EY; Dadri; On-site; INR 800,000 - 1,200,000; Full time

Job summary

EY Consulting Advanced PL/SQL - Technical Consultant in India seeks a PL/SQL Technical Consultant to join the leadership group of our Consulting Team. This is a fantastic opportunity to contribute to the growth of a new service offering within a leading firm.

You will support client needs in Oracle application development and support using Advanced PL/SQL, collaborate with senior leaders, and learn new technologies while delivering key workstreams.

Qualifications

• 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.
• Positive attitude, willingness to learn, and good communication.

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

SQL concepts

PL/SQL development

Oracle objects

SQL tuning

Load methods

Oracle DB architecture

Consulting experience

Education

Computer Science degree or equivalent

Tools

Source control systems

Job description

EY-Consulting Advanced PL/SQL - Technical Consultant Job Summary

Were 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.

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