Oracle DB Pl/SQL PHI Medicare Architect (05275)

Location: ALBANY, NY
Date Posted: 03-02-2018
Oracle DB Pl/SQL PHI Medicare Architect (05275)
 Albany, NY
 24 Months
Job Description: 
1. Write complex queries in PL/SQL for multiple Financial Applications.
2. Participate in daily Scrum meetings to support Agile methodology used for system development on multiple systems.
3. Write migration scripts for QA and Production for multiple Financial Applications.
4. Develop scripts for automating support and maintenance for multiple Financial Applications.
5. Interact with business users to translate requirements into technical models.
1. 84 Months    Demonstrated work experience ensuring the soundness of the architecture and security of Oracle databases for multiple applications in Production/Quality Assurance/Development environments. #OF MONTHS  
2. 84 Months    Demonstrated work experience creating Oracle schema objects and reviewing developers work to ensure they meet industry and in-house standards for multiple applications. #OF MONTHS  
3. 84 months    Demonstrated experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc. #OF MONTHS  
4. 84 months    Demonstrated experience building and maintaining Oracle tables that contain Protected Health Information (PHI) within a large health care environment. #OF MONTHS  
5. 72 months    Demonstrated experience creating and maintaining Oracle database tables containing complex government financial data, specifically budgets, encumbrances, and payments within a large government organization. #OF MONTHS  
6. 72 months   Demonstrated experience maintaining/supporting a Medicare D billing system including the creation and maintenance of NCPDP transactions such as B1, B2, B3, & E1. #OF MONTHS  
7. 48 months    Demonstrated experience designing, building and maintaining data interfaces to Peoplesoft financial systems. #OF MONTHS  
8. 48 Months   Demonstrated experience working on a complex cost reporting application that supplies data for Medicare/Medicaid Cost Reports. #OF MONTHS  
this job portal is powered by CATS