Job Description :
Oracle PL/SQL developer
Albany NY
24 Months
Job Description:
Managed Care plans have a statutory requirement to file Revenue, Expense and Utilization data to Department of Health (DOH DOH must supply the cost report software to the plans for completion. In addition, DOH is responsible to set Medicaid/Medicare rates for the plans for some of the programs. The cost report data is also used in the Risk rate methodology.
Creation/Enhancement of Software used to collect, submit, view, and extract data regarding managed care costs and statistics to be used for various purposes including setting Medicaid rates.
The Specialist will be responsible for, but not limited to; writing and modifying Oracle database procedures and functions to support the applications (including coding, testing, and implementation); understanding and translating historical data, now in Sybase, to Oracle; Preparing technical and user documentation.
SKILL MATRIX:
1. 84 Months Experience interpreting physical database models including experience with relational database concepts such as indexes, primary/ foreign keys, and constraints using Oracle version 9i or later. #of months 20
2. 84 Months Experience creating database objects such as Tables, Indexes, Views, Sequences, Primary/Foreign keys, Constraints and Triggers. #of months 10
3. 84 Months Experience in using ORACLE programming tools (SQL Plus, PL/SQL, SQL Loader or other ORACLE database programming tools #of months 10
4. 84 60 Months Experience writing, optimizing, and troubleshooting dynamically created SQL within procedures. #of months 10
5. 60 Months Experience in database optimization #of months 10
6. 60 Months Experience in database analysis and design. #of months 10
7. 85 36 Months Experience working with Sybase. #of months 5
8. Bachelor’s degree in computer science or a comparable field #of months 5