Job Title: Oracle PL/SQL developer

Location: Newark, Delaware (Day 1 Onsite)

Duration: Fulltime Permanent Only

PRIMARY SKILL

Oracle SQL / PLSQL

DESIRED SKILLS

Candidate will be working on system migration project involving RDBMS, Oracle built in features, PL/Sql programming, Intermediate level shell scripting and entry level python scripting. Prior experience on messaging solutions and systems design for business solutions will be a plus

REQUIRED SKILLS

Knowledge of object-oriented design and architecture / SOLID

•-Detail-oriented, with the ability to check your work and document your processes on a fixed schedule.

•-Working knowledge of Oracle 19cg/Oracle 21c added capabilities and functionality

•-7 years working with PL/SQL

•-5 years of SQL and SQL Tuning experience

•-Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing.

•-Experience working with source control

•-Ability to troubleshoot and diagnose problems quickly and communicate proposed solutions

•-Knowledge and experience with Performance tuning

•-Excellent written and verbal communication skills

•-Working knowledge of Oracle 19cg/Oracle 21c /Unix/python

•-should be good in advance plsql/tuning/UTL feature/ Developer Tools(toad)

•-developing PL/SQL Packages, Procedures Functions, Cursors and Triggers.

•-Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing and Hints.

•-Designing and executing test plans and performing gap analysis to ensure that business requirements and functional specifications are tested and fulfilled

•-Strong analytical and problem solving skills

•-Excellent written/verbal communication skills

•-Python is desired skill

SECONDARY SKILL

Linux, UNIX/SHELL SCRIPTS

TERTIARY SKILL

Python, Application Messaging - MQ