×
Register Here to Apply for Jobs or Post Jobs. X

Lead SQL DBA

Job in 600001, Chennai, Tamil Nadu, India
Listing for: Staples India
Full Time position
Listed on 2026-02-08
Job specializations:
  • IT/Tech
    Data Engineer, Cloud Computing, IT Support, Database Administrator
Job Description & How to Apply Below
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 Dev Ops 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, Power Shell, 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
Foster a culture of solution-orientation and ownership, avoiding bottlenecks.

Requirements

Basic Qualifications
Bachelor's degree in Computer Science, Information Technology, or related field.

6–10 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 Power Shell 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.

Preferred Qualifications
Microsoft Certified (DP-300) or similar certification.

Familiarity with data warehousing concepts and tools (e.g., Snowflake)

Exposure to Dev Ops practices and CI/CD pipelines.
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
 
 
 
Search for further Jobs Here:
(Try combinations for better Results! Or enter less keywords for broader Results)
Location
Increase/decrease your Search Radius (miles)

Job Posting Language
Employment Category
Education (minimum level)
Filters
Education Level
Experience Level (years)
Posted in last:
Salary