| Oracle Database Architect (State Exp and Healthcare Exp) at Oracle, Arizona, USA |
| Email: [email protected] |
| From: Abhijith, Sligosoft [email protected] Reply to: [email protected] Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have an urgent requirement for Oracle Database Architect position with our client. Role: Oracle Database Architect Location: Albany, New York Duration: 30 Months Job ID: HBITS-05-13397 Client: NY State 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 centres and tracks rosters, hours worked, payments, etc. MET: A rewrite of OMHs 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. Keywords: quality analyst information technology procedural language Idaho New York Oracle Database Architect (State Exp and Healthcare Exp) [email protected] |
| [email protected] View all |
| Wed May 01 18:33:00 UTC 2024 |