Senior Database Engineer / Database Architect (PostgreSQL Migration)

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

PROSTAFF vermittelt und besetzt Informatik- und Data Science-Projekte in der Schweiz mit Freiberuflern, Freelancern, Contractors und temporären Mitarbeitern.