Oracle PL/SQL Developer, New York City, NY
Job Description:• At least 1+ years of experience in DB projects• Experience as an Oracle PL/SQL Developer.•Strong skills in Oracle server-side programming which includes SQL, SQL*Plus, PL/SQL Packages,Stored Procedures, Functions, Cursors, Triggers, Views,Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, 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 the error messages in the application•Experience in creating Materialized Views and Indexes for better performance of summary tables,Autonomous Transactions,Coding Dynamic SQL Statements.