Quick overview
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
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- ME
Full Stack Java DeveloperRecently posted
Menzo · Tampa, FL · On-site · Posted 20 Nov 2026 🇺🇸
DockerMicroservicesMySQL+26TechnologySalary not listed - CB
Salesforce DeveloperRecently posted
Code Beacons Inc · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
ScrumJavaREST+2TechnologySalary not listed - IT

CXone Lead Developer – NICE CXone (Onshore)Recently posted
Ideate Technologies LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
Stakeholder ManagementRESTSOAP+2Technology$55/hr - AG

Zendesk / OTSM DeveloperRecently posted
ASCII Group LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLETLJava+2TechnologySalary not listed - DD

Full Stack EngineerRecently posted
Dexian DISYS · Westlake, TX · Hybrid · Posted 20 Nov 2026 🇺🇸
DynamoDBAWSAngular+5TechnologySalary not listed - AP
Full Stack Java Developer Remote OpportunityRecently posted
Apolis · Salt Lake City, UT · Remote · Posted 20 Nov 2026 🇺🇸
MySQLPHPSQL+14TechnologySalary not listed - DS
Salesforce Developer/ ArchitectRecently posted
Digitek Software, Inc. · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
ScrumJavaREST+2TechnologySalary not listed - AI
React /. Net Full Stack Developer with Security ClearanceRecently posted
Applied Information Sciences · Washington, DC · Hybrid · Posted 20 Nov 2026 🇺🇸
DockerSQLGit+17Technology$100k - $150k/yr - OT
Senior SAP ABAP Techno-Functional Developer (Finance)Recently posted
OnwardPath Technology Solutions LLC · Houston, TX · On-site · Posted 20 Nov 2026 🇺🇸
SQLTechnologySalary not listed - LT

Senior Mainframe full stack DeveloperRecently posted
Lorven Technologies, Inc. · Jersey City, NJ · Hybrid · Posted 20 Nov 2026 🇺🇸
COBOLAgileTechnologySalary not listed - PS

Full Stack Java DeveloperRecently posted
Prismagic Solutions Inc · Salt Lake City, UT · On-site · Posted 20 Nov 2026 🇺🇸
MySQLPHPSQL+15TechnologySalary not listed - ZI
Full stack DeveloperRecently posted
Ziddos · Pleasanton, CA · On-site · Posted 20 Nov 2026 🇺🇸
DockerMongoDBMySQL+11TechnologySalary not listed
