What are the responsibilities and job description for the NCDPI - Oracle PL SQL Developer position at Pacer Group?
Oracle Developer responsible for PL / SQL and SQL programming development business analysis. Requires working knowledge of application architecture analysis and design.
Onsite two days a week.
Specific tasks / deliverables and skills for this position include the following :
1. Review Functional and Technical requirements for clarity.
2. Research and analyze existing business documents and processes including forms and reports and assist in making recommendations about improvements to processes.
3. Business Rule identification and validation.
4. Assist with the Application design and analysis as well as provide input to the Database design.
5. Document application design and system architecture in accordance with NC DPI standards.
6. PL / SQL development and SQL programming code documentation and unit testing.
7. Web development experience required.
8. Integration design for data exchange import and export.
9. Enhance the data model and write stored procedures.
10. Build technical deliverables as directed by Project Manager and the Applications Development / Data Management Team Manager.
11. Report creation and validation (including record control counts validation checks etc. per specifications).
12. Resolve any issues found in functional performance regression or acceptance testing.
13. Document all technical deliverables (e.g. database schemas file extracts intermediate tables / files reports processes procedures scripts etc.) as built.
14. Document the data retrieval methods via ETL FTP and other means utilized to include source destination schedule and job controls.
15. Perform training to NC DPI support staff for the maintenance / support of technical deliverables built.
16. 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.
Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
Solid developer Oracle database development code documentation and unit testing. PL / SQL development and SQL programming. Web development.
Required
Years
Enhance the data model and write stored procedures. Report creation and validation.
Required
Years
Strong support experience with ability to resolve application issues found during testing or in production.
Required
Years
Integration design for data exchange import and export. Familiar with ETL and FTP to include source destination schedule and job controls.
Required
Years
Design application framework based on requirements documentation utilizing Oracle Database.
Nice to have
Years
As Built application analysis / design and system architecture documentation including database schemas and data retrieval methods.
Nice to have
Years
Transitioning application maintenance / support to others including providing PL SQL training and support to technical staff.
Required
Years
Researching / analyzing Functional requirements including Business Rule identification and validation business documents and process improvements.
Required
Years
Questions
Question
Question1
Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement
Question2
An IN PERSON INTERVIEW is REQUIRED for this position. If your candidate cannot come in person for an interview he or she will be rejected. Do you accept this requirement
Question3
Please list candidates email address HERE that will be used when submitting ERTR.
Question4
Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.
Question5
Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement
Question6
Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement
Question7
Candidates submitted above the rate of XX80.00 may not be considered. Do you accept this requirement
