Oracle PL/SQL Developer - 100% remote Job Type: Contract to hire Rate: $51/hr W2 • • • CANDIDATES MUST COMPLETE THE FOLLOWING SKILLS MATRIX IN ORDER TO BE CONSIDERED • • • These are the MUST-HAVE skills. Please verify you have them and put the number of years of experience with each: 1. Experience in writing Packages for data loads. 1. Experience creating and maintaining Stored Procedure (Packages, Procedures, Functions, and anonymous block) with Oracle PL/SQL 1. Experience using Cursors to pull data from the Database. 1. Experience with performance tuning, query optimization, explain plan etc 1. Experience with external tables and high-volume data import into Oracle DB Required Experience: • At least 8+ years of experience as an Oracle PL/SQL Developer. • Strong skills in Oracle server-side programming, which include SQL, SQL • Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialized Views, Temporary tables, Object Oriented PL/SQL Programming, Jobs, Schedulers, PL/SQL Web-services, Java Stored Procedures, and Oracle AQ. • Hands-on experience on XML generation inside PL/SQL components. • Strong Skills in data analysis, data modeling, development, testing, and documentation. • Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL • Plus. • Hands-on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues. • Strong Skills in Exception Handling, extensively debug PL/SQL Code, DDL, DML, and display error messages in the application. • Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, and Coding Dynamic SQL Statements. • Experience in SQL tuning to improve the query performance by identifying key fields, adding/removing tables/fields, and using indexes. • Good understanding of Oracle Explain Plan.