Senior Database Engineer / Database Architect (PostgreSQL Migration)

Prostaff Schweiz Gmbh
Bern, Switzerland
18 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
CHF 156K

Job location

Bern, Switzerland

Tech stack

Databases
Disaster Recovery
PostgreSQL
Microsoft SQL Server
Performance Tuning
Query Optimization
Migration Manager
Standard Sql
SQL Stored Procedures
Backup and Restore
Performance Testing
System Availability
Database Optimization
Database Performance
Database 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, Database Engineer Jobs in Niederhasli Database Engineer Jobs in Muri AG Database Engineer Jobs in Adliswil Database Engineer Jobs in Thalwil Database Engineer Jobs in Grafschaft Database Engineer Jobs in Zürich Database Engineer Jobs in Uitikon Waldegg Database Engineer Jobs in Wädenswil Database Engineer Jobs in Baar Database Engineer Jobs in Spreitenbach Database Engineer Jobs in Regensdorf Database Engineer Jobs in Steinhausen Database Engineer Jobs in Affoltern am Albis Database Engineer Jobs in Zollikon Database Engineer Jobs in Horgen Database Engineer Jobs in Würenlos Database Engineer Jobs in Erlenbach ZH Database Engineer Jobs in Urdorf Database Engineer Jobs in Dietikon Database Engineer Jobs in Schlieren

Requirements

  • 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

About the company

PROSTAFF Schweiz GmbH

Apply for this position