Опубліковано 5 днів тому
SQL DB Engineer
- В офісі
- Azure
- Snowflake
- SQL
Опис вакансії
Key Responsibilities
- 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, and transaction-log behavior to isolate and resolve performance issues.
- Refactor row-by-row and scalar-function-heavy processing into efficient set-based designs, including appropriate use of inline table-valued functions, temporary staging, indexing, and early filtering.
- 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.
- Support SQL Server upgrades and configuration changes through representative performance testing, execution-plan comparison, regression validation, and documented rollback or fix-forward plans.
- Engineer and support high availability, disaster recovery, transactional replication, monitoring, maintenance, archival, purge, and capacity-management practices.
- Troubleshoot production incidents with application, infrastructure, SRE, QA, and vendor teams; preserve evidence and translate findings into durable corrective actions.
- Contribute to cloud and platform modernization involving Azure SQL Managed Instance, Azure SQL, data pipelines, and workload offload from monolithic SQL platforms.
- Provide technical leadership through design reviews, code reviews, standards, documentation, mentoring, and knowledge transfer.
RequiredRequired
Required Skills
7+ years of hands-on SQL Server database engineering or development experience in enterprise environments
Advanced T-SQL, stored procedure, function, indexing, data-modeling, and query-optimization skills
Deep knowledge of SQL Server execution plans, Query Store, cardinality estimation, statistics, locking/blocking, waits, parallelism, memory grants, and tempdb.
Experience tuning high-volume transactional and batch-processing workloads with measurable before-and-after validation.
Experience with SQL Server upgrades, configuration assessment, performance testing, and production troubleshooting.
Working knowledge of high availability, disaster recovery, SQL Agent, replication, backup/restore, maintenance, and operational monitoring.
Strong analytical, documentation, collaboration, and incident-management skills
Nice To Have
Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure virtual machines.
Azure Data Factory, Microsoft Fabric pipelines, Snowflake, or reporting/data-platform modernization.
PowerShell or other automation for database deployment, validation, monitoring, or maintenance.
Experience with financial-services transaction, compliance, reporting, or data-feed workloads.
Key Responsibilities
- 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, and transaction-log behavior to isolate and resolve performance issues.
- Refactor row-by-row and scalar-function-heavy processing into efficient set-based designs, including appropriate use of inline table-valued functions, temporary staging, indexing, and early filtering.
- 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.
- Support SQL Server upgrades and configuration changes through representative performance testing, execution-plan comparison, regression validation, and documented rollback or fix-forward plans.
- Engineer and support high availability, disaster recovery, transactional replication, monitoring, maintenance, archival, purge, and capacity-management practices.
- Troubleshoot production incidents with application, infrastructure, SRE, QA, and vendor teams; preserve evidence and translate findings into durable corrective actions.
- Contribute to cloud and platform modernization involving Azure SQL Managed Instance, Azure SQL, data pipelines, and workload offload from monolithic SQL platforms.
- Provide technical leadership through design reviews, code reviews, standards, documentation, mentoring, and knowledge transfer.
Required Skills
7+ years of hands-on SQL Server database engineering or development experience in enterprise environments
Advanced T-SQL, stored procedure, function, indexing, data-modeling, and query-optimization skills
Deep knowledge of SQL Server execution plans, Query Store, cardinality estimation, statistics, locking/blocking, waits, parallelism, memory grants, and tempdb.
Experience tuning high-volume transactional and batch-processing workloads with measurable before-and-after validation.
Experience with SQL Server upgrades, configuration assessment, performance testing, and production troubleshooting.
Working knowledge of high availability, disaster recovery, SQL Agent, replication, backup/restore, maintenance, and operational monitoring.
Strong analytical, documentation, collaboration, and incident-management skills
Nice To Have
Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure virtual machines.
Azure Data Factory, Microsoft Fabric pipelines, Snowflake, or reporting/data-platform modernization.
PowerShell or other automation for database deployment, validation, monitoring, or maintenance.
Experience with financial-services transaction, compliance, reporting, or data-feed workloads
Інші вакансії: Індія
Compliance and Employee Relations Sr Expert, APAC
Webasto Пуне, Махараштра, Індія🇮🇳
Associate Director Business Analytics
Lonza Hyderabad, Телангана, Індія🇮🇳
Proposal Coordinator
Workplace Options Бенґалуру, Карнатака, Індія🇮🇳
Bid Management Specialist
Workplace Options Бенґалуру, Карнатака, Індія🇮🇳
Sr. Principal Release Train Product Manager
AspenTech Пуне, Махараштра, Індія🇮🇳
Senior Delivery Lead, Data Analytics
Stryker Ґурґаон, Харяна, Індія🇮🇳
Electrical / Electronics Architect
IN9P Chakan, Maharashtra Пуне, Махараштра, Індія🇮🇳
Finance Leadership Program Graduate - May 2027 - Bangalore
Expedia Group Бенґалуру, Карнатака, Індія🇮🇳
Operations Specialist, Visa Consulting & Analytics (VCA)
Visa Бенґалуру, Карнатака, Індія🇮🇳
RTL Design and Verification Engineering Manager
Intel Бенґалуру, Карнатака, Індія🇮🇳
Networking Managed Services Engineer (L1)
NTT DATA India Private Limited Мумбаї, Махараштра, Індія🇮🇳
Senior Associate Threat Intelligence and Hunting Analyst
NTT Managed Services India Private Limited Кілька розташувань🇮🇳
Senior Associate Client Project Manager
NTT Managed Services India Private Limited Hyderabad, Телангана, Індія🇮🇳