Azure SQL Database Architect

Title: Azure SQL Database ArchitectLocation: Frisco, TX (5-Days Onsite)Duration: Long TermRole Overview:We are looking for a hands-on Azure SQL Database Architect to lead a targeted refactoring and optimization engagement. You will independently audit the current databaseimplementation, redesign database objects for performance, and deliver validated before-and-after benchmarks covering functionality, execution time, and CPU/memory resource utilization.This is a results-driven, onsite role. You will own the full lifecycle of each change — from analysis through implementation, testing, and sign-off — communicating findings clearly to technical and non-technical stakeholders.Job DescriptionDocument all changes with clear rationale and measurable outcomesTransfer knowledge to the internal team to ensure long-term maintainabilityREQUIRED SKILLS & EXPERIENCEDeep expertise in Azure SQL Database and T-SQL developmentStrong command of query optimization — execution plans, statistics, index strategies, and query hintsProficiency with Azure monitoring and performance tools: Query Store, DMVs, Azure Monitor, and Extended EventsDemonstrated experience redesigning database schemas for performance at scaleAbility to establish and run structured testing and benchmarking workflows independentlyStrong written and verbal communication for technical documentation and stakeholder reportingProven track record of delivering measurable performance improvements in production Azure SQL environmentsNICE TO HAVEData warehouse modeling, data lake architecture, or data profiling experienceAzure Synapse Analytics or Azure Data Factory exposureColumnstore indexes, partitioning strategies, or in-memory OLTPCI/CD pipelines for database deploymentsdbt or similar data modeling tools