Senior Database Engineer / Database Architect (PostgreSQL Migration)
Senior Database Engineer / Database Architect (PostgreSQL Migration)
Senior Database Engineer / Database Architect (PostgreSQL Migration)
Senior Database Engineer / Database Architect (PostgreSQL Migration)
PROSTAFF Schweiz GmbH
Information services
Bern
- Art der Beschäftigung: Full-time
- 120.500 CHF – 156.000 CHF (von XING geschätzt)
- Vor Ort
Senior Database Engineer / Database Architect (PostgreSQL Migration)
Über diesen Job
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