Position Details
Database Architect Menands Ny Onsite Apply
| Provide a short description of the Position: | The Fraud Activity Comprehensive Tracking System (FACTS) is an electronic drawer, composed of numerous and varying databases and interfaces that permit efficient access to current and historical information on all audit and investigative activities involving Medicaid providers and/or recipients. The application is web based and is accessible in real-time by over 1,200 users across the State in five state agencies (OMIG, DOH, AG (MFCU), OSC & CQC). The FACTS system is comprised of over 30 related modules. |
| Provide a list of the day to day tasks to be performed by the Selected Candidate: | Database software installation and configuration |
| Requested Qualification | Exp you have |
| 84 Months of experience in System Development Life Cycle and requirements gathering application design, coding, and testing. | |
| 84 Months of experience in database design, data modeling, data hosting, data warehouse management, data integration and data analysis. | |
| 84 Months of experience in a .net, Oracle and SQL Server environments, SQL tuning, monitoring database; ensuring data integrity, security. | |
| 84 Months of experience writing complex SQL against Oracle and SQL Server databases against Medicaid Data Warehouse claims. | |
| 60 Months of experience Content Management Systems with an emphasis on Docushare. | |
| 48 Months of experience developing and supporting Medicaid Providers/Recipients Audits and Investigations-related case management software and modules for a federal or state agency, in a Microsoft .Net/C# platform and Oracle back-end environment. | |
| Microsoft Certified System Developer (MSCSD), Oracle and SQL Server certified DBA | |
| Bachelor's degree in computer science | |
| R sum Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) |
