Senior DB Architect — PostgreSQL & SQL Server Migrations

Swisslinx AG; Bern; Vor Ort; CHF 120.000 - 180.000; Vollzeit

Zusammenfassung

Swisscom is seeking a Senior ICT Database Engineer to provide technical leadership and hands-on expertise throughout a complex database migration to PostgreSQL. You will collaborate with teams across Switzerland and the Netherlands to help define the target architecture and ensure secure, scalable PostgreSQL environments.

Responsibilities include migrating from SQL Server to PostgreSQL, planning migrations, migrating objects, optimizing performance, sizing, DR planning, and documenting

Qualifikationen

• 8–10+ years in Database Engineer/Architect/DBA
• Hands-on PostgreSQL experience in enterprise environments
• Proven project experience migrating SQL Server databases to PostgreSQL
• Strong knowledge of PostgreSQL architecture and internals
• Advanced expertise in query optimisation, performance tuning and indexing
• Expertise in partitioning, high availability and replication
• Experience designing backup, recovery and disaster-recovery solutions
• Strong capacity-planning, sizing and scalability expertise
• Experience with database migration tools and assessment methodologies
• Strong analytical, conceptual and problem-solving capabilities
• Independent, structured and solution-oriented approach
• Excellent consulting, stakeholder-management and communication skills
• Based in Switzerland, with all services delivered exclusively from Switzerland
• German at C1 level and English at C1 level

Aufgaben

• Advise and support the migration from Microsoft SQL Server to PostgreSQL
• Define and review the target architecture for PostgreSQL-based environments
• Analyse existing database landscapes, data models, dependencies and workloads
• Develop migration strategies, implementation plans and cutover concepts
• Plan and execute database migrations
• Migrate stored procedures, views, functions, triggers and other database objects
• Identify SQL Server‑specific dependencies and design suitable PostgreSQL implementations
• Evaluate and optimise database performance, queries and resource consumption
• Conduct sizing, capacity-planning and scalability assessments
• Advise on high availability, replication, disaster recovery, backup and restore strategies
• Support migration testing, performance testing and test-concept development
• Identify technical risks and recommend appropriate mitigation measures
• Produce technical documentation, architectural guidelines and best practices
• Transfer knowledge to internal engineering and operational teams

Kenntnisse

PostgreSQL expertise

Migration planning

Data modeling

Performance tuning

High availability & replication

Problem solving

Stakeholder management

Communication skills

Ausbildung

University of Applied Sciences degree or equivalent

Tools

SQL Server migration tools

Azure

Kubernetes

Jobbeschreibung

Swisscom is seeking a Senior ICT Database Engineer to provide technical leadership and hands-on expertise throughout a complex database migration to PostgreSQL. You will collaborate with teams across Switzerland and the Netherlands to help define the target architecture and ensure secure, scalable PostgreSQL environments.

Responsibilities include migrating from SQL Server to PostgreSQL, planning migrations, migrating objects, optimizing performance, sizing, DR planning, and documenting