NJDOL App Systems Analysis/Programming Mgr 4 - PL SQL

Company: Apidel Technologies
Location: Trenton
Posted on: May 27, 2023

Job Description:

The PL/SQL Programmer is responsible for writing stored procedures, packages, functions and triggers required by the Web application Team.
CURRENT PL/SQL Programming Experience REQUIRED.

Work can be 100% Remote. Local candidates may be asked to work onsite as needed
The PL/SQL Programmer is responsible for writing stored procedures, packages, functions and triggers required by the Application Team. Programmer typically is involved in enhancement and development work. The Programmer works with the Functional Architect and Technical Architect Specialist on an as needed basis to ensure that design and code meets customer requirements.

Duties and Responsibilities:
Create PL/SQL packages, procedures, functions and triggers
Write complex SQL queries with sub-queries, analytical functions and inline views
Create technical specifications for junior oracle developers.
Review and understand the Application Team's work plan.
Provide status of work to Team Lead.
Work with Functional Architects to gather and interpret user requirements into design specifications.
Determine time estimates
Assist in managing and directing Application Team processes.
Coordinate work with other software developers on Application Teams.
Problem solving using the functional and technical programming standards.
Execute all required process steps.
Utilize configuration management tools, design tools, debugging tools, and any other environment specific tools necessary to create, test, and implement an application.
Research problems before approaching the Team Lead or Functional Architect for assistance.
Follow quality standards and all process steps.

Knowledge and Experience:
Extensive expertise in PL/SQL.
Use Collections like variable arrays, nested tables.
Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
Experience in designing backend Oracle modules for Java applications.
Create PL/SQL packages, procedures, functions and triggers
Write complex SQL queries with sub-queries, analytical functions and inline views

Required Skills:
PL/SQL, SQL Plus, SQL Loader - 5 years
Oracle 12C/11G - 5 years
System Study & Analysis - 5 years
Database Object creation (Tables, Views, Synonyms, Procedures, Functions, Triggers) - 5 years

Desired Skills:
SQL Tuning using Explain PLAN and TKPROF Utilities - 3 yearss
Education: Bachelor's Degree or equivalent certification

Keywords: Apidel Technologies, Trenton , NJDOL App Systems Analysis/Programming Mgr 4 - PL SQL, IT / Software / Systems , Trenton, New Jersey