Senior Data Architect

Endava; Karnataka; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Endava in Karnataka, India is seeking a skilled Azure SQL DBA with over 10 years of experience. You will be responsible for managing database services, designing scalable database architectures, and ensuring data quality.

The ideal candidate will have expertise in Azure SQL, data modeling, and strong communication skills. This role also demands experience with BI tools and cloud data integration.

Qualifications

• 10 to 12+ years of experience with Azure SQL.
• Proficiency in data modeling and SQL development.
• Strong experience in database management and administration.

Responsibilities

• Architect and manage Azure SQL databases.
• Design and optimize database architectures.
• Implement ETL pipelines and data quality rules.

Skills

Data modeling and design

SQL development

Database administration

Azure SQL DBA Expertise

Power BI

Communication skills

Education

B.E, B.Tech

Tools

Azure Data Factory

Synapse Analytics

SSIS

Job description

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
• Implement common data management and reporting technologies, as well as the basics of columnar and NoSQL databases, data visualization, unstructured data, and predictive analytics
• Create interactive dashboards and detailed reports presenting data insights in a clear and accessible manner to stakeholders
• Strong communication skills (oral and written)

Candidates with 10 to 12+ years of experience with Azure SQL

Responsible for architecting, designing, and hands‑on database management.

Solution Design & Architecture

• Design scalable Azure SQL architectures
• Recommend optimal architecture based on application workload, concurrency, and 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 and scalability
• Apply normalization vs. denormalization trade‑offs, partitioning strategies, data archiving strategies
• Define data lifecycle management

Workload & Capacity Planning

• Design solutions for high concurrency systems and burst workloads
• Recommend vCore vs DTU models, serverless vs provisioned, elastic pool strategies

Cost Optimization Architecture

• Analyze current spend and design right‑sized compute tiers, auto‑scaling strategies
• Recommend serverless for intermittent workloads
• Optimize infrastructure resources for elastic pools based on data I/O

Data Integration & Ecosystem Design

• Design integrations with Azure Data Factory, Synapse Analytics, and event‑driven pipelines (Event Hub, Service Bus)
• Ensure efficient data movement with minimal latency

Mandatory SQL Server / Azure SQL DBA Expertise

• Microsoft SQL Server and Azure SQL database administration
• Database sizing, file growth, storage management, tempdb, transaction log management
• Backup and restore strategies (full, differential, transaction log, copy‑only, point‑in‑time recovery)
• Recovery models: simple, full, bulk‑logged
• High availability and disaster recovery concepts
• 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

• 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, 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

• Design robust ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, SSIS, or equivalent tools
• Handle schema evolution, schema enforcement, and schema drift handling strategies
• Implement staging, landing, quarantine/error tables; reject records; audit tables; reconciliation checks
• Design retry, restartability, idempotency, and failure recovery mechanisms
• Handle bad source records without failing the complete load where business rules allow
• Implement data validation, data profiling, duplicate handling, null checks, referential integrity checks, and data quality rules
• Work with multiple source systems and design scalable ingestion frameworks

Data Warehouse & Dimensional Modeling

• Explain and design OLTP versus OLAP architecture
• Design star schema and snowflake schema models
• Define fact tables, dimension tables, measures, surrogate keys, slowly changing dimensions, and conformed dimensions
• 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

• 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

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.