Title: Oracle PL/SQL Developer - Hybrid
Location: Raleigh, NC, United States
Length: Long term
Restriction: W2 or C2C

Description:

Interview Type: InPerson Only *** Very long term project initial PO for 1 year, expect to go for 4+ years *** *** Hybrid *** Onsite two days a week.

Short Description:

Oracle Developer responsible for PL/SQL and SQL programming, development, business analysis. Requires working knowledge of application architecture, analysis and design.

Job Description:

Specific tasks/deliverables and skills for this position include the following:

Review Functional and Technical requirements for clarity.
Research and analyze existing business documents and processes, including forms and reports, and assist in making recommendations about improvements to processes.
Business Rule identification and validation.
Assist with the Application design and analysis as well as provide input to the Database design.
Document application design and system architecture in accordance with NC DPI standards.
PL/SQL development and SQL programming, code documentation and unit testing.
Web development experience required.
Integration design for data exchange, import and export.
Enhance the data model and write stored procedures.
Build technical deliverables as directed by Project Manager and the Applications Development/Data Management Team Manager.
Report creation and validation (including record control counts, validation checks, etc. per specifications).
Resolve any issues found in functional, performance, regression or acceptance testing.
Document all technical deliverables (e.g. database schemas, file extracts, intermediate tables/files, reports, processes, procedures, scripts, etc.) as built.
Document the data retrieval methods via ETL, FTP and other means utilized to include source, destination, schedule and job controls.
Perform training to NC DPI support staff for the maintenance/support of technical deliverables built.
Any other duties as determined needed by the Project Manager and/or the Applications Development/Data Management Team Manager with regards to developing data extracts, ETL processes, reports, etc.
Application Developer and DBA tasks completed in accordance with DPIs project methodology and to the satisfaction of the Project Manager and Applications Development/Data Management Team Manager.

Assignments are completed accurately and in a timely manner as determined and agreed to by management involved with the assignment of the tasks/deliverables.

Required Skills:

Solid developer Oracle database development, code documentation and unit testing. PL/SQL development and SQL programming. Web development. 5 Years
Enhance the data model and write stored procedures. Report creation and validation. 5 Years
Strong support experience with ability to resolve application issues found during testing or in production. 5 Years
Integration design for data exchange, import and export. Familiar with ETL and FTP to include source, destination, schedule and job controls.3Years
Transitioning application maintenance/support to others including providing PL SQL training and support to technical staff. 3 Years
Researching/analyzing Functional requirements including Business Rule identification and validation, business documents and process improvements. 3 Years