Azure SQL Database Architect

Azure SQL Database Architect Aezion In Frisco, TX Job Details Full-time 6 hours ago Qualifications Data model design Data modeling Data lake Performance testing Data Architecture Design (Architecture design skills) Improving database performance Software documentation Technical writing Regression testing Agile software development Benchmarking Cloud monitoring Project stakeholder communication T-SQL Stakeholder management System performance monitoring

Full Job Description Title:

Azure SQL Database Architect Location:

Frisco, TX (5-Days Onsite)

Duration:

Long Term Role 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 database implementation, 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.

CORE RESPONSIBILITIES

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 Job Description Document all changes with clear rationale and measurable outcomes Transfer knowledge to the internal team to ensure long-term maintainability

REQUIRED SKILLS & EXPERIENCE

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

WHAT SUCCESS LOOKS LIKE

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

Job Type:

Full-time Work Location:

In person