Oracle Expert (Assessment & Discovery
sam k
Role: Oracle Expert (Assessment & Discovery)
Rate: $50-60/hour
Engagement duration: August 2026 through March 2027, covering discovery, technical design, ingestion, validation, and cutover.
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.