Oracle Cloud Infra Admin - Oracle Database Developer - SQL - PLSQL - Senior
Ernst and Young13 days ago
Noida, IndiaMid Level / Senior
Responsibilities
- Support client needs in Oracle application development and support using advanced PL/SQL.
- Design and develop Oracle database objects and work with complex datasets.
- Create PL/SQL packages, procedures, functions, triggers, views, collections, and exception handling logic.
- Perform SQL tuning and optimization using explain plans and SQL trace files.
- Apply partitioning, hints, and indexing strategies for optimal performance.
- Perform direct and conventional data loads using SQL*Loader.
- Understand Oracle Database architecture and contribute to client delivery workstreams.
- Interact with senior leaders to understand business goals and support consulting engagements.
Requirements
- Computer Science degree or equivalent experience.
- 4 to 6 years of development experience.
- Advanced PL/SQL knowledge and performance-tuning experience.
- Experience with SQL queries, including scalar subqueries, inline views, outer joins, hints, and analytic functions.
- Experience designing and developing Oracle objects and creating PL/SQL database components.
- Experience with SQL tuning, optimization, partitioning, hints, indexing, and SQL trace files.
- Experience with direct and conventional loads using SQL*Loader.
- Working knowledge of a source code control system.
- Strong analytical, debugging, communication, and learning skills.
- Prior consulting experience is preferred.
Benefits
- Support, coaching, and feedback from experienced colleagues.
- Opportunities to develop new skills and progress your career.
- Individual progression planning and practical experience through meaningful client projects.
- Freedom and flexibility to handle the role in a way that suits the employee.
- Interdisciplinary environment emphasizing quality and knowledge exchange.
About Ernst and Young
Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.