App Systems Analysis/Programming Mgr 4-PL SQL

Job Seekers, Please send resumes to resumes@hireitpeople.com

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 Teams 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:

Education: Bachelors Degree or equivalent certification

Experience required: 5-8 Years