Talent.com
MS SQL Server SME

MS SQL Server SME

HCLSoftwareBengaluru, Republic Of India, IN
15 hours ago
Job description

MS SQL Database Support Engineer

Role Summary

The MS SQL Database Support Engineer is a Subject Matter Expert (SME) responsible for the highest level of technical support, troubleshooting, and strategic maintenance for all Microsoft SQL Server database environments. This role acts as the final escalation point for the most complex, critical, and persistent database issues, ensuring maximum performance, security, and availability of all mission-critical database systems.

Key Responsibilities

1. Expert Troubleshooting & Issue Resolution

  • Serve as the final escalation point for diagnosing and resolving highly complex and critical database incidents, performance issues, and persistent problems.
  • Perform Root Cause Analysis (RCA) for major incidents, implementing permanent solutions to prevent recurrence.
  • Conduct in-depth performance tuning and optimization, including advanced query analysis, indexing strategies, and server configuration adjustments to ensure optimal database performance.
  • Debug and analyze complex Stored Procedures, Functions, and SSIS packages.

2. Strategic Improvement & Mentorship

  • Develop, implement, and maintain automation scripts (PowerShell, Python, T-SQL) for database maintenance, health checks, and routine administrative tasks.
  • Collaborate with Development and Architecture teams on new projects, providing expert guidance on database design, best practices, and scalability to ensure Database-as-a-Service (DBaaS) readiness.
  • Manage critical vendor relationships (e.G., Microsoft Support) for issues requiring external expertise.
  • Required Technical Skills and Qualifications

  • Education : Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent professional experience).
  • Experience : 5+ years of experience in Microsoft SQL Server Database Administration and Support, with at least 2 years in a Level 3 or Senior DBA role.
  • MS SQL Expertise :
  • Expert-level proficiency in T-SQL coding, tuning, and optimization.
  • Deep expertise in implementing and managing High Availability (HA) and Disaster Recovery (DR) solutions (e.G., Always On, Clustering).
  • Proven experience with performance monitoring, diagnostics, and tuning tools (DMVs, Extended Events, SQL Profiler).
  • Strong knowledge of SQL Server security models, encryption (TDE), and compliance standards.
  • Experience supporting databases in a Cloud environment (Azure SQL Database, Azure SQL Managed Instance, or AWS RDS) is highly desirable.
  • Operating Systems : Proficient in Windows Server environments, including storage, networking, and virtualization concepts.
  • Automation : Experience with scripting languages like PowerShell for database automation.
  • Desired Soft Skills

  • Exceptional Problem-Solving : Ability to think critically and apply expert knowledge to resolve novel, high-impact issues under pressure.
  • Communication : Excellent verbal and written communication skills for managing technical bridges during critical incidents and documenting complex solutions for lower tiers.
  • Mentorship : Demonstrated ability to teach, mentor, and transfer knowledge to junior staff.
  • Customer Focus : A sincere dedication to service quality and meeting client / internal business needs.
  • Create a job alert for this search

    Sql Server • Bengaluru, Republic Of India, IN

    Related jobs
    • Promoted
    SQL Server DBA

    SQL Server DBA

    Litmus7Bengaluru, Karnataka, India
    We are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill.The ideal candidate will handle the administration, performance tuning, monito...Show moreLast updated: 12 days ago
    • Promoted
    Senior SQL Server DBA

    Senior SQL Server DBA

    ConfidentialBengaluru / Bangalore, India
    Version 1 has celebrated over 28 years in Technology Services and continues to be trusted by global brands to deliver solutions that drive customer success. Version 1 has several strategic technolog...Show moreLast updated: 22 days ago
    • Promoted
    SQL Server DBA

    SQL Server DBA

    ConfidentialBengaluru / Bangalore, India
    We are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill.The ideal candidate will handle the administration, performance tuning, monito...Show moreLast updated: 30+ days ago
    • Promoted
    Senior SQL Server DBA

    Senior SQL Server DBA

    Version 1Bengaluru, Karnataka, India
    Version 1 is looking for an experienced consultant to join its Managed Services team.The ideal candidate will have a proven track record of developing and supporting Database Server solutions for m...Show moreLast updated: 30+ days ago
    • Promoted
    Server Engineering SME

    Server Engineering SME

    ConfidentialBengaluru / Bangalore, India
    At Quest Global, it's not just what we do but how and why we do it that makes us different.With over 25 years as an engineering services provider, we believe in the power of doing things differentl...Show moreLast updated: 17 days ago
    • Promoted
    Database Architect - SQL Server

    Database Architect - SQL Server

    Prometheus consultingBangalore
    Key Responsibilities : Database Architecture & Design : - Design, implement, and maintain enterprise-scale SQL Server data...Show moreLast updated: 30+ days ago
    • Promoted
    Sql Server Dba

    Sql Server Dba

    Litmus7Bengaluru, Republic Of India, IN
    We are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill.The ideal candidate will handle the administration, performance tuning, monito...Show moreLast updated: 11 days ago
    • Promoted
    Sr. SQL Server DBA

    Sr. SQL Server DBA

    ConfidentialBengaluru, Karnataka, India
    We are seeking a highly skilled Senior SQL Server Database Administrator to setup, manage, optimize, and support our SQL Server in a mission-critical, high-performance environment.The ideal candida...Show moreLast updated: 1 day ago
    • Promoted
    SQL Server Developer

    SQL Server Developer

    ConfidentialBengaluru / Bangalore
    Maimsd Technology is looking for a skilled.We need someone with solid experience in SQL Server development, including strong query writing, database design, and data integration.If you're adept at ...Show moreLast updated: 30+ days ago
    • Promoted
    IT IS_AMS_Database_MS SQL Server

    IT IS_AMS_Database_MS SQL Server

    ConfidentialBengaluru / Bangalore
    Teamware Solutions is seeking a skilled professional for the.IT IS_AMS_Database_MS SQL Server.This position is crucial for ensuring the stability, performance, and availability of our Microsoft SQL...Show moreLast updated: 30+ days ago
    • Promoted
    Microsoft SQL Server 2019

    Microsoft SQL Server 2019

    ConfidentialBengaluru / Bangalore
    Administer, configure, and manage.Assist in data migration tasks and ensure smooth integration of.Performance Tuning and Optimization : . SQL Server Management Studio (SSMS).Dynamic Management Views (...Show moreLast updated: 30+ days ago
    • Promoted
    Microsoft SQL Server Integration Services (SSIS)

    Microsoft SQL Server Integration Services (SSIS)

    Trigent Software Private LimitedBengaluru, Karnataka, India
    Summary : As an Application Lead you will lead the effort to design build and configure applications acting as the primary point of contact. Your typical day will involve collaborating with various t...Show moreLast updated: 30+ days ago
    • Promoted
    Sr. Sql Server Dba

    Sr. Sql Server Dba

    ConfidentialBengaluru, Republic Of India, IN
    We are seeking a highly skilled Senior SQL Server Database Administrator to setup, manage, optimize, and support our SQL Server in a mission-critical, high-performance environment.The ideal candida...Show moreLast updated: 1 day ago
    • Promoted
    SQL Server Expert

    SQL Server Expert

    ConfidentialBengaluru / Bangalore
    We are seeking a highly skilled.SQL Server databases to improve performance.The ideal candidate will possess deep expertise in database architecture, performance tuning, security, and disaster reco...Show moreLast updated: 30+ days ago
    • Promoted
    Python & SQL Server DBA

    Python & SQL Server DBA

    ConfidentialBengaluru / Bangalore
    The Python & SQL Server DBA is responsible for managing and maintaining SQL Server databases while leveraging Python for automation, data processing, and performance optimization.This hybrid role c...Show moreLast updated: 30+ days ago
    • Promoted
    SQL Server Consultant

    SQL Server Consultant

    Trigent Software Private LimitedBengaluru Urban, Karnataka, India
    Job Description : 10 MDC5C Summary : As an Application Developer you will design build and configure applications to meet business process and application requirements. A typical day involves collabor...Show moreLast updated: 30+ days ago
    • Promoted
    Sr.Analyst SQL Developer [T500-21444]

    Sr.Analyst SQL Developer [T500-21444]

    MUFGBengaluru, Karnataka, India
    Japan’s premier bank, with a global network spanning in more than 40 markets.Outside of Japan, the bank offers an extensive scope of commercial and investment banking products and services to busin...Show moreLast updated: 10 days ago
    • Promoted
    Microsoft Sql Server Integration Services Developer

    Microsoft Sql Server Integration Services Developer

    ConfidentialBengaluru / Bangalore
    Monitor production SSIS jobs and ETL pipelines to ensure timely completion.Investigate , troubleshoot, and resolve issues related to SSIS package. Provide L3 support by analyzing logs, debugging SQL...Show moreLast updated: 30+ days ago