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) 

Qualifications :

B.E  

Additional Information :

At Endava were 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 perspectivesbecause 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.

Remote Work :

No

Employment Type :

Full-time