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:
Performance
Scalability
Apply:
Normalization vs denormalization trade-offs
Partitioning strategies
Data archiving strategies
Define:
Data lifecycle management
Workload & Capacity Planning
· Design solutions for:
o High concurrency systems
o Burst workloads
· Recommend:
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
· Recommend:
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)
· Ensure:
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)
B.E, B.Tech
At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives—because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know.
