Job Description

Job Title: Data Architect / Oracle Data Specialist (PL/SQL & DBMS)

Location: Amsterdam, Netherlands
Start Date: ASAP
Duration: 6 Months
Experience: 8–10 Years

We are seeking an experienced Data Architect / Oracle Data Specialist with strong expertise in PL/SQL, database administration, and data governance The ideal candidate will be responsible for analyzing existing Oracle environments, designing robust data models, and driving data governance, migration, and integration strategies in a complex enterprise landscape.

Key Responsibilities

1. Inventory & Documentation

• 
  Map all existing systems and databases (Oracle and related platforms)
• 
  Document data flows, dependencies, and system relationships
• 
  Establish and maintain a source catalogue and metadata repository

2. Reverse Engineering & Data Modeling

• 
  Analyze Oracle schemas and Entity Relationship Diagrams (ERDs)
• 
  Identify tables, views, PK/FK relationships, triggers, and packages
• 
  Design conceptual, logical, and physical data models
• 
  Document reference and master data structures

3. Data Profiling & Data Quality Management

• 
  Perform data profiling across source systems
• 
  Define and implement data quality reports (completeness, consistency, duplicates)
• 
  Recommend data cleansing, normalization, and performance improvements

4. Data Governance, Privacy & Compliance

• 
  Design data governance frameworks and processes
• 
  Ensure compliance with regulations such as AVG/GDPR and BIO
• 
  Define retention policies and anonymization guidelines
• 
  Advise on encryption, key management, and role-based access control

5. Migration & Integration Design

• 
  Design logical data models and mapping from source to target systems
• 
  Define migration strategies (phased rollout, dry runs, validation)
• 
  Design integration strategies including API-driven platforms
• 
  Collaborate with Data Engineers on ETL/ELT processes
• 
  Ensure data quality, compliance, and performance during migration

6. Architecture & Innovation

• 
  Define and promote data architecture principles (Data Vault, Dimensional Modeling, Data Mesh)
• 
  Support integration with APIs and streaming technologies (Kafka, Oracle GoldenGate)
• 
  Contribute to cloud migration initiatives (Azure, AWS, GCP)
• 
  Support design of modern data lakehouse architectures

Required Skills & Experience

• 
  8–10 years of experience in Data Architecture, Database Administration, or related field
• 
  Strong expertise in Oracle databases, PL/SQL, and DBMS administration
• 
  Experience with:
  • 
    Data modeling (conceptual, logical, physical)
  • 
    Data profiling and data quality management
  • 
    Reverse engineering of complex database systems
  • 
    Data governance and compliance frameworks (GDPR/AVG, BIO)
  • 
    ETL/ELT processes and integration design
• 
  Strong analytical and documentation skills
• 
  Experience working with large-scale enterprise data environments

Preferred Skills

• 
  Experience with cloud platforms (Azure, AWS, or GCP)
• 
  Knowledge of Kafka, Oracle GoldenGate, or streaming architectures
• 
  Familiarity with modern data architecture patterns (Data Mesh, Data Vault)
• 
  Strong stakeholder communication and advisory skills

Languages

• 
  Dutch (preferred)
• 
  English (required)

Education

• 
  Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or related field

Additional Information

• 
  Onsite role in Amsterdam
• 
  Immediate start preferred
• 
  Opportunity to work on enterprise-scale data modernization and governance programs