The New York State Department of Health needs to redesign the Medical Malpractice Data Collection System (MMDCS) to reduce the burden on staff and claim reporters, and to improve the accuracy and efficiency of data collection and reporting.
Requirements
- Expert Level Oracle PL/SQL using advanced PL/SQL programming techniques
- Experience using Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications
- Experience with designing and implementing logical and physical database models, experience with concepts such as indexes, primary keys, foreign keys, and constraints
- Experience performing Extract, Transform, and Load (ETL) techniques
- Experience optimizing, performance tuning, and debugging PL/SQL
- 84 Months Experience developing Oracle PL/SQL
- 84 Months Experience using Oracle development tools
Responsibilities
- 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.
- Development of a new comprehensive system to track all malpractice claims and related data
- Implementation of centralized intake to employ consistent investigation criteria and permit the automated identification of duplicative entries
- Design of a system to allow for prompt research and retrieval of accurate information from stakeholders
Other
- Bachelor's degree or higher
- Ability to work on a contract basis for 8 months
- Location: Albany NY
- Travel requirements not specified
- Clearance requirements not specified
