PostgreSQL Database Architect

Project overview

For a migration project in the healthcare sector, converting an existing Sybase ASE environment to PostgreSQL, you will perform the following tasks:

Profile of the suited interim professional:

• Designing the target architecture on PostgreSQL and monitoring performance and scalability.
• Translating and redesigning complex Sybase T-SQL patterns to PostgreSQL.
• Optimizing performance through indexing, query tuning, and partitioning.
• Developing data validation and quality controls to prevent data loss.
• Supporting the cutover and migration strategy.
• Acting as Subject Matter Expert for the team.
• Setting up automation for database management and monitoring.
• Assisting with the existing Sybase environment during the transition.
• Several years of experience as a Database Architect or Senior DBA.
• Thorough knowledge of PostgreSQL, focused on design, tuning, and optimization.
• Experience with large-scale database migrations and legacy environments.
• Experience with SQL dialect conversion from Sybase to PostgreSQL.
• Experience with performance tuning and optimizing queries.
• Experience with database management and automation.
• Knowledge of Linux/Unix and scripting, such as shell, tuning, and automation.
• Knowledge of PostgreSQL extensions such as pg_logical and pg_vector is recommended.
• Knowledge of AlloyDB is recommended.
• Knowledge of Java environments is recommended.
• Experience with Sybase ASE is a plus, but not a must.
• Willingness to participate in an on-call service later.
• Fluent command of Dutch and English.

Project details

• Start: flexible
• Location: Leuven, Flemish Brabant, Brussels, BE
• Languages: Dutch, English