Sql Dba Lead

Multiverse Solutions; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Multiverse Solutions is seeking an experienced SQL Database Administrator to manage SQL Server 2019/2022 environments across Production, QA, and Development.

The role focuses on Always On Availability Groups, replication, backup/DR, performance tuning, and proactive monitoring to ensure high availability and reliability of mission-critical databases.

Qualifications

• 5+ years of hands-on experience as a SQL Server DBA.
• Proficient with SQL Server 2019/2022 and Always On.
• Experience with replication and disaster recovery.
• Strong performance tuning and query optimization skills.

Responsibilities

• Install, configure, administer, and maintain SQL Server 2019/2022 environments across Production, QA, and Development.
• Manage Always On Availability Groups and High Availability solutions.
• Monitor health, performance, disk space, and SQL Server services with monitoring tools.
• Perform backup, restore, DR, and incident resolution within SLA timelines.
• Execute maintenance tasks: index rebuild, statistics updates, integrity checks; monitor SQL Server Agent jobs and ETL processes.
• Analyze execution plans, identify blocking/deadlocks, and optimize queries.
• Configure and troubleshoot replication technologies and patch/migrate as needed.
• Collaborate with development/infrastructure teams to improve DB performance.
• Implement monitoring/alerting for proactive issue detection.
• Participate in production support and on-call rotation.
• Document configurations, procedures, and disaster recovery processes.

Skills

SQL Server DBA

SQL Server 2019/2022

Always On Availability Groups

Transactional Replication

SQL Server architecture

Performance tuning

T-SQL

Tools

SQL Server Management Studio

Job description

Job Summary

We are seeking an experienced SQL Database Administrator (SQL DBA) with strong expertise in Microsoft SQL Server 2019/2022 to manage, maintain, optimize, and support mission critical database environments

Key Responsibilities

• Install, configure, administer, and maintain SQL Server 2019/2022 environments across Production, QA, and Development.
• Manage and support SQL Server Always On Availability Groups and High Availability solutions.
• Managed and supported Microsoft SQL Server production environments, ensuring high availability, performance, and reliability. Monitored database health, performance, disk space, and SQL Server services using SQL Server tools and monitoring solutions.
• Performed database backup, restore, and disaster recovery operations to ensure business continuity. Investigated and resolved production incidents, performance bottlenecks, and database-related issues within SLA timelines.
• Executed database maintenance tasks, including index rebuilding/reorganization, statistics updates, and integrity checks. Monitored SQL Server Agent jobs, scheduled tasks, and ETL processes, resolving failures proactively.
• Worked on performance tuning by analyzing execution plans, identifying blocking/deadlocks, and optimizing queries.
• Configure, monitor, and troubleshoot Transactional Replication and other replication technologies. Perform database backup, restore, disaster recovery, and maintenance activities.
• Perform database patching, upgrades, migrations, and version management.
• Collaborate with application development and infrastructure teams to improve database performance and reliability.
• Implement monitoring and alerting solutions for proactive issue detection.
• Participate in production support and on-call rotation activities.
• Document database configurations, operational procedures, and disaster recovery processes.

Required Skills & Qualifications

Technical Skills

• 5+ years of hands-on experience as a SQL Server DBA.
• Strong experience with Microsoft SQL Server 2019 and/or 2022.
• Expertise in Always On Availability Groups.
• Hands-on experience with Transactional Replication.
• Strong understanding of SQL Server architecture and database internals.
• Advanced knowledge of Performance Tuning and Optimization.
• Expertise in T-SQL programming, stored procedures, triggers, and functions.