StellenbeschreibungppbLocation: /b Basel, Switzerland /p pbContract Duration: /b 3 years, with possible extension /p pbExperience: /b 3+ years /p pbIndustry Experience: /b Utilities Energy (Energie Wasserversorgung, Telecommunications, Banking Financial Services, Information Technology Services) /p h3Role Overview /h3 pWe 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. /p h3Strategic Scope /h3 pDesign, optimize, and secure complex distributed database systems, cross‑platform storage models, high‑volume transactional data nodes, and relational enterprise schemas. /p h3Core Responsibilities /h3 ul liSizing Deployment Modeling: Define, size, and deploy database resource parameters, hardware profiles, memory buffers, and disk alignment configurations for massive transactional databases. /li liData Modeling Advisory: Advise internal software developers on advanced data modeling, data types, indexing strategies, constraint design, and structural schema partitioning. /li liHigh‑Availability Planning: Define, build, and audit database high‑availability configurations, including automated failover mirroring, replication topologies, and disaster recovery runbooks. /li liTuning Execution Profiling: Diagnose slow execution blocks, optimize complex storage procedures, nested views, deadlocks, and relational analytical queries. /li liMigration Upgrades Engineering: Plan, script, and execute critical database schema updates, high‑version data migrations, and database patch deployments with minimal system downtime. /li /ul h3Required Skills Experience /h3 ul li3 to 5+ years of hands‑on experience in Microsoft SQL Server database administration, engineering, or enterprise architecture. /li liStrong experience with SQL Server platform sizing, deployment modeling, resource planning, memory configuration, storage design, and performance‑oriented database setup. /li liGood knowledge of data modeling, schema design, indexing strategies, constraints, data types, partitioning, and relational database design principles. /li liExperience designing, implementing, and maintaining high‑availability and disaster recovery solutions, including failover, mirroring, replication, backup/restore strategies, and DR runbooks. /li liStrong performance tuning experience, including execution plan analysis, stored procedure optimization, deadlock resolution, nested view tuning, and complex query optimization. /li liExperience planning and executing database migrations, version upgrades, schema changes, patch deployments, and production releases with minimal downtime. /li liAbility to advise software development teams on database design, query performance, data integrity, and scalable application‑database interaction patterns. /li liGood understanding of database security, access control, operational monitoring, incident troubleshooting, and enterprise change management practices. /li liAbility to work independently as well as part of a distributed project team. /li libLanguages: /b 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. /li libSwiss Compliance: /b Must hold EU/EFTA nationality or possess an active, valid Swiss permanent residency/work card (C Permit or unrestricted B/G Permit). /li /ul h3Benefits /h3 ul liOpportunity to work on challenging projects and contribute to the growth of the company. /li liCollaborative and dynamic work environment. /li liProfessional development and growth opportunities. /li liCompetitive salary and benefits package. /li /ul pIf 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. /p /p #J-18808-Ljbffr
