MVP Consulting Plus Jobs

HBITS-05-13397

Daily tasks will include:

• 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

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.

Expert 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

1. 84 months experience ensuring the soundness of the architecture and security of Oracle databases for multiple applications in Production/Quality Assurance/Development environments.
2. 84 months experience creating Oracle schema objects and reviewing developers work to ensure they meet industry and in-house standards for multiple applications.
3. 84 months experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc.
4. 84 months experience building and maintaining Oracle tables that contain Protected Health Information (PHI) within a large health care environment.
5. 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.
6. 84 months experience maintaining/supporting a Medicare D billing system including the creation and maintenance of NCPDP transactions such as B1, B2, B3, & E1.
7. 60 months experience designing, building and maintaining data interfaces to Peoplesoft financial systems.
8. 60 months experience working on a complex cost reporting application that supplies data for Medicare/Medicaid Cost Reports