Azure Sql Data Base Administrator

Elabs Infotech; Pune District, Chennai District, Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Elabs Infotech is seeking an experienced SQL Database Administrator to manage Microsoft SQL Server environments with emphasis on HA/DR, Azure SQL, and performance optimization. The role covers on‑premises Windows and virtualized platforms, ensuring security and reliable operation of mission-critical databases.

The ideal candidate will oversee migrations, backups, monitoring, and automation, while collaborating with development teams to improve application performance and efficiency.

Qualifications

• Strong experience as a SQL DBA in Windows and virtualized environments.
• Expert knowledge of Microsoft SQL Server 2008–2019/2022 administration and operations.
• Hands-on experience with SQL Server migrations, upgrades, and version consolidations.

Responsibilities

• Administer, monitor, and maintain Microsoft SQL Server environments (2008-2022).
• Perform SQL Server installation, configuration, upgrades, patching, and migrations.
• Design, implement, and support HA/DR solutions (Always On, Log Shipping, Mirroring, Replication, Failover Clustering).
• Execute backup and recovery strategies,DR testing, and restorations.
• Monitor database health, troubleshoot performance bottlenecks, optimize CPU/memory/disk I/O.
• Perform advanced T-SQL query tuning and execution plan analysis.
• Manage SQL Server Agent Jobs, alerts, maintenance plans, and automation.
• Conduct DBCC checks, index maintenance, fragmentation, statistics.
• Support migration projects using DMA, SSIS/DTS, Azure migration tools.
• Implement and maintain database security, encryption, auditing, and patch management.
• Collaborate with application teams to resolve issues and improve performance.
• Prepare technical documentation and DR runbooks.

Skills

SQL Server administration

HA/DR technologies

Azure SQL

T-SQL performance tuning

Data migration tools

SQL Server Agent/maintenance

Backup/restore strategies

SQL Server monitoring

Tools

DMA

SSIS/DTS

SQL Profiler/Extended Events

Azure migration tools

Job description

We are looking for an experienced SQL Database Administrator (SQL DBA) with strong expertise in Microsoft SQL Server administration, performance tuning, High Availability (HA), Disaster Recovery (DR), and Azure SQL technologies. The ideal candidate will have hands‑on experience managing mission‐critical SQL Server environments across Windows and virtualized platforms, ensuring high availability, security, and optimal database performance.

Key Responsibilities:

• Administer, monitor, and maintain Microsoft SQL Server environments (20082019/2022).
• Perform SQL Server installation, configuration, upgrades, patching, and migrations.
• Design, implement, and support High Availability and Disaster Recovery (HA/DR) solutions, including:
• Always On Availability Groups
• Log Shipping
• Database Mirroring
• Replication
• Windows Failover Clustering
• Execute backup and recovery strategies, disaster recovery testing, and database restoration activities.
• Monitor database health, troubleshoot performance bottlenecks, and optimize CPU, memory, I/O, and storage utilization.
• Perform advanced T‑SQL query tuning, execution plan analysis, and code reviews.
• Manage SQL Server Agent Jobs, alerts, maintenance plans, and automation.
• Conduct database integrity checks using DBCC commands and manage index maintenance, fragmentation, and statistics.
• Support database migration projects using Data Migration Assistant (DMA), SSIS/DTS, and Azure migration tools.
• Implement and maintain database security, encryption, auditing, and compliance standards.
• Collaborate with application teams to resolve database‑related issues and improve application performance.
• Prepare technical documentation, operational procedures, and disaster recovery runbooks.

Required Skills & Experience:

• Strong experience as a SQL DBA in Windows and virtualized environments.
• Expert knowledge of Microsoft SQL Server 2008–2019/2022 administration and operations.
• Hands‑on experience with SQL Server migrations, upgrades, and version consolidations.
• Strong experience with HA/DR technologies, including Always On Availability Groups, Log Shipping, Mirroring, Replication, and Failover Clustering.
• Advanced T‑SQL development, query optimization, and performance tuning skills.
• Expertise in backup/restore strategies, recovery models, DBCC commands, integrity checks, index maintenance, and database optimization.
• Experience managing SQL Server Agent Jobs, alerts, scheduling, and maintenance automation.
• Knowledge of SQL Profiler, Extended Events, SSIS/DTS, and Data Migration Assistant (DMA).
• Strong troubleshooting skills related to CPU, memory, disk I/O, storage latency, and blocking/deadlocks.
• Experience with Azure SQL Database, SQL Server on Azure Virtual Machines, and Azure database migration projects.
• Good understanding of database security, encryption, auditing, and patch management.
• Excellent analytical, troubleshooting, and communication skills.