HBITS: HBITS-08-15035
Expert, Database Architect
30 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week in Albany, NY
--- Project Description ---
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.
--- Day-to-Day Tasks ---
1. Write queries in PL/SQL
2. Write database migration scripts to move forward any changes to database structures and data from the Development platform to the QA and Production platforms.
3. Develop scripts for automating support and maintenance
4. Compare databases on different platforms (Development, QA, Production) for differences in structure and produce database scripts to make the databases the same, structure-wise
5. Troubleshoot and performance tune database queries
6. Develop and troubleshoot processes that exchange data with other systems such as Statewide Financial System (SFS)
7. Implement work-arounds on the database side for failed processes in applications while the application side is being fixed
8. Assist other developers working on database related items
9. Interact with business users to translate requirements into technical models
--- Required Qualifications ---
" 84 months experience building and maintaining Oracle tables that contain
Protected Health Information (PHI) within a 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 cost reporting application that supplies
data for Medicare/Medicaid Cost Reports.
" 36 months experience upgrading legacy Oracle databases to current
supported versions, and splitting up Oracle database instances that contain
schemas for multiple applications into separate Oracle instances, one per
application, while also preserving user accounts and roles and maintaining
any access that was present between database schemas, using data facades
or links.
" 84 months experience doing Oracle performance tuning by reviewing slow
performing SQL and creating partitions, indexes, new table structures or SQL
rewrites to ensure fast data retrieval. This includes regular checks of
application databases for any SQL that is performing full table scans when
accessing data and the implementation of indexes to avoid full table scans.
All of this includes measuring the performance, before and after.
" 84 months experience with Oracle: Database design, PL SQL coding, stored
procedures, packages, indexes, triggers, creating tables, etc.
MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.