Candidates with 10 to 12+ years of experience with Azure SQL, Responsible for Architecting, designing, hands on Database management.
Solution Design & Architecture
-
Design scalable Azure SQL architectures
-
Recommend optimal architecture based on:
-
Application Workload
-
Concurrency
-
Data volume
-
Hands-On experience in Azure Database Migration Service (DMS) for large databases
-
Ability to manage large volumes of Data
Data Model & Schema Design
-
Redesign schema for:
-
Apply:
-
Normalization vs denormalization trade-offs
-
Partitioning strategies
-
Data archiving strategies
-
Define:
-
Data lifecycle management
Workload & Capacity Planning
o High concurrency systems
o Burst workloads
o vCore vs DTU models
o Serverless vs provisioned
o Elastic pool strategies
Cost Optimization Architecture
- Analyze current spend and design:
o Right-sized compute tiers
o Auto-scaling strategies
o Serverless for intermittent workloads
o Optimize Infrastructure resources for Elastic pools based on Data I/O
Data Integration & Ecosystem Design
- Design integrations with:
o Azure Data Factory
o Synapse Analytics
o Event-driven pipelines (Event Hub, Service Bus)
o Efficient data movement
o Minimal latency
DevOps & Automation
- CI/CD pipelines for DB deployments
- Perform database provisioning, configuration, and upgrades
Monitoring & Troubleshooting
-
Using tools like
-
Azure Monitor
-
Log Analytics
-
Query Performance Insight
Troubleshoot database issues-
Connectivity
-
Performance bottlenecks
-
Failures
Performance Tuning & Optimization
-
Analyze query performance and optimize Stored procedures/slow queries
-
Implement indexing strategies
-
Monitor resource utilization (CPU, memory, I/O)
-
Optimize database configurations for cost and performance
Mandatory Sub Skill: Power BI or any other reporting tool
Roles and Responsibilities.
Proficiency in data modeling and design, including SQL development and database administration- Develop and document business process models to illustrate current and future states
- Analyze data to identify trends, patterns, and insights that inform business decisions
- Propose and design technical and process solutions that meet business needs and objectives
- Deliver insights on potential areas of growth, optimization, and improvements
- Problem-Solving. The ability to identify problems, analyze potential solutions, and implement the most effective solution is critical in data analysis projects
- Support business intelligence strategies with quantitative analysis
- Ability to implement common data management and reporting technologies, as well as the basics of columnar and NoSQL databases, data visualization, unstructured data, and predictive analytics
- The ability to create interactive dashboards and detailed reports presenting data insights in a clear and accessible manner to stakeholders
- Strong communication skills (oral and written)
