Database Architect – Sybase to PostgreSQL Migration
Il y a 4 jours
Leuven, Flanders, Belgique
Cloud Power Luxembourg
Temps plein
Gratuit avec email ou Google
Enregistrez cette offre et organisez votre recherche
Créez un compte gratuit pour enregistrer des offres d'emploi, créer des alertes et revenir à cette liste depuis votre tableau de bord.
Gratuit avec email ou Google
En continuant, vous acceptez nos Conditions d’utilisation & Politique de confidentialité.
As part of a strategic IT infrastructure modernisation programme, our client is looking for an experienced Database Architect to support a large-scale database migration project from Sybase ASE to PostgreSQL.
The project involves a highly critical, large-scale database environment containing several terabytes of data and supporting business-critical applications.
The main objective is to modernise the existing infrastructure while ensuring optimal performance, availability, stability and scalability.
Your Role
As a Database Architect, you will play a key role in defining and implementing the target PostgreSQL architecture.
You will combine architectural expertise, hands-on technical skills and team guidance to ensure the successful delivery of this complex migration project.
You will be responsible for designing, optimising and evolving the new PostgreSQL environment while ensuring business continuity throughout the transition from the existing Sybase infrastructure.
Key Responsibilities
• Design and define the target PostgreSQL architecture, ensuring performance, availability and scalability.
• Analyse, translate and redesign complex Sybase T-SQL queries and database mechanisms for PostgreSQL.
• Optimise database performance through indexing, partitioning, query tuning and SQL optimisation.
• Define and implement data validation strategies and quality controls to ensure data integrity and prevent data loss.
• Contribute to the migration strategy and cutover planning and execution.
• Act as the technical Subject Matter Expert (SME) and provide guidance to the project team.
• Develop automation solutions for database administration, maintenance and monitoring.
• Provide support and optimisation for the existing Sybase environment throughout the migration.
• Share technical expertise and support the development of the team's capabilities. Required Skills & Experience
• Proven experience as a Database Architect or Senior Database Administrator (DBA).
• Strong expertise in PostgreSQL, including architecture, administration, database design and performance optimisation.
• Significant experience in large-scale database migration projects.
• Good understanding of legacy database environments and modernisation challenges.
• Experience in SQL dialect conversion, ideally from Sybase T-SQL to PostgreSQL.
• Strong background in database performance tuning and query optimisation.
• Good knowledge of Linux/Unix environments and Shell scripting.
• Experience in database administration and automation.
• Knowledge of PostgreSQL extensions such as pg_logical and pg_vector is a plus.
• Familiarity with AlloyDB and Java environments is an additional advantage.
• Experience with Sybase ASE is beneficial but not mandatory, provided you are willing to develop your knowledge of the technology. Soft Skills
• Strong analytical and problem-solving skills.
• Pragmatic, proactive and results-oriented mindset.
• Hands-on approach, combining architectural vision with technical implementation.
• Excellent communication and collaboration skills.
• Team player with the ability to work independently. Practical Information
• Start date: ASAP.
• Languages: Dutch and English.
• Availability: Occasional participation in on-call duties or out-of-hours maintenance activities may be required.
Key Responsibilities
• Design and define the target PostgreSQL architecture, ensuring performance, availability and scalability.
• Analyse, translate and redesign complex Sybase T-SQL queries and database mechanisms for PostgreSQL.
• Optimise database performance through indexing, partitioning, query tuning and SQL optimisation.
• Define and implement data validation strategies and quality controls to ensure data integrity and prevent data loss.
• Contribute to the migration strategy and cutover planning and execution.
• Act as the technical Subject Matter Expert (SME) and provide guidance to the project team.
• Develop automation solutions for database administration, maintenance and monitoring.
• Provide support and optimisation for the existing Sybase environment throughout the migration.
• Share technical expertise and support the development of the team's capabilities. Required Skills & Experience
• Proven experience as a Database Architect or Senior Database Administrator (DBA).
• Strong expertise in PostgreSQL, including architecture, administration, database design and performance optimisation.
• Significant experience in large-scale database migration projects.
• Good understanding of legacy database environments and modernisation challenges.
• Experience in SQL dialect conversion, ideally from Sybase T-SQL to PostgreSQL.
• Strong background in database performance tuning and query optimisation.
• Good knowledge of Linux/Unix environments and Shell scripting.
• Experience in database administration and automation.
• Knowledge of PostgreSQL extensions such as pg_logical and pg_vector is a plus.
• Familiarity with AlloyDB and Java environments is an additional advantage.
• Experience with Sybase ASE is beneficial but not mandatory, provided you are willing to develop your knowledge of the technology. Soft Skills
• Strong analytical and problem-solving skills.
• Pragmatic, proactive and results-oriented mindset.
• Hands-on approach, combining architectural vision with technical implementation.
• Excellent communication and collaboration skills.
• Team player with the ability to work independently. Practical Information
• Start date: ASAP.
• Languages: Dutch and English.
• Availability: Occasional participation in on-call duties or out-of-hours maintenance activities may be required.