Oracle PL SQL Developer

Oracle PL SQL Developer

Location: Raleigh, NC (Hybrid)

Duration: Long Term Contract

Interview: In Person Only

Onsite two days a week. 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 DPI’s 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.