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
Candidates with 10 to 12+ years of experience with Azure SQL, Responsible for Architecting, designing, hands on Database management.
Don't want to miss the next one?
Subscribe to daily email alerts for roles matching your interests.
Database maintenance: index rebuild/reorganize, statistics update, integrity checks
Handling production incidents related to space, logs, blocking, deadlocks, slow queries, failed jobs, and ETL failures
Query Performance Tuning & Execution Plan Analysis
Candidate must be able to:
Analyze actual and estimated execution plans
Identify table scans, index scans, key lookups, missing indexes, implicit conversions, parameter sniffing, bad joins, spills, incorrect cardinality estimates, and outdated statistics
Tune stored procedures, views, joins, aggregations, and ETL queries
Diagnose blocking, deadlocks, wait types, CPU pressure, memory pressure, and I/O bottlenecks
Use Query Store, DMVs, Extended Events, SQL Profiler where applicable, Azure Query Performance Insight, and Azure Monitor
Explain cases where query tuning does not improve performance and identify non-query bottlenecks such as storage, network, concurrency, locking, application design, or resource tier limitations
Data Integration, ETL Architecture & Data Quality
Candidate should have hands-on experience in:
Designing robust ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, SSIS, or equivalent tools
Handling schema evolution when source systems add, remove, or change columns
Designing schema enforcement and schema drift handling strategies
Define grain of fact tables and explain how grain impacts measures, aggregation, and reporting accuracy
Design data marts and reporting layers for Power BI or similar BI tools
Separate operational workloads from analytical workloads using appropriate architecture patterns
Database Technology Selection
Candidate should be able to:
Compare SQL and NoSQL databases
Recommend appropriate database technology based on data model, consistency, scalability, transaction requirements, query patterns, and reporting needs
Understand use cases for relational databases, document databases, key-value stores, columnar stores, and analytical stores
Explain trade-offs between ACID consistency, schema flexibility, performance, and scalability
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
Mandatory Sub Skill: Power BI or any other reporting tool
Qualifications
B.E, B.Tec
Additional Information
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.
Similar roles you might like
More openings like this one — take a look before you go.
