Database Architect

We are looking for a Database Architect to help migrate a business-critical database environment from Sybase ASE to PostgreSQL. The work supports the modernisation and scalability of electronic patient record systems, with performance and stability throughout the transition at its core.

Your role

• Design the target PostgreSQL architecture and safeguard performance and scalability.
• Translate and redesign complex Sybase T-SQL patterns for PostgreSQL.
• Optimise indexing, queries and partitioning.
• Define data validation and quality checks to prevent data loss.
• Support the migration and cutover strategy.
• Act as a subject matter expert and coach the team.
• Automate database administration and monitoring.
• Help support the existing Sybase environment during the transition.
• Occasionally take part in on-call or out-of-hours maintenance.

A plus

• Ten years of experience as a Database Architect or Senior DBA.
• In-depth PostgreSQL design, tuning and optimisation expertise.
• Experience in database administration.
• Experience in database automation.
• Experience with large-scale database migrations.
• Experience with legacy environments.
• Experience converting SQL dialects from Sybase to PostgreSQL.
• Experience in database performance tuning.
• Experience in query optimisation.
• Knowledge of Linux or Unix.
• Knowledge of shell scripting.
• Knowledge of PostgreSQL extensions, such as pg_logical or pg_vector.
• Knowledge of AlloyDB.
• Knowledge of Java environments.
• Experience with Sybase ASE.
• Dutch at C2 level.
• English at C2 level.
• Strong analytical skills.
• Strong problem-solving skills.
• A hands-on approach.
• A pragmatic approach.
• Strong communication skills.
• An ability to work in a team.
• An ability to work independently.