Oracle PL/SQL Developer

Roles & Responsibilities

Oracle PL/SQL Developer

with 10+ years of experience in Design & Development of N-tier Client Server applications. Expertise in

SQL, Advanced Oracle PL/SQL, Database Performance Tuning & Optimization of SQL, UNIX and Shell Scripting .

Excellent communication and interpersonal skills and team player. Flexible and capable to work in cross platform environments.

Strong knowledge in

Oracle 12c/11g/10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors, Packages, PL/SQL collections) and standard Built-in Oracle Packages .

Experience in developing robust and highly scalable applications based on

Microservice

architecture using

Spring Boot and REST API's.

Experience in

PL/SQL and Query optimization .

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Used ETL features like Merge, SQL loader, external tables, pipelined/table functions.

Experience with

PL/SQL Developer and TOAD .

Hands on experience in

Oracle Retail Predictive Application Server (RPAS).

Works under 24/7 Shift and co-ordination with onsite team for issues tracking and trouble shooting.

Experienced in working with utilities like

SQL*Loader, External Tables, Import, Export to extract and load large volume of data.

Experience in

supply chain and retail domain especially in the Logistics area .

Hands on experience in the

oracle forms and reports 6i in development and support .

Hands on experience in the

Data Conversion and Data Analysis.

Using

EXPLAIN PLAN or tuning SQL and PL/SQL code for better performance with the help of Hints, Bulk collection techniques and Indexes.

Developed

materialized views

for data replication in distributed environments.