Job Description :
Oracle 9i RDB PL/SQL Specialist
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.
Candidates should have at least 84 months experience and a majority of the following should apply:
Each candidate should fill out the months of experience they have for each item in the table:
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
2. 84 Months Experience creating database objects such as Tables, Indexes, Views, Sequences, Primary/Foreign keys, Constraints and Triggers. #OF MONTHS
3. 84 Months Experience in using ORACLE programming tools (SQL Plus, PL/SQL, SQL Loader or other ORACLE database programming tools #OF MONTHS
4. 84 60 Months Experience writing, optimizing, and troubleshooting dynamically created SQL within procedures. #OF MONTHS
5. 60 Months Experience in database optimization #OF MONTHS
6. 60 Months Experience in database analysis and design. #OF MONTHS
7. 85 36 Months Experience working with Sybase. #OF MONTHS
8. Bachelor’s degree in computer science or a comparable field #OF MONTHS