SQL DBA

We are seeking a skilled Microsoft SQL Database Administrator (DBA) with 3+ years of strong hands-on experience managing complex SQL Server environments. The ideal candidate must have deep knowledge of SQL Server internalsquery processing, indexing, locking/blocking, execution plans, memory architecturealong with exceptional debugging capabilities. This role will support high-availability production systems, Azure SQL Managed Instances, ETL workflows, and database operations across development, QA, and production environments. A strong commitment to production support, rapid issue resolution, and participation in on-call rotations is essential.

Duties & Responsibilities

Core Database Administration

Install, configure, upgrade, and maintain SQL Server databases across on-prem 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 T-SQL, 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.

Basic Qualifications Bachelor's degree in Computer Science, Information Technology, or related field. 3+ 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), T-SQL 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.

Preferred Qualifications Microsoft Certified (DP-300) or similar certification. Familiarity with data warehousing concepts and tools (e.g., Snowflake) Exposure to DevOps practices and CI/CD pipelines.