Azure SQL Database Architect

• Audit and document existing stored procedures, indexes, schemas, and database object designs
• Refactor T-SQL stored procedures for correctness, maintainability, and performance
• Redesign database objects - tables, views, indexes, constraints - to reduce I/O andimprove throughput
• Design and execute regression and performance test suites to validate all changes
• Produce before-and-after benchmarks: execution time, CPU usage, memory consumption, and query plan comparisons
• Validate functional parity between original and refactored implementations, * All targeted stored procedures refactored with measurably improved execution time and resource utilization
• Database objects redesigned with documented rationale and confirmed functional parity with the original implementation
• Full benchmark report comparing before-and-after: query duration, CPU, memory, I/O, and query plan quality
• Zero regressions - all existing functionality validated through structured, repeatable testing
• Knowledge transfer documentation enabling the internal team to maintain and extend all changes going forward

Do you have experience in Technical writing?, * Deep expertise in Azure SQL Database and T-SQL development

• Strong command of query optimization - execution plans, statistics, index strategies, and query hints
• Proficiency with Azure monitoring and performance tools: Query Store, DMVs, Azure Monitor, and Extended Events
• Demonstrated experience redesigning database schemas for performance at scale
• Ability to establish and run structured testing and benchmarking workflows independently
• Strong written and verbal communication for technical documentation and stakeholder reporting
• Proven track record of delivering measurable performance improvements in production Azure SQL environments

NICE TO HAVE

• Data warehouse modeling, data lake architecture, or data profiling experience
• Azure Synapse Analytics or Azure Data Factory exposure
• Columnstore indexes, partitioning strategies, or in-memory OLTP
• CI/CD pipelines for database deployments
• dbt or similar data modeling tools