HBITS-08-15035-Database Architect-Expert

Knowledge Builders Inc; City of Albany (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Knowledge Builders Inc. is seeking an experienced Database Architect to support the Aid to Localities Fiscal System (ALFS) and related applications.

The role focuses on Oracle database design, PL/SQL development, performance tuning, and data interfaces with systems like PeopleSoft and Medicare/Medicaid cost reporting. You will upgrade legacy databases, split schemas per application, implement efficient indexing, and ensure PHI data protection in health care environments while collaborating with

Qualifications

• 36 months experience upgrading legacy Oracle databases to current supported versions.
• 84 months experience Oracle performance tuning and indexing to avoid full table scans.
• 84 months experience with Oracle database design, PL/SQL coding and stored procedures.
• 84 months experience building Oracle tables containing PHI in health care.
• 84 months experience creating tables with complex government financial data (> $2B budgets).
• 84 months experience maintaining Medicare D billing systems and NCPDP transactions.
• 60 months experience designing data interfaces to PeopleSoft financials.
• 60 months experience with cost reporting applications for Medicare/Medicaid.

Responsibilities

• Write queries in PL/SQL.
• Collaborate with clients to translate requirements into technical models.
• Assist other developers on database related items.
• Troubleshoot and optimize database performance.

Skills

PL/SQL

Oracle performance tuning

Oracle database design

Data modelling

Data interfaces

Tools

Oracle

PeopleSoft

NCPDP

Job description

Project/Program:

Aid to Localities Fiscal System (ALFS); Client Worker Payroll (CWP); Oracle Cost Reporting Application (OCRA); MHARS Enhancement and Transformation (MET).

Job Description

Project/Program:

Aid to Localities Fiscal System (ALFS); Client Worker Payroll (CWP); Oracle Cost Reporting Application (OCRA); MHARS Enhancement and Transformation (MET).

ALFS:

used to develop a budget, allocate funds, disburse payments and ensure that funds are expended in compliance with existing laws, regulations and guidelines. OCRA – provides cost reporting information to Medicare & Medicaid.

CWP:

Allows for patients to become employed at OMH psych centers and tracks rosters, hours worked, payments, etc. MET – A rewrite of OMH’s MHARS electronic medical record system.

Day-to-day Tasks

Daily Tasks will include but are not limited to the following:

• Write queries in PL/SQL.
• Write database migration scripts to move forward any changes to database structures and data from the Development platform to the QA and Production platforms. Develop scripts for automating support and maintenance.
• 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 database queries.
• Develop and troubleshoot processes that exchange data with other systems such as Statewide Financial System (SFS.
• Implement workarounds 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.

Mandatory Qualifications

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.

Requested Qualifications

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

We provide equal employment opportunity for all applicants and employees regardless of race, color, sex, gender identity, gender expression, religion, age, national origin, citizenship, disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military/veteran status, or any other protected basis.