Oracle Cloud Infra Admin-SQL-PLSQL-Senior

We are looking for a highly skilled and experienced PLSQL Technical Consultant (Senior) with 3 to 7 years of experience to join our team. The ideal candidate will have a strong background in Oracle application development and support using Advanced PL/SQL. ### Roles and Responsibility Support client needs in Oracle application development and support using Advanced PL/SQL. Design and develop Oracle objects such as Packages, Procedures, Functions, Triggers, Views, Collections, and Exception handling for retrieving, manipulating, checking, and migrating complex datasets. Develop and maintain SQL queries including Scalar subqueries, inline views, outer joins, hints, and analytic functions. Create and optimize PL/SQL code for performance using partitioning, hints, and indexing strategies. Collaborate with senior leaders to understand business goals and contribute to the delivery of workstreams. Utilize expertise in SQL tuning and optimization using explain plan and SQL trace files. ### Job Requirements A Computer Science degree or equivalent is required. Possess strong analytical and debugging skills. Demonstrate a good understanding of advanced PL/SQL and performance tuning. Exhibit a positive and learning attitude, along with good communication and strong analytical skills. Experience in designing and developing Oracle objects and working knowledge of a source code control system is necessary. Prior consulting experience is preferred.