Senior Database Engineer / Database Architect (PostgreSQL Migration)

Job description

For our client in the telecommunications sector, we are looking for an experienced Senior Database Engineer / Database Architect to support a strategic database migration from Microsoft SQL Server to PostgreSQL. The role focuses on database architecture, migration planning, performance optimisation and technical consulting within a complex enterprise environment. The consultant will work closely with architecture, development and operations teams and support the full migration lifecycle from assessment to implementation and knowledge transfer. Advise and support the migration from Microsoft SQL Server to PostgreSQL Define and review target architectures for PostgreSQL-based environments Analyse existing database landscapes, data models and workloads Plan and execute database migrations, including migration strategy and cutover concepts Assess and optimise database performance, query tuning and resource consumption Conduct sizing, capacity and scalability analyses Advise on high availability, disaster recovery, backup and restore strategies Support the migration of database objects such as stored procedures, views, functions and triggers Identify SQL Server-specific dependencies and define suitable PostgreSQL target implementations Support test concepts, migration testing and performance testing Create technical documentation, guidelines and best practices Transfer knowledge to internal teams and operational units Based in Switzerland, with work performed exclusively in Switzerland At least 8–10 years of experience as a Database Engineer, Database Architect or DBA Several years of hands-on experience with PostgreSQL in enterprise environments Proven project experience in migrations from Microsoft SQL Server to PostgreSQL Strong knowledge of PostgreSQL architecture and internals Strong experience in query optimisation and performance tuning Good knowledge of indexing strategies and partitioning Experience with high availability and replication concepts Strong understanding of backup and recovery concepts Experience with capacity planning, sizing and scalability assessments Very good SQL skills Experience with migration tools and database assessment methods Ability to identify technical risks early and propose suitable mitigation measures Very good communication and consulting skills