Oracle Expert (Assessment & Discovery)

Context: Oracle data archiving initiative ahead of an Oracle HCM decommissioning, run in parallel with an HR/Payroll migration to a new live system. The role spans the full project lifecycle from discovery through cutover.

Key responsibilities:

Discovery phase — collect and validate existing Oracle documentation (expect it to be incomplete/unreliable; treat as a starting point only); build a full inventory of Oracle tables, views, custom schemas, stored procedures, and data domains; produce the formal inventory sign-off document.

Query and extractor assessment — analyze existing Oracle queries and extraction logic already built for other purposes; determine which can be reused as-is, which require adaptation, and which must be rebuilt from scratch to meet raw archiving requirements; document rationale and recommendations for each case.

Gap analysis — cross-reference the inventory against existing data extractors to identify what is already covered versus what requires new extraction logic; confirm and document where existing extractors apply transformations unsuitable for raw archiving; estimate complexity of uncovered data (table count × customization level) and produce the formal mapping document.

Technical design support — provide Oracle-side input into the extraction/ingestion architecture; validate that redesigned and net-new extractors correctly reflect Oracle schema and business logic.

Ingestion support — serve as the Oracle reference during data ingestion, resolving questions on data structures, custom logic, and edge cases as pipelines are built and Bronze-layer reconciliation is performed.

Client engagement — act as a client-facing point of contact for Oracle-related topics; participate in working sessions, present findings (inventory, gap analysis, query reuse recommendations) directly to client stakeholders, and support decision-making discussions on scope and technical trade-offs.

Required skills: deep knowledge of Oracle Applications (EBS) and Oracle Database, including custom schemas and stored procedures typical of enterprise HR/Payroll environments; strong SQL/PLSQL proficiency to read, evaluate, and assess reusability of existing Oracle queries and extraction logic; experience in data discovery/reverse engineering on legacy Oracle systems with incomplete documentation; familiarity with HR, Payroll, Benefits, Compensation, and Time modules; ability to produce formal technical documentation (inventory, mapping, reuse assessments) usable as sign-off gates; strong communication and presentation skills for direct client interaction; prior exposure to large-scale data migration projects is a plus.