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.