Overview
We are supporting a recruitment process for a highly relevant International Organization based in Brussels, Belgium, under a hybrid working scheme. We are seeking a Database Architect to lead a strategic database migration project.
Important requirement: EU citizenship
Project: Oracle to PostgreSQL Database Migration
Responsibilities
* Lead end-to-end migration of databases from Oracle to PostgreSQL.
* Design and implement PostgreSQL-optimized database architectures and schemas.
* Analyze existing Oracle database structures, stored procedures, and performance.
* Develop and execute migration scripts, ETL processes, and validation routines.
* Optimize PostgreSQL configurations on RHEL for performance and reliability.
* Collaborate with DevOps and infrastructure teams to ensure seamless deployment and integration.
* Provide technical guidance and documentation on database standards and best practices.
* Troubleshoot and resolve database-related issues during and after migration.
Qualifications
* Proven experience in Oracle to PostgreSQL database migration.
* Deep knowledge of PostgreSQL internals, performance tuning, and advanced features.
* Hands-on experience with Linux systems (preferably RHEL).
* Proficiency in SQL, PL/pgSQL, and PL/SQL.
* Experience with tools like Ora2Pg, pgloader, or custom migration frameworks.
* Strong background in data modeling, schema design, and ETL processes.
* Excellent problem-solving and communication skills.
* Mandatory: European citizenship and residence in Brussels, Belgium.
Nice to have
* PostgreSQL or Oracle certifications.
* Experience with cloud-based PostgreSQL deployments (AWS RDS, Azure Database for PostgreSQL).
* Familiarity with CI/CD pipelines and containerization (Docker, Kubernetes).
* Knowledge of security and compliance standards in database environments.
Additional information
* Seniority level: Mid-Senior level
* Employment type: Full-time
* Job function: Information Technology
* Industries: Government Administration and Public Policy Offices
Referrals increase your chances of interviewing at HR Partners by 2x
Get notified about new Database Architect jobs in Brussels Region, Belgium.
#J-18808-Ljbffr