Job Title : ON-SITE - Oracle Database Architect - HBITS-05-13397
Location : Albany, NY,12229
Duration : Long-term
Job Description:
- 84 months experience ensuring the soundness of the architecture and security of Oracle databases for multiple applications in Production/Quality Assurance/Development environments
- 84 months experience creating Oracle schema objects and reviewing developers work to ensure they meet industry and in-house standards for multiple applications
- 84 months experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc.
- 84 months experience building and maintaining Oracle tables that contain Protected Health Information (PHI) within a large health care environment.
- 84 months experience creating and maintaining Oracle database tables containing complex government financial data, specifically budgets, encumbrances, and payments within a government organization with an affected budget of 2 billion dollars or more.
- 84 months experience maintaining/supporting a Medicare D billing system including the creation and maintenance of NCPDP transactions such as B1, B2, B3, & E1.
- 60 months experience designing, building and maintaining data interfaces to Peoplesoft financial systems.
- 60 months experience working on a complex cost reporting application that supplies data for Medicare/Medicaid Cost Reports.
Agency: NYS Office of Mental Health
Project: Aid to Localities Fiscal System (ALFS); Client Worker Payroll (CWP); Oracle Cost Reporting Application (OCRA); MHARS Enhancement and Transformation (MET)
Detailed Job Description: ALFS: used to develop a budget, allocate funds, disburse payments and ensure that funds are expended in compliance with existing laws, regulations and guidelines. OCRA provides cost reporting information to Medicare & Medicaid. CWP: Allows for patients to become employed at OMH psych centers and tracks rosters, hours worked, payments, etc. MET A rewrite of OMH s MHARS electronic medical record system.
Max: SEVEN 32.800.2838
Kevin:- SEVEN 32.800.2373
ON-SITE -Oracle Database Architect- HBITS-05-13397