MS SQL Database Platform Architect

ALLPS; Basel; Vor Ort; CHF 140.000 - 190.000; Vollzeit

Benefits dieser Stelle

Competitive salary

Challenging projects

Professional development

Zusammenfassung

ALLPS in Basel, Switzerland, seeks an experienced MS SQL Database Platform Architect for a 3-year contract. You will design, scale, and secure high-availability database architectures across on‑premises, hybrid, and cloud environments, shaping global data protection and migration paths while partnering with IT leadership.

Responsibilities include modeling, tuning, and migrating schemas, with a focus on performance and reliability.

Qualifikationen

• 3–5+ years in MS SQL Server DBA/architecture roles.
• Experience designing high-availability and disaster-recovery solutions.
• Strong data modeling and indexing strategy knowledge.
• Proficient in performance tuning and query optimization.
• Experience across on-premises, hybrid, and cloud environments.

Aufgaben

• Size, deploy, and optimize database resources for large transactional workloads.
• Advise on data modeling, schemas, and partitioning for scalability.
• Design and audit high-availability configurations and DR runbooks.
• Profile and optimize slow queries, indexing, and stored procedures.
• Plan, script, and execute schema updates and migrations with minimal downtime.

Kenntnisse

MS SQL Server

Database architecture

High availability

Performance tuning

Data modeling

Security & compliance

Independent working

Tools

SQL Server Management Studio

Azure/AWS cloud

Disaster recovery planning

Jobbeschreibung

Location: Basel, Switzerland

Contract Duration: 3 years, with possible extension

Experience: 3+ years

Industry Experience: Utilities & Energy (Energie & Wasserversorgung, Telecommunications, Banking & Financial Services, Information Technology & Services)

Role Overview

We are looking for an experienced MS SQL Database Platform Architect to support a long-term enterprise project in Basel. This 3‑year contract role offers the possibility of extension and positions you as the visionary behind our entire data platform. You will design, scale, and secure high‑availability database architectures across on‑premises, hybrid, and cloud environments, defining global standards for data protection, performance tuning frameworks, and infrastructure migration paths while collaborating directly with IT leadership and development teams.

Strategic Scope

Design, optimize, and secure complex distributed database systems, cross‑platform storage models, high‑volume transactional data nodes, and relational enterprise schemas.

Core Responsibilities

• Sizing & Deployment Modeling: Define, size, and deploy database resource parameters, hardware profiles, memory buffers, and disk alignment configurations for massive transactional databases.
• Data Modeling Advisory: Advise internal software developers on advanced data modeling, data types, indexing strategies, constraint design, and structural schema partitioning.
• High‑Availability Planning: Define, build, and audit database high‑availability configurations, including automated failover mirroring, replication topologies, and disaster recovery runbooks.
• Tuning & Execution Profiling: Diagnose slow execution blocks, optimize complex storage procedures, nested views, deadlocks, and relational analytical queries.
• Migration & Upgrades Engineering: Plan, script, and execute critical database schema updates, high‑version data migrations, and database patch deployments with minimal system downtime.

Required Skills & Experience

• 3 to 5+ years of hands‑on experience in Microsoft SQL Server database administration, engineering, or enterprise architecture.
• Strong experience with SQL Server platform sizing, deployment modeling, resource planning, memory configuration, storage design, and performance‑oriented database setup.
• Good knowledge of data modeling, schema design, indexing strategies, constraints, data types, partitioning, and relational database design principles.
• Experience designing, implementing, and maintaining high‑availability and disaster recovery solutions, including failover, mirroring, replication, backup/restore strategies, and DR runbooks.
• Strong performance tuning experience, including execution plan analysis, stored procedure optimization, deadlock resolution, nested view tuning, and complex query optimization.
• Experience planning and executing database migrations, version upgrades, schema changes, patch deployments, and production releases with minimal downtime.
• Ability to advise software development teams on database design, query performance, data integrity, and scalable application‑database interaction patterns.
• Good understanding of database security, access control, operational monitoring, incident troubleshooting, and enterprise change management practices.
• Ability to work independently as well as part of a distributed project team.
• Languages: Flawless bilingual/native‑level business German communications proficiency (C1/C2 level written and spoken). The candidate must present seamlessly in German during the technical panel interview.
• Swiss Compliance: Must hold EU/EFTA nationality or possess an active, valid Swiss permanent residency/work card (C Permit or unrestricted B/G Permit).

Benefits

• Opportunity to work on challenging projects and contribute to the growth of the company.
• Collaborative and dynamic work environment.
• Professional development and growth opportunities.
• Competitive salary and benefits package.

If you are a motivated and experienced MS SQL Database Platform Architect looking for a new challenge, please submit your application, including your resume and a cover letter, to our website. We look forward to hearing from you.