SQL DB Engineer

About the role

SQL DB Engineer at Zensar Technologies. Design, develop, review, and optimize complex T-SQL, stored procedures, functions, views, tables, indexes, and data-access patterns.

What you'll do

• Design, develop, review, and optimize complex T-SQL, stored procedures, functions, views, tables, indexes, and data-access patterns
• Analyze execution plans, Query Store data, waits, blocking, memory grants, parallelism, CPU, I/O, tempdb usage
• Refactor row-by-row and scalar-function-heavy processing into efficient set-based designs, including appropriate use of inline table-valued functions, temporary staging
• Tune long-running batch, snapshot, compliance, reporting, and data-export workloads while preserving data integrity and output equivalence
• Design and validate database structures, keys, identity strategies, data models, and replication patterns for large, tightly coupled transactional workloads

What you need

• 7–13 years in software engineering
• SQL
• SQL Server
• Performance testing
• Data modelling
• Azure
• ETL
• Any graduate

Good to have

• Azure Data Factory
• Snowflake
• PowerShell