MS SQL Database Platform Architect

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)

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.

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

• 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.

• 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).

• 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.