Optum – Oracle Pl/Sql DeveloperRemote6 month contract +Project: Healthplex Data Center Migration And Support:Healthplex Oracle Database that services the entire company. This Database functions as all the data for our entire membership and vendors. All the current Healthplex Applications are getting migrated from HPLX infrastructure to Optum infrastructure.
As part of this project we are working on migration all the DB components (tables/index/store procedure/functions) and jobs to run day to day business.ResponsibilitiesKnowledge in healthcare experience with Center for Medicaid/Medicare systems standards and codes such as EDI 837, EDI 834, ICD codes, HIPPA etStrong experience in Oracle PL/SQLSolid understanding of key concepts, such as normalization, inheritance, triggers, procedures, functions, and cursorsDesign/code PL/SQL packages/procedures or functions as per the requirementModify existing packages/procedures/functions as per the requirementPerformance tuning - tune existing SQL queries or PL/SQL code for better performance (mostly in projects with both development & support)Unit testingCode migration to higher environments.Requirements1. Knowledge in healthcare experience with Center for Medicaid/Medicare systems standards and codes such as EDI 837, EDI 834, ICD codes, HIPPA et2. Strong experience in Oracle PL/SQL3.
Solid understanding of key concepts, such as normalization, inheritance, triggers, procedures, functions, and cursors