Oracle Database Developer - HBITS-08-15035

Greycell Labs Inc; City of Albany (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

OMH is seeking an experienced Oracle Database Developer for on-site Albany, NY. The role focuses on upgrading legacy Oracle databases, splitting schemas per application, and preserving user access.

You'll perform extensive performance tuning, PL/SQL development, and build/maintain PHI-containing tables. You will also work with government financial data and Medicare/Medicaid cost reporting systems, including NCPDP transactions and PeopleSoft interfaces.

Qualifications

• 36 months upgrading Oracle databases to current versions.
• 84 months Oracle performance tuning and indexing strategies.
• 84 months Oracle design, PL/SQL, stored procedures, packages, indexes, triggers.
• 84 months handling PHI in healthcare environments.
• 84 months working with government financial data budgets, encumbrances, payments.

Responsibilities

• Upgrade legacy Oracle databases and split schemas per application with proper access preservation.
• Tune performance by analyzing slow SQL, creating partitions and indexes, and rewriting queries.
• Design and maintain Oracle tables, PL/SQL code, procedures, and triggers.
• Maintain Oracle tables containing PHI in healthcare environments.
• Maintain government financial data schemas with large budgets and encumbrances.
• Support Medicare cost reporting interfaces incl. NCPDP transactions.
• Build data interfaces to PeopleSoft financial systems.
• Contribute to cost reporting applications for Medicare/Medicaid.

Skills

Oracle Database

Performance tuning

PL/SQL coding

Data architecture

PHI data handling

Medicare/Medicaid knowledge

Cost Reporting systems

Tools

PeopleSoft

NCPDP

Job description

Job Title: ON-SITE - Oracle Database Developer - HBITS-08-15035

Location: Albany NY 12229

Duration: Long-term (30)

Job Description

• 36 months experience upgrading legacy Oracle databases to current supported versions, and splitting up Oracle database instances that contain schemas for multiple applications into separate Oracle instances, one per application, while also preserving user accounts and roles and maintaining any access that was present between database schemas, using data facades or links
• 84 months experience doing Oracle performance tuning by reviewing slow performing SQL and creating partitions, indexes, new table structures or SQL rewrites to ensure fast data retrieval. This includes regular checks of application databases for any SQL that is performing full table scans when accessing data and the implementation of indexes to avoid full table scans. All of this includes measuring the performance, before and after.
• 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 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 cost reporting application that supplies data for Medicare/Medicaid Cost Reports.

________________________________________________________________

Agency: OMH

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.

Note: Sorry we do not Sponsor Visa

Max: SEVEN 32.800.2838

Aryan: - SEVEN 32.444.8990