Lead SQL DBA

6-10 Years

Save

Early Applicant

Job Description

Duties & Responsibilities
Core Database Administration

Install, configure, upgrade, and maintain SQL Server databases across onprem and Azure SQL Managed Instance environments.
Perform advanced performance troubleshooting using execution plans, DMVs, waits & queues, indexing strategies, and engine level diagnostics.
Manage robust backup/restore processes, disaster recovery plans, and ensure data integrity.
Create, maintain, and optimize database objects (schemas, tables, indexes, stored procedures, views, functions, partitions).

High Availability / Replication / Cloud

Configure and maintain, Always On Availability Groups, Log Shipping, Replication, and Azure SQL Managed Instance high availability features.
Support database migrations, cloud modernization, and hybrid SQL environments.

Debugging, Troubleshooting & Production Support

Provide 24/7 production support for mission critical systems and resolve incidents with urgency and precision.
Troubleshoot complex SQL performance issues: blocking, deadlocks, memory contention, I/O bottlenecks, SQL Agent failures, ETL job failures, and corruption-related issues.
Collaborate with application, infrastructure, and DevOps teams to diagnose cross layer issues.

ETL, Automation & Scripting

Support, debug, and optimize ETL packages (SSIS, ADF pipelines) and data integration processes.
Automate administrative tasks using TSQL, PowerShell, SQL Agent jobs or other scripting tools.

Operational Excellence

Conduct capacity planning, storage forecasting, and proactive monitoring to prevent downtime.
Maintain comprehensive documentation for configurations, processes, and operational procedures.
Participate in an on call rotation and provide after hours and weekend support when required.

Management Responsibilities

Requirements

Basic Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field.
610 years of hands on experience as a SQL Server Database Administrator.
Deep understanding of SQL Server internals (optimizer behavior, locking/latching, tempdb, memory management, indexing strategy).
Strong debugging and problem solving skills in high pressure production environments.
Hands on experience working with Azure SQL Managed Instance and hybrid SQL server environments.
Solid experience supporting ETL processes using SSIS or Azure Data Factory.
Proficiency in Management Studio (SSMS), TSQL scripting, and writing optimized queries.
Experience with performance tuning, query optimization, index/maintenance strategies, and storage related analysis.
Knowledge of Windows Server administration and PowerShell scripting for automation.
Strong understanding of database security, role management, encryption, and access control.
Strong experience handling production support, including urgent issue response and severity level incident management.
Willingness to support on-call rotation and provide off-hours support.
Excellent communication, analytical thinking, and ability to collaborate across teams.