Previous Job
Previous
PL/SQL Developer SO #26648781; 26648782
Ref No.: 18-19222
Location: NYC, New York
Position Type:Full Time/Contract
Start Date: 03/22/2018
Job Description:

PLSQL Onsite - Strong in SQL/PLSQL coding and debugging with Unix knowledge to update shell scripts

• Proficient in SQL & PLSQL (atleast 4 in a scale of 1-5).
• Make code changes in existing SQL files for recent requirements.
• Develop & deploy enhancements in SQL/PLSQL for newer requirements.
• Strong Unix & Shell scripting knowledge
• Oracle – Knowledge on Partitions, Materialized View, Indexes, Triggers, schedulers, SQL Loader.
• Monitor critical jobs and make sure all production jobs are up & running.
• Knowledge on advanced oracle features is good to have.
• Knowledge on SQL Loader – different types of loading & multi table options-
• Good performance Tuning exposure – Usage of TKProf/ Hints/ Statistics etc
• Proficient in SQL & PLSQL (atleast 4 in a scale of 1-5).
• Make code changes in existing SQL files for recent requirements.
• Develop & deploy enhancements in SQL/PLSQL for newer requirements.
• Strong Unix & Shell scripting knowledge
• Oracle – Knowledge on Partitions, Materialized View, Indexes, Triggers, schedulers, SQL Loader.
• Monitor critical jobs and make sure all production jobs are up & running.
• Knowledge on advanced oracle features is good to have.
• Knowledge on SQL Loader – different types of loading & multi table options-
• Good performance Tuning exposure – Usage of TKProf/ Hints/ Statistics etc