Data Architect / Oracle Data Specialist (PL/SQL & DBMS)(10580207)

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

Location: Amsterdam, Netherlands
Start Date: ASAP
Duration: 6 Months
Experience: 8–10 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

• 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