Data Architect Oracle Data Specialist

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

Location: Amsterdam Netherlands
Start Date: ASAP
Duration: 6 Months
Experience: 810 Years

Job Overview

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

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

• Bachelors or Masters 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