MS SQL Platform Architect — Basel (3-Year Contract)

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

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.