Advanced SQL Developer
Senior SQL developer (7-10 yrs) on Octagos Health's Noida data-platform team, tuning T-SQL/Azure SQL at scale for a multi-tenant cardiac remote-patient-monitoring SaaS. Day to day: performance tuning, database architecture, code reviews, and load-testing gates before production releases.
- Compensation
- ₹2M–₹2.5M / yr
- Location
- Noida
- Work setup
- Onsite
- Seniority
- Not specified
- Employment
- Full time
- Experience
- 7+ years
- Category
- Not specified
- Posted
Skills
Must have
- 7+ years of professional SQL Server / Azure SQL development experience
- Expert-level T-SQL: window functions, CTEs, recursive queries, dynamic SQL, JSON handling, temporal tables
- Proven track record optimizing queries against very large, wide-column transactional tables
- Deep knowledge of SQL Server internals: query optimizer, indexing, statistics, locking and isolation, tempdb, memory grants
- Hands-on experience with Azure SQL Database in production at scale
- Production experience with MySQL, including query tuning, indexing, and replication
- Experience designing and executing database load tests and performance benchmarks
- Familiarity with at least one enterprise monitoring tool (Database Watcher, Redgate Monitor, SolarWinds DPA, SQL Sentry, or equivalent)
- Experience leading SQL code reviews and authoring engineering standards
- Strong written and verbal communication skills in English
Nice to have
- Healthcare or HIPAA-regulated environment experience
- Familiarity with .NET / C# data access patterns (Dapper, Entity Framework)
- Experience with Azure Load Testing, JMeter, k6, or similar tooling against database backends
- Experience with CDC, replication, and ETL/ELT pipeline design
- Exposure to Power BI semantic models and DAX optimization
- Background in multi-tenant SaaS data architecture
- Exposure to NoSQL databases (MongoDB, Cosmos DB, DynamoDB) and PostgreSQL
- Data architecture supporting domain-driven design with event-based and pub/sub patterns (Azure Service Bus, Event Grid, Kafka)
- Microsoft certifications: DP-300, DP-203, or equivalent
Full description
Advanced SQL Developer
Octagos Health | Noida, India
Location: Noida, India (On-site)
Department: Engineering, Data Platform
Reports to: Database Architect
Employment Type: Full-time
About Octagos Health
Octagos Health is a US-headquartered, AI-powered cardiac remote patient monitoring SaaS platform serving cardiology clinics nationwide. We are scaling our engineering footprint in Noida to support the next phase of growth.
Role Summary
We are looking for an Advanced SQL Developer who lives and breathes T-SQL and Azure SQL performance. This role centers on four pillars: performance tuning at scale, database architecture for a multi-tenant healthcare platform, SQL code reviews that raise the engineering bar, and performance validation of every new database artifact before it ships. You will work directly with the Database Architect and Engineering leadership to drive reliability, scalability, and data quality.
Key Responsibilities
Performance Tuning
Tune complex T-SQL stored procedures, views, and ad-hoc queries against tables with hundreds of millions of rows.
Analyze execution plans, wait statistics, and Query Store data to identify and resolve CPU, IO, memory, and tempdb bottlenecks.
¢ Design and refine indexing strategies including covering, filtered, columnstore, and partitioned indexes.
¢ Diagnose and remediate blocking, deadlocks, parameter sniffing, plan regressions, and statistics issues in production.
Database Architecture
¢ Contribute to the architecture of a multi-tenant Azure SQL platform using a database-per-tenant pattern with replicated reference data.
¢ Design schemas, partitioning strategies, and data lifecycle patterns for high-volume transactional workloads.
¢ Lead vertical decomposition, read/write separation, and CDC-based pipelines feeding reporting and analytics consumers.
¢ Evaluate Azure SQL features (Hyperscale, elastic pools, temporal tables, ledger tables, managed identity) and recommend adoption based on cost and performance trade-offs.
¢ Define standards for schema migrations, versioning, and zero-downtime deployments.
Performance Monitoring and Load Testing
¢ Own the performance monitoring stack across Azure SQL using Database Watcher, Redgate Monitor, SolarWinds DPA, Query Store, and Extended Events.
¢ Establish baselines, dashboards, and alerting for query latency, throughput, deadlocks, blocking, and resource utilization.
¢ Build and maintain load testing harnesses (Azure Load Testing, JMeter, or equivalent) that exercise the data tier under realistic concurrency and data volumes.