Talent.com
MS SQL Server SME
MS SQL Server SMEHCLSoftware • Bengaluru, Republic Of India, IN
MS SQL Server SME

MS SQL Server SME

HCLSoftware • Bengaluru, Republic Of India, IN
4 days 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
    SQL Server DBA

    SQL Server DBA

    Litmus7 • Bengaluru, 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 more
    Last updated: 15 days ago • Promoted
    MS SQL DBA

    MS SQL DBA

    Tata Consultancy Services • Bengaluru, Karnataka, India
    Seniors / Lead SQL Server DBA in a production(Cluster & Standalone) environment.Good knowledge of SQL Server 2012, 2014, 2016, 2017, and 2019 versions. Good understanding of Install, configure, and ma...Show more
    Last updated: 3 days ago • Promoted
    SQL Server Database Reliability Engineer

    SQL Server Database Reliability Engineer

    Sonata Software • Bengaluru, Republic Of India, IN
    In today's market, there is a unique duality in technology adoption.On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefron...Show more
    Last updated: 13 days ago • Promoted
    SQL Server Database Specialist - Bengaluru

    SQL Server Database Specialist - Bengaluru

    Tata Consultancy Services • Bengaluru, Republic Of India, IN
    TCS IS HIRING FOR SQLDBA_6 TO 10 YEARS EXP FOR BANGALORE LOCATION.Experience in Database Administration in SQL Server.SQL 2012,SQL 2014,SQL 2016, SQL 2017 ,SQL 2019 ). Knowledge of Troubleshooting o...Show more
    Last updated: 18 days ago • Promoted
    Principal SQL Server Database Engineer

    Principal SQL Server Database Engineer

    Confidential • Bengaluru, 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 more
    Last updated: 4 days ago • Promoted
    Sql Server Dba

    Sql Server Dba

    Litmus7 • Bengaluru, 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 more
    Last updated: 15 days ago • Promoted
    Sr. SQL Server DBA

    Sr. SQL Server DBA

    Confidential • Bengaluru, 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 more
    Last updated: 4 days ago • Promoted
    Citrix SME

    Citrix SME

    Tata Consultancy Services • Bangalore Urban, Karnataka, India
    Location : Chennai / Bangalore / Hyderabad.Desired Competencies (Technical / Behavioral Competency).Citrix Virtual Apps and Desktops (CVAD) and Citrix DaaS. Proven expertise in Azure Virtual Desktop (AVD...Show more
    Last updated: 9 days ago • Promoted
    Senior SQL Server Database Administrator – Azure

    Senior SQL Server Database Administrator – Azure

    Maitsys • Bangalore, IN
    Senior (Minimum 10 years of professional experience).We are looking for an experienced.Senior SQL Server Database Administrator (DBA). The ideal candidate will have a proven track record in managing...Show more
    Last updated: 1 day ago • Promoted
    SQL Server Analytics & Power BI Developer

    SQL Server Analytics & Power BI Developer

    Best Infosystems Ltd. • bangalore, karnataka, in
    SQL Server Analytics & Power BI Developer_Full-Time_Noida, Pune, Mumbai, Delhi, Chennai, Bangalore.SQL Server Analytics & Power BI Developer. Noida, Pune, Mumbai, Delhi, Chennai, Bangalore.SQL Serve...Show more
    Last updated: 30+ days ago • Promoted
    SME - CDC Implementations (Oracle / Debezium)

    SME - CDC Implementations (Oracle / Debezium)

    ITC Infotech • Bengaluru, India
    SME - CDC Implementations (Oracle / Debezium).Lead CDC Implementations : Architect and implement Change Data Capture (CDC) solutions using Debezium, Oracle, and other related CDC tools and technolog...Show more
    Last updated: 30+ days ago • Promoted
    SQL Server & Oracle DBA

    SQL Server & Oracle DBA

    Litmus7 • Bengaluru, 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 more
    Last updated: 15 days ago • Promoted
    Microsoft SQL Server Integration Services (SSIS)

    Microsoft SQL Server Integration Services (SSIS)

    Trigent Software Private Limited • Bengaluru, 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 more
    Last updated: 30+ days ago • Promoted
    Sr. Sql Server Dba

    Sr. Sql Server Dba

    Confidential • Bengaluru, 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 more
    Last updated: 5 days ago • Promoted
    SQL Server Cluster Administrator

    SQL Server Cluster Administrator

    Elektrobit • Bengaluru, Republic Of India, IN
    We are seeking a skilled and proactive Microsoft Administrator to join our IT team.The primary focus of this role is the administration and optimization of Microsoft SQL Server cluster databases, e...Show more
    Last updated: 7 days ago • Promoted
    SAP HANA DBA Consultant

    SAP HANA DBA Consultant

    Tata Consultancy Services • bangalore, karnataka, in
    Greetings from TATA Consultancy Services!!.Thank you for expressing your interest in exploring a career possibility with the TCS Family. Hiring For : SAP HANA DBA Consultant.Walk in Drive Date : 22 N...Show more
    Last updated: 9 days ago • Promoted
    SQL Server Expert

    SQL Server Expert

    Tata Consultancy Services • Bengaluru, Republic Of India, IN
    SQL Server 2005, 2008, 2012,2014,2016,2019.Experience with database design, administration and maintenance in distributed environments. Experience in troubleshooting and resolving database issues, i...Show more
    Last updated: 30+ days ago • Promoted
    Senior SQL Server Database Specialist

    Senior SQL Server Database Specialist

    Tata Consultancy Services • Bengaluru, Republic Of India, IN
    Seniors / Lead SQL Server DBA in a production(Cluster & Standalone) environment.Good knowledge of SQL Server 2012, 2014, 2016, 2017, and 2019 versions. Good understanding of Install, configure, and ma...Show more
    Last updated: 3 days ago • Promoted