Senior SQL Server Data Platform Architect / Database Architect

Senior SQL Server Data Platform Architect / Database Architect approximately 3 5 months Long Term Contract Assess the current SQL Server landscape, including servers, databases, data volumes, integrations, dependencies, security, and overall architecture. Design and recommend a scalable target-state SQL Server/data platform architecture. Evaluate options including: Database consolidation Centralized reporting databases Data warehouses/data marts Replication ETL/ELT Linked or integrated data sources SQL Server clustering/high availability Develop an approach for moving, synchronizing, or integrating data from existing databases into the target architecture. Design security, access controls, backup/recovery, disaster recovery, availability, and performance-management strategies. Support implementation and configuration of the recommended solution. Develop technical documentation and provide knowledge transfer to the client's internal IT team. Required Experience Senior-level Microsoft SQL Server architecture and administration experience. Strong SQL Server database design and performance-tuning expertise. Experience architecting environments with multiple SQL Server databases/data sources. Strong understanding of data integration, consolidation, and centralized data architecture patterns. Experience with SSIS and/or modern Microsoft data integration technologies. Experience designing reporting/analytics databases, data warehouses, data marts, or other centralized repositories. Strong T-SQL skills, including complex queries across multiple systems. Strong understanding of SQL Server security, backup/recovery, disaster recovery, and high availability. Demonstrated experience performing current-state assessments and recommending target-state architecture, not just implementing a predefined design. Strong client-facing communication and technical documentation skills. Preferred SQL Server Always On Availability Groups and/or Failover Cluster Instances. Azure SQL, Azure Data Factory, Microsoft Fabric, or other Microsoft cloud data-platform experience. Experience modernizing legacy or decentralized SQL Server environments. Higher education experience is a plus, but not required. Munesh , CYBER SPHERE LLC