MS SQL Database Platform Architect

Location: Basel, Switzerland

Contract Duration: 3 years, with possible extension

Experience Required: 3+ years.

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

We are looking for an experienced MS SQL Database Platform Architect to support a long-term enterprise project in Basel. This is a 3-year contract role with the possibility of extension.

In this strategic position, you will be the visionary brain behind our entire data platform. You will design, scale, and secure high-availability database architectures across on-premises, hybrid, and cloud environments. You will define global standards for data protection, performance tuning frameworks, and infrastructure migration paths, 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.

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

• Minimum of 3 to 5+ years of hands-on experience in Microsoft SQL Server database administration, database engineering, or enterprise database architecture.
• Strong experience with SQL Server platform sizing, deployment modelling, resource planning, memory configuration, storage design and performance-oriented database setup.
• Good knowledge of data modelling, 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 optimisation, deadlock resolution, nested view tuning and complex query optimisation.
• 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) is required. The candidate must present seamlessly in German during the technical panel interview (Anbieterfachgespräch).
• Swiss Compliance : Must hold EU/EFTA nationality or possess an active, valid Swiss permanent residency/work card (C Permit or unrestricted B/G Permit).

**What We Offer:**

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

Recruitment Process – AI Screening with TARA

• As part of our recruitment process, candidates may be invited to complete an initial AI-powered screening with TARA, the ALLPS.AI interview agent.
• TARA helps us make the hiring process faster, fairer, and more consistent by asking structured, role-relevant questions based on the job requirements. The interview is designed to understand your experience, skills, motivation, and suitability for the role.
• The AI screening interview may include:
• Questions about your professional background and relevant experience
• Role-specific technical or functional questions
• Questions about your motivation, availability, and communication skills
• The interview can usually be completed online in 15-20 minutes at a time that is convenient for you. Your responses will be reviewed as part of the overall selection process, together with your CV, application details, and any follow-up interviews with the hiring team.
• Candidate Experience.:
• We use AI to support the recruitment process, but final hiring decisions are made by people. Human recruiters and hiring managers remain involved in reviewing candidates and making selection decisions.
• We are committed to a transparent, respectful, and fair candidate experience. Your data will be handled confidentially and in accordance with applicable data protection requirements.
• 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.