HiringCafe
📋 External Recruiting Agencies

PROSTAFF is a recruitment and staffing agency that places candidates (freelancers, contractors, and permanent staff) with various client companies, as explicitly stated in their own business description and job postings.

This company was flagged and excluded from default search results. Proceed with caution.

Save Job
Posted 1w ago

Senior Database Engineer / Database Architect (PostgreSQL Migration)

@ PROSTAFF Schweiz GmbH
View All Jobs
Bern, Canton of Bern, Switzerland
OnsiteFull Time
Responsibilities:advising migration, planning migrations, optimising performance
Requirements Summary:8–10+ years as a database engineer/architect, strong PostgreSQL expertise, proven Microsoft SQL Server→PostgreSQL migration experience, query tuning, HA/DR, backup/recovery, sizing, and consulting skills.
Technical Tools Mentioned:Microsoft SQL Server, PostgreSQL
Save
Mark Applied
Hide Job
Report & Hide
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