Database Architect - Albany, United States - Castletop Logistics LLC

Castletop Logistics LLC

Verified Company

Albany, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Job Overview:
The requirements listed below are from the "
State of New York," and requires applicants to start on-site on
Day 1

Database Architect - Expert - HBITS

Location : 44 Holland Ave, Albany NY 12229

Agency Name:
NYS Office of Mental Health

Duties:

Project/Program Name:
Aid to Localities Fiscal System (ALFS); Client Worker Payroll (CWP);

Oracle Cost Reporting Application (OCRA); MHARS Enhancement and Transformation (MET)
Provide a short description of the Position:

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.

Requirements:

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, & E 60 months experience designing, building and maintaining data interfaces to Peoplesoft financial systems.

Job Types:
Full-time, Contract

Pay:
$ $77.54 per hour

Compensation package: