What You'll Do
Database Architecture & Design
- Own the architecture of our Azure SQL environment (Azure SQL Databases), including service tier and capacity strategy.
- Design scalable data models and schemas for new and existing applications.
- Assess and modernize legacy database structures, stored procedures, and data access patterns.
- Define database development standards, naming conventions, and code review practices.
Performance Tuning & Query Optimization
- Diagnose and resolve performance bottlenecks using execution plans, Query Store, and Extended Events.
- Design and maintain indexing, partitioning, and statistics strategies.
- Optimize T-SQL, stored procedures, and application queries in partnership with developers.
- Proactively monitor workloads, blocking, deadlocks, and resource utilization.
Reliability, Security & Operations
- Own backup, restore, high availability, and disaster recovery (point-in-time restore, geo-replication, failover groups).
- Implement database security, including Entra ID authentication, role-based access, encryption, and auditing, protecting PII data.
- Automate schema changes, deployments, and maintenance
- Manage Azure database cost, scaling, and capacity planning.
Data Engineering & Integration
- Build and maintain ETL/ELT pipelines using Azure Data Factory, SSIS, or similar tools.
- Design CDC and incremental load strategies to move data reliably between systems.
- Establish data quality, reconciliation, and monitoring processes.
Cross-Functional Leadership
- Partner with Engineering, Product, and Analytics teams to define data requirements and priorities.
- Translate business needs into scalable database solutions.
- Serve as a trusted advisor on database architecture, performance, and data governance.