> Markdown version of [/jobs/ext/229451-azure-sql-database-architect](https://www.wearedevelopers.com/jobs/ext/229451-azure-sql-database-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Azure SQL Database Architect - **Company:** AEZION INC - **Location:** Frisco, TX, United States - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Databases, Data Profiling, Data Warehousing, Database Schema, SQL Azure, Online Transaction Processing, Query Optimization, SQL Stored Procedures, Transact-SQL, Azure Data Factory, Data Lakes, Performance Monitor, Code Restructuring, Azure Synapse Analytics - **Published:** May 20, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=cc1086b287098abb ## About the Role 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 ## Description * 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 ## Related Videos - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Developer Tools for Microsoft Azure](https://www.wearedevelopers.com/videos/450-developer-tools-for-microsoft-azure) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Azure-Well Architected Framework - designing mission critical workloads in practice](https://www.wearedevelopers.com/videos/1529-azure-well-architected-framework-designing-mission-critical-workloads-in-practice) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)