SQL Server DBA Lead

Experience - 7 plus years

Role Overview

We are looking for an experienced SQL Server Database Administrator with strong expertise in handling day-to-day DB Administration activities in a multi-platform enterprise environment, owning and driving scheduled and ad-hoc maintenance tasks, strong performance analysis, tuning, troubleshooting, production incident resolution, and query optimization. The ideal candidate has supported large-scale global enterprises (>$10B annual revenue) and can quickly analyze and resolve performance-related issues in mission-critical environments.

Key Responsibilities

• Installation & Configuration: Set up and maintain SQL Server instances, including patching and upgrades.
• Performance Tuning: Monitor, analyze and optimize database performance, queries, and scalability.
• Backup & Recovery: Design, implement, and test robust backup and disaster recovery plans.
• Security: Manage user accounts, roles, permissions, and conduct security audits to protect data.
• Maintenance: Perform routine tasks like index maintenance, space management, and applying updates.
• High Availability: Administer solutions like Always-on Availability Groups, mirroring, and replication.
• Troubleshooting: Resolve database incidents and determine root causes.
• Collaboration: Work with developers to design efficient database solutions and optimize code.
• Documentation: Create and maintain documentation for database configurations and procedures.
• Automation: Write scripts (T-SQL, PowerShell) to automate repetitive tasks.
  
  

Essential Skills & Qualifications

• Proficiency in SQL Server Administration, Security, Performance Tuning, Backup/Recovery.
• Strong understanding of T-SQL.
• Experience with High Availability/Disaster Recovery (HA/DR) technologies.
• Ability to automate tasks.
• Strong problem-solving and communication skills.
• Lead critical production incident resolution including triage, RCA, and permanent fixes.
• Perform database upgrades, patching, and capacity planning.
• Ensure database security, auditing, and compliance.
• Automate repeatable DBA tasks and maintain documentation.
• Analyze and investigate reason for job failures, long-running queries, and provide recommendations to improve overall system performance.
  
  

Required Experience

• 7+ years of hands-on SQL Server DBA experience in enterprise environments.
• Experience supporting organizations with >$10B revenue or large-scale operational workloads.
• Hands-on experience with SSMS, SSRS.
  
  

Strong Expertise In

• SQL tuning.
• Query execution plans and explain plan interpretation.
• Wait events & performance diagnostics.