Website Analysis & Design Specialist / Oracle

PSB job description for your reference:

Job Title: Website Analysis & Design Specialist / Oracle

Duration: 08 month contract

Location: Albany NY

Position Requirements/Technical Skills:

Project Scope- duties of position

·Medical Malpractice Data Collection System (MMDCS).

·Under Section 315(b) of the New York State Insurance Law, Hospitals, Insurance Companies, and certain Health Care Practitioners are required to report all malpractice claims within 90 days. The current Medical Malpractice Data Collection System (MMDCS), developed in 2002, is an outdated system which places a high burden on DOH staff and the claim reporters, requiring large numbers of staff to manually enter data into the system.

·The Department of Health has a need to readdress the processes, and systems involved in the reporting of Medical Malpractice claims. A new comprehensive system to track all malpractice claims and related data needs to be designed and implemented. The system needs to support centralized intake to employ consistent investigation criteria and permit the automated identification of duplicative entries. The system needs to allow for prompt research and retrieval of accurate information from stakeholders, and to allow DOH to accurately report out on the data that is collected.

Daily Tasks will include but are not limited to the following:

·Analysis and design of websites and data collection systems, including the transformation of legislative requirements into system functionality.

·Designs system architecture and user interface.

·Responsible for software development tasks including coding, testing, and implementation.

·Prepares technical and user documentation.

PART A: The ONE MANDATORY REQUIREMENT:

Expert Level

PART B: Requested Desirable Qualifications: The numbered qualifications below are not mandatory, but candidates should meet or exceed in duration and skill set target asked for, at least 3 of numbers 1 through 5.

·84 Months Experience developing Oracle PL/SQL using advanced PL/SQL programming techniques.

·84 Months Experience using Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications.

·48 Months Experience with designing and implementing logical and physical database models, experience with concepts such as indexes, primary keys, foreign keys, and constraints.

·48 months Experience performing Extract, Transform, and Load (ETL) techniques.

·24 months Experience optimizing, performance tuning, and debugging PL/SQL.