VDH Prog Analyst PL​/SQL

VDH Prog Analyst 4 PL/SQL
VENDOR MAXIMUM SUBMITTAL RATE $$$.$$/hr.

* local candidates strongly preferred

* Mgr will conduct initial phone screens for out-of-state candidates ONLY, however, a second, onsite interview will be required.. Any in-state candidates will only attend an onsite interview, NO Skype, NO exceptions.

* please do not submit candidates who have already been submitted to SQL reqs at VDH in the past year.

* there is little chance of contract extension beyond the original ~6 months

Works as part of the Virginia Department of Health, Office of Information Management (OIM) team and plan, coordinate, develop, implement the assignments/tasks.

Specific Task(s):

• Developing Required Interfaces.

• Develop security for all the new screens and integrate with existing roles and application rules.

• Work with business to receive feedback throughout the development cycle.

• Unit test all the changes with proper test cases.

• Thoroughly document/test all changes.

Required Experience and Skill Set:
In depth knowledge of Oracle 12c Database, SQL, PL/SQL programming, APEX, Web PLSQL Tool Kit, UNIX shell scripts and Oracle 9i Application Server is required. Professional experience working with Oracle PL/SQL in an application development environment is required. Should have strong knowledge with relational databases and SQL. Knowledge in software development and installation, change management and testing. Strong designing, development and trouble shooting skills required.

Must be skilled in using XML, HTML, JAVA/AJAX SCRIPT, web scripting tools and PVCS. Good oral and written communication skills are required. Ability to work on multiple projects/issues simultaneously. Must have the ability to assess the impact of software upgrades and other environment changes.

Strong background and work experience in developing true web applications a must. Five or more years of work experience is required in Oracle 12c Database, SQL, PL/SQL programming. Experience in conducting feasibility studies; analyzing new requirements; preparing functional and system specifications for application programmers; developing data models and system designs; developing complex program codes; testing application and evaluating results for accuracy, timelines and integrative features;

preparing documentation; implementing and supporting data processing systems is required.

Required/Desired Skills

Skill Required /Desired Amountof Experience Strong sql and pl/sql experience in writing procedures, packages triggers etcRequired5

Years Oracle pl/sql web toolkitRequired2

Years

APEXHighly desired2

Years Oracle 12c/11g databaseRequired5

Years Java script/ajax scriptRequired3

Years Html Required3

Years Xml Highly  desired2

Years
Questions

No.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

Please list candidate's email address that will be used when submitting E-RTR.Question3

In what city/state does candidate reside? Question4

Is candidate willing and able to travel to Richmond, VA for a personal interview? The mgr will conduct initial phone screens (for out-of-state candidates ONLY) but a second, onsite interview is required. In-state candidates will attend only an onsite interview. There are NO exceptions, NO Skype. Question5

Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each sklll? Question6

Has your candidate been submitted to any previous SQL reqs with VDH in the last year? We need NEW candidates ONLY.Question7

Does your candidate agree to complete the entire engagement? Question8

Has your candidate been submitted to CAI in the past? If so, for which state agency and when? Question9

How soon after an offer can your candidate start? Question
10

Is candidate aware there is little chance of extension beyond the original ~6 month contract?