Consultant Sr

Requisition Number: 102340
Cloud Solution Specialist Database SQL Server Location: Delhi NCR, Bangalore, Hyderabad, Trivandrum, Pune The role will be a hybrid position located in India Insight at a Glance 14,000+ engaged teammates globally #20on Fortunes World'sBest Workplaces list 2 billion in revenue Received 35+ industry and partner awards in the past year 4M+ total charitable contributions in by Insight globally Now is the time to bring your expertise to Insight We are not just a tech company; we are a people-first company We believe that by unlocking the power of people and technology, we can accelerate transformation and achieve extraordinary results As a Fortune 500 Solutions Integrator with deep expertise in cloud, data, AI, cybersecurity, and intelligent edge, we guide organisations through complex digital decisions About The Role We are seeking a highly skilled and experienced SQL Server Specialist to lead the design, implementation, and optimization of enterprise-grade database solutions The ideal candi will have deep expertise in SQL Server, Azure SQL Database, and Azure SQL Managed Instance, with a strong understanding of cloud architecture, performance tuning, and data security Key Responsibilities Database Architecture & Design: Architect scalable, secure, and high-performance database solutions using SQL Server and Azure SQL platforms Design normalized and denormalized schemas based on business requirements and data modeling best practices Define and implement data partitioning, indexing, and compression strategies for performance optimization Cloud Migration & Modernization: Lead end-to-end migration of on-prem SQL Server databases to Azure SQL Database and Azure SQL Managed Instance Evaluate workloads for suitability to Azure PaaS vs IaaS and recommend optimal deployment models Implement hybrid connectivity solutions using VPN, ExpressRoute, and private endpoints Performance Tuning & Optimization: Analyze and optimize slow-running queries, stored procedures, and ETL processes Use Query Store, Extended Events, and DMVs to monitor and troubleshoot performance issues Conduct regular health checks and capacity planning for production environments Security & Compliance: Implement role-based access control (RBAC), data masking, and encryption (TDE, Always Encrypted) Ensure compliance with regulatory standards such as GDPR, HIPAA, and ISO 27001 Conduct audits and vulnerability assessments on database environments High Availability & Disaster Recovery: Design and implement HA/DR solutions using Always On Availability Groups, Failover Clustering, and Geo-Replication Develop backup and restore strategies aligned with RTO/RPO requirements Test and document disaster recovery procedures Automation & DevOps Integration: Automate database deployments and maintenance tasks using PowerShell, Azure CLI, and ARM/Bicep templates Integrate database changes into CI/CD pipelines using tools like Azure DevOps Maintain version control and change tracking for database objects Server Infrastructure Management: Collaborate with Infrastructure teams to manage and optimize Windows Server and Linux Server environments hosting SQL Server instances Ensure proper configurations, patching and performance tuning of OS-level components affecting database performance Active Directory & Identity Integration: Design and implement secure authentication mechanisms using Active Directory and Azure AD Manage service accounts, group policies and access controls for database services Collaboration & Leadership: Work closely with application developers, infrastructure teams, and business stakeholders Provide technical mentorship to junior DBAs and developers Document architecture decisions, standards, and operational procedures What Were Looking For Education & Experience: Bachelors or Masters degree in Computer Science, Information Technology, or a related field Minimum 8 years of hands-on experience with Microsoft SQL Server ( +) Minimum 3 years of experience with Azure SQL Database and Azure SQL Managed Instance Technical Skills: Expert-level proficiency in T-SQL, query optimization, and database performance tuning Strong understanding of Azure networking, identity, and security models Experience with Windows Server and Linux Server administration in relation to SQL Server deployments Hands on experience with Active Directory, Azure AD, and Identity federation Experience with Azure Monitor, Log Analytics, and Application Insights for database observability Preferred Qualifications: Microsoft Certified: Azure Database Administrator Associate or equivalent Microsoft Certified: Azure Solutions Architect Expert Microsoft Certified: Windows Server Hybrid Administrator Associate Experience with hybrid cloud environments and data integration tools (eg Azure Data Factory) Knowledge of other Azure data services like Cosmos DB, Synapse Analytics, or Databricks Soft Skills: Excellent analytical and problem-solving abilities Strong communication and documentation skills Ability to work independently and lead cross-functional teams What You Can Expect Were legendary for taking care of you, your family and to help you engage with your local community We want you to enjoy a full, meaningful life and own your career at Insight Some of our benefits include: Freedom to work from another locationeven an international destinationfor up to 30 consecutive calendar days per year But what really sets us apart are our core values of Hunger, Heart, and Harmony, which guide everything we do, from building relationships with teammates, partners, and clients to making a positive impact in our communities Join us today, your ambITious journey starts here Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law When you apply, please tell us the pronouns you use and any reasonable adjustments you need during the interview process At Insight, we celebrate diversity of skills and experience so even if you dont feel like your skills are a perfect match we still want to hear from you! Insight does not accept unsolicited resumes from recruiters or employment agencies Unsolicited resumes will be treated as direct applications from the candi , and recruiters or agencies who submit candi for this position without a prior, written vendor agreement will not be eligible for any form of compensation, even if the candi is hired Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law Insight India Location:Level 16, Tower B, Building No 14, Dlf Cyber City In It/Ites Sez, Sector 24 &25 A Gurugram Gurgaon Hr 12 India