Donato Technologies Inc
Donato Technologies Inc

Oracle Database Architect with Healthcare Exp

Albany, NY, US • Posted 1 day ago • Updated 1 hour ago
Contract W2
30 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Oracle Database Architect
  • Oracle databases
  • PL/SQL
  • Medical Records
  • Billing
  • Budget
  • Customer Service
  • Database
  • Database Design
  • Database Migration
  • NCPDP
  • Oracle
  • SQL
  • Scripting
  • PeopleSoft
  • Health Care
  • Medicaid
  • Finance
  • Performance Tuning
  • Reporting
  • Regulatory Compliance
  • Stored Procedures
  • Microsoft Exchange
  • Medicare
  • Development Testing

Summary

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.
Duties 
Write queries in PL/SQL; Write database migration scripts to move forward any changes to database structures and data from the Development platform to the QA and Production platforms. Develop scripts for automating support and maintenance; Compare databases on different platforms (Development, QA, Production) for differences in structure and produce database scripts to make the databases the same, structure-wise; Troubleshoot and performance tune database queries; Develop and troubleshoot processes that exchange data with other systems such as Statewide Financial System (SFS); Implement work-arounds on the database side for failed processes in applications while the application side is being fixed; Assist other developers working on database related items; Interact with business users to translate requirements into technical models.
Mandatory Requirements 
  • Experience (15+ Years)
  • Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Requirements 
  • This is an 100% Onsite
  • 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.
  • Resume
  • Copy of Candidate Identification (i.e., driver’s license and/or passport and Visa if applicable)
  • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91097274
  • Position Id: HBITS-08-15035
  • Posted 1 day ago
Contact the job poster
Nikhil Gabriel

Nikhil Gabriel

Techincal Recruiting Manager @ Donato Technologies Inc

View Profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
More jobs at Donato Technologies Inc in Albany, NY