Previous Job
Pl/SQL with Linux - SO #26648781; 26648782
Ref No.: 18-54545
Location: NYC, New York
Position Type:Full Time/Contract
Start Date: 08/01/2018
 PLSQL Onsite - Strong in SQL/PLSQL coding and debugging with Linux 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 Linux & 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