Database Platform Engineer Chennai, Tamil Nadu, India

Grove by Banyan; Chennai District; Hybrid; INR 2,600,000 - 4,800,000; Full time

Job summary

TechGrove by Banyan Software is seeking a senior database engineer to own Azure SQL MI across Dev, QA and Production, design schemas, and drive performance. You will implement CI/CD with DACPAC or migration-based deployments while enforcing security, backups, and DR testing.

You will partner with .NET teams, guide ORM usage, and ensure high availability. Hybrid role with Chennai office presence, 8–12 years of SQL Server experience required.

Qualifications

• 8 to 12 years of hands-on SQL Server experience.
• Deep expertise in Azure SQL MI or Azure SQL Database.
• Advanced T-SQL covering complex queries, stored procedures, views, triggers, and dynamic SQL.
• Query tuning using execution plans, index design, statistics, and wait stats analysis.
• Database DevOps using DACPAC, Flyway, or equivalent migration tooling integrated with CI/CD pipelines.
• Schema design for high-traffic transactional systems.
• Azure Monitor, SQL Insights, or equivalent observability tooling.
• Strong understanding of high availability including Always On, failover groups, and geo-replication.
• Experience working alongside .NET development teams using ADO.NET or Entity Framework.

Responsibilities

• Own Azure SQL MI across Dev, QA, and Production environments.
• Design, evolve schemas and migration scripts.
• Develop stored procedures, views, functions, and complex queries.
• Tune queries and optimize performance with execution plans and indexes.
• Provide on-call database support and incident response.
• Maintain database CI/CD pipelines using DACPAC or migration-based deployments with Azure DevOps.
• Enforce database security including TDE, RBAC, row-level security, auditing.
• Manage backups, restore, and disaster recovery validation; monitoring with Azure Monitor and SQL Insights.
• Plan capacity and monitor database health across environments.
• Collaborate with application developers to review data access patterns and guide ORM usage.

Skills

SQL Server

Azure SQL MI

T-SQL

Query tuning

Database DevOps

Schema design

Azure Monitor

Always On / HA

ADO.NET / EF

Tools

DACPAC

Flyway

Job description

About the Role

TechGrove by Banyan Software is a portfolio of vertical SaaS businesses. It plays a key role in supporting Banyan’s global businesses through technology, security, and software development. TechGrove brings together India’s deep pool of technical talent with Banyan’s long-term approach to growth, creating a trusted, developer-focused environment where people can do their best work.

This role is being built in-house to establish long-term ownership and institutional knowledge inside the engineering team.

What You Will Own

• Azure SQL Managed Instance across all environments: Dev, QA, and Production
• Schema design, evolution, and all migration scripts
• All stored procedures, views, functions, and complex queries
• Query performance tuning including execution plans, index strategy, statistics, and blocking analysis
• On-call database support and incident response
• Database CI/CD pipeline using DACPAC or migration-based deployments integrated with Azure DevOps
• Database security covering TDE, RBAC, row-level security, auditing, and access control
• Backup, restore, and disaster recovery validationMonitoring and alerting via Azure Monitor and SQL Insights
• Capacity planning and database health across all environments
• Partnering with application developers to review data access patterns, flag inefficient queries, and guide ORM usage

What You Will Not Do

This is not a ticket‑taking support role. You will not manage on‑premise servers, run manual backups, or handle routine admin tasks that can be automated. You are expected to engineer solutions, not administer systems.

Required Skills

• 8 to 12 years of hands‑on SQL Server experience
• Deep expertise in Azure SQL Managed Instance or Azure SQL Database
• Advanced T‑SQL covering complex queries, stored procedures, views, triggers, and dynamic SQL
• Query tuning using execution plans, index design, statistics, and wait stats analysis
• Database DevOps using DACPAC, Flyway, or equivalent migration tooling integrated with CI/CD pipelines
• Schema design for high‑traffic transactional systems
• Azure Monitor, SQL Insights, or equivalent observability tooling
• Strong understanding of high availability including Always On, failover groups, and geo‑replication
• Experience working alongside .NET development teams using ADO.NET or Entity Framework

Good to Have

• Experience with Azure SQL pricing tiers and cost optimization
• Familiarity with Microsoft Fabric or Azure Synapse for analytical workloads
• Experience with row‑level security for multi‑tenant SaaS products

What Good Looks Like in This Role

• No production query runs without an index review
• Every schema change ships with a tested migration script
• Database incidents are resolved with a root cause document and a prevention plan
• Developers get a response within the same sprint when they raise a data access concern
• On‑call is structured, documented, and not reactive

Work Model

Hybrid. Minimum 3 days per week from our Chennai office. Remaining days flexible based on team and sprint cycle needs.

Recruitment Notice

TechGrove may use artificial intelligence (AI) tools to assist in screening and/or assessing applicants during the recruitment process. All hiring decisions are made by our team. Personal information submitted through your application will be collected and used for recruitment purposes in accordance with applicable privacy laws. Contact us at any time with questions about our process or to request accommodation.