Oracle Database Architect

• 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 centres and tracks rosters, hours worked, payments, etc.
• MET: A rewrite of OMH's MHARS electronic medical record system.

Duties

• Write complex queries in PL/SQL for multiple financial and patient-based applications.
• Write database migration scripts for QA and Production for multiple financial and patient-based applications.
• Develop scripts for automating support and maintenance for multiple financial and patient-based applications.
• 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 complex 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 (12+ Years)
• Database Architect 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
• 84 months experience ensuring the soundness of the architecture and security of Oracle databases for multiple applications in Production/Quality Assurance/Development environments.
• 84 months experience creating Oracle schema objects and reviewing developers work to ensure they meet industry and in-house standards for multiple applications.
• 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, & E1.
• 60 months experience designing, building, and maintaining data interfaces to Peoplesoft financial systems.
• 60 months experience working on a complex cost reporting application that supplies data for Medicare/Medicaid Cost Reports.
• Resume
• Please submit copies of any degrees or certifications.

Thanks,

Abhijith Mallavajhula

Senior Talent Acquisition Specialist

Sligo Software Solutions Inc.

amallavajhula@sligosoft.com

www.sligosoft.com

Direct: (518) 675 7932

Office: (518) 444 0459 x 117

Fax: (518) 444 0457

IMPORTANT NOTICE: This e-mail and any attachments may contain confidential or sensitive information which is, or may be, legally privileged or otherwise protected by law from further disclosure. It is intended only for the addressee. If you received this in error or from someone who was not authorized to send it to you, please do not distribute, copy or use it or any attachments. Please notify the sender immediately by reply e-mail and delete this from your system. Thank you for your cooperation.