Requisition Number 102340 Sr Consultant - 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 20 on Fortune s World s Best Workplaces TM list 9 2 billion in revenue Received 35 industry and partner awards in the past year 1 4M total charitable contributions in 2023 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 Architect to lead the design implementation and optimization of enterprise-grade database solutions The ideal candidate 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 we re looking for Education Experience Bachelor s or Master s degree in Computer Science Information Technology or a related field Minimum 8 years of hands-on experience with Microsoft SQL Server 2016 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 Robust 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 e g 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 We re 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 location even an international destination for 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 may need during the interview process At Insight we celebrate diversity of skills and experience so even if you don t 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 candidate and recruiters or agencies who submit candidates for this position without a prior written vendor agreement will not be eligible for any form of compensation even if the candidate 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 122002 India

📌 Consultant Sr (Haryana)
🏢 Insight
📍 Haryana