POSITION SUMMARY

Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions. These application program solutions may involve diverse development platforms, software, hardware, technologies and tools. Participates in the design, development and implementation of complex applications, often using new technologies. May provide technical direction and system architecture for individual initiatives. Serves as a fully seasoned/proficient technical resource. Will not have direct reports but may lead projects and direct activities of a team related to special initiatives or operations. May have responsibility for a project. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities. Works under minimal supervision, with general guidance from more seasoned consultants. Typically requires 11-12 years of experience

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

Location:

NEWARK