Other

Database Architect

Bits & Bytes Technology SolutionsAlbany, NY🇺🇸United States

Why this role stands out

This role offers an exciting opportunity to architect and implement advanced automation and data processing solutions for a prominent client, fostering significant skills development in a dynamic environment. You'll thrive here if you're an expert-level Database Architect passionate about optimizing complex systems and driving impactful integrations, with the flexibility of a hybrid work model. This position is ideal for someone eager to contribute to large-scale projects and grow within a reputable organization.

Quick overview

SeniorityMid Senior

Work modeHybrid

LocationAlbany, NY, United States

OraclePL/SQLSQLPeopleSoft

Job description

Legacy Oracle Upgrades & Splitting: 36 months experience upgrading legacy Oracle databases to currently supported versions, splitting multi-application Oracle instances into separate application instances, and preserving user accounts/roles/access using data facades or links.
Oracle Performance Tuning: 84 months experience reviewing slow-performing SQL, creating partitions, indexes, new table structures, or SQL rewrites, and eliminating full table scans.
Oracle Core Design & Coding: 84 months experience with Oracle database design, PL/SQL coding, stored procedures, packages, indexes, triggers, and table creation.
Protected Health Information (PHI): 84 months experience building and maintaining Oracle tables containing PHI within a healthcare environment.
Government Financial Data: 84 months experience creating and maintaining Oracle database tables containing complex government financial data (budgets, encumbrances, payments) within a government organization with an affected budget of $2 billion or more.
Medicare D Billing System: 84 months experience maintaining/supporting a Medicare D billing system, including creating and maintaining NCPDP transactions such as B1, B2, B3, & E1.
PeopleSoft Financial Interfaces: 60 months experience designing, building, and maintaining data interfaces to PeopleSoft financial systems.
Cost Reporting Applications: 60 months experience working on a cost reporting application supplying data for Medicare/Medicaid Cost Reports.