Oracle PL/SQL Developer

Optum – Oracle Pl/Sql Developer

Remote

6 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.

Responsibilities

• Knowledge in healthcare experience with Center for Medicaid/Medicare systems standards and codes such as EDI 837, EDI 834, ICD codes, HIPPA et
• Strong experience in Oracle PL/SQL
• Solid understanding of key concepts, such as normalization, inheritance, triggers, procedures, functions, and cursors
• Design/code PL/SQL packages/procedures or functions as per the requirement
• Modify existing packages/procedures/functions as per the requirement
• Performance tuning - tune existing SQL queries or PL/SQL code for better performance (mostly in projects with both development & support)
• Unit testing
• Code migration to higher environments.

Requirements

1. Knowledge in healthcare experience with Center for Medicaid/Medicare systems standards and codes such as EDI 837, EDI 834, ICD codes, HIPPA et

2. Strong experience in Oracle PL/SQL

3. Solid understanding of key concepts, such as normalization, inheritance, triggers, procedures, functions, and cursors