You will join a strategic program where the existing database infrastructure will be migrated from Sybase (ASE) to PostgreSQL. This project is essential for the continued modernization and scalability of the platforms within a healthcare organization. This organization develops and manages an electronic patient file used daily by over 130,000 healthcare professionals. You will thus directly contribute to the digital backbone of Belgian healthcare.
What you will do. As a Database Architect, you will be a key player in this migration and responsible for defining, realizing, and optimizing the new PostgreSQL environment. You will combine architecture, hands-on implementation, and coaching, ensuring that the new environment achieves at least the same performance and stability as the existing Sybase environment.
- Design the target architecture on PostgreSQL and monitor performance and scalability
- Translate and redesign complex Sybase T-SQL patterns to PostgreSQL
- Optimize performance (indexing, query tuning, partitioning, etc.)
- Develop data validation and quality controls to prevent data loss
- Support the cutover and migration strategy
- Act as a Subject Matter Expert (SME) for the team
- Set up automation for database management and monitoring
- Contribute to the support of the existing Sybase environment during the transition
Profile
- Strong experience as a Database Architect / Senior DBA
- In-depth expertise in PostgreSQL (design, tuning, optimization)
- Experience with large-scale database migrations and legacy environments
- Knowledge of PostgreSQL extensions (e.g., pg_logical, pg_vector) is a plus
- Experience with SQL dialect conversion (Sybase? PostgreSQL)
- Experience with performance tuning and query optimization
- Knowledge of Linux/Unix and scripting (shell, tuning, automation)
- Experience with database administration and automation
- Knowledge of Java environments is a plus
- Experience with Sybase ASE is an advantage (not a must, willingness to learn is sufficient)
Soft skills.
- Strong analytical and problem-solving skills
- Hands-on and pragmatic approach
- Strong communication skills
- Team player with an independent mindset
Practical
- Participation in on-call duties or maintenance outside office hours may be occasionally requested
- Candidates are administratively processed via a partner organization, but work on content for the healthcare organization
How to apply
View the full assignment text and application details once your tailored application is ready.
Order a tailored application to view the full assignment and application details.
More context, less searching.
You get enough context to judge whether this job is relevant. The full brief, client details and next steps stay available inside the app.