Laksan Technologies Hiring for PL/SQL programmer at Trenton, NJ Full Time

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

Skill

Required / Desired

Amount

of Experience

PL/SQL. SQL Plus, SQL Loader Required 5 Years

Oracle 12C/ 11G Plus through 19C Required 5 Years

System Study & Analysis – 5 years Required 5 Years

Database Object creation (Tables, Views, Synonyms, Procedures, Functions, Triggers) – 5 years Required 5 Years

SQL Tuning using Explain PLAN and TKPROF Utilities Desired 3 Years