SysMind Tech
Oracle PL/SQL Developer
SysMind Tech, Irvine, CA, United States
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.
ü 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.