Oracle Database Architect (Healthcare)

Trigyn; City of Albany (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

Trigyn Technologies Limited is seeking a senior Oracle DBA to write PL/SQL queries and develop migration scripts moving changes from Development to QA and Production. You will compare databases across environments, tune performance, and implement data exchanges with the Statewide Financial System (SFS).

You will assist developers, translate business requirements into technical models, and ensure secure handling of PHI within healthcare data in a government-scale environment.

Qualifications

• Determines database structural requirements by analyzing client operations and applications.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Ability to guide large teams and/or has extensive industry experience.
• 36 months experience upgrading legacy Oracle databases and splitting schemas into separate instances.
• 84 months experience Oracle performance tuning with indexing and partition strategies.
• 84 months experience with Oracle database design, PL/SQL coding, and related objects.
• 84 months experience maintaining Oracle PHI data in healthcare environments.
• 84 months experience handling government financial data (budgets, encumbrances, payments).
• 84 months experience maintaining Medicare D billing systems including NCPDP transactions.
• 60 months experience designing data interfaces to PeopleSoft financial systems.
• 60 months experience on cost reporting applications for Medicare/Medicaid.

Responsibilities

• Write queries in PL/SQL and develop scripts to migrate database changes to QA/Production.
• Develop automation scripts for support and maintenance.
• Compare databases across Development, QA, and Production for differences and harmonize structures.
• Troubleshoot and tune database queries for performance improvements.
• Develop and troubleshoot processes exchanging data with SFS and other systems.
• Implement workarounds on the database side while applications are fixed.
• Assist other developers on database related items.
• Interact with business users to translate requirements into technical models.

Skills

Oracle performance tuning

PL/SQL coding

Data migration

Database troubleshooting

SQL optimization

Requirements translation

Tools

Oracle

PeopleSoft

NCPDP transactions

Job description

Description

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

Mandatory Qualification

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

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.