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