Quick overview
Job description
Hello,
Urgently hiring for the below contract role with New York State (Direct client).
Job Title: Oracle Database Developer | Sr Database Architect
Job ID: HBITS-08-15035
Location: 44 Holland Avenue, Albany, NY 12229 (Hybrid role)
Duration: 30 months
Client / Dept.: New York State Office of Mental Health
WebEx (video call) interview needed
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.
Similar jobs
- CI

Credit Trading Tool Developer - CitiRecently posted
Citi · New York, NY · On-site · Posted 17 Nov 2026 🇺🇸
DockerHelmJava+4Technology$95.8k - $133.6k/yr - HC
Java Full Stack Solution ArchitectRecently posted
HCLTech · Charlotte, NC · Hybrid · Posted 17 Nov 2026 🇺🇸
DockerMicroservicesOracle+22Technology$155k/yr - LA
Senior Integration Developer-EDIRecently posted
LetitBeX AI Tech Solutions LLC · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
TechnologySalary not listed - BA

Palantir Foundry Developer with Security ClearanceRecently posted
Booz Allen Hamilton · Atlanta, GA · On-site · Posted 17 Nov 2026 🇺🇸
GitIoTPython+3Technology$77.5k - $176k/yr - QT

Cloud DeveloperRecently posted
QUANTUM TECHNOLOGIES LLC · Berkeley Heights, NJ · Hybrid · Posted 16 Nov 2026 🇺🇸
DockerMicroservicesSQL+19Technology$84/hr - CI

Sr Python Developer - VP - CitiRecently posted
Citi · Tampa, FL · Hybrid · Posted 17 Nov 2026 🇺🇸
MySQLOracleSQL+8Technology$113.8k - $170.8k/yr - ZP

Senior Java Developer with Security ClearanceRecently posted
Zachary Piper Solutions, LLC · Colorado Springs, CO · On-site · Posted 16 Nov 2026 🇺🇸
SAFeSpringGit+10Technology$130k - $150k/yr - AP

Applications Developer with Security ClearanceRecently posted
Ardent Principles, Inc. · McLean, VA · On-site · Posted 16 Nov 2026 🇺🇸
SASSGitHTML+8Technology$130k - $260k/yr - FA

UI/UX Developer with Security ClearanceRecently posted
Fantom Corporation · Chantilly, VA · On-site · Posted 16 Nov 2026 🇺🇸
Next.jsHTMLFigma+8TechnologySalary not listed - IN
Mainframe DeveloperRecently posted
Innosoft Corporation · Columbia, SC · Remote · Posted 17 Nov 2026 🇺🇸
COBOLJavaPythonTechnologySalary not listed - KT

Maximo DeveloperRecently posted
Kforce Technology Staffing · Armonk, NY · Hybrid · Posted 16 Nov 2026 🇺🇸
OracleSQLJava+2TechnologySalary not listed - BR

Java DeveloperRecently posted
Blue Rose Technologies LLC · New York, NY · On-site · Posted 16 Nov 2026 🇺🇸
DockerMicroservicesSQL+12TechnologySalary not listed