Endava is hiring a Database Lead

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)