SQL Server Database Adminstrator

ProArch; Hyderabad; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

ProArch is seeking an experienced SQL Server Database Administrator to manage and optimize enterprise SQL Server environments in Hyderabad. The role requires hands-on expertise in performance tuning, HA/DR, automation, Azure SQL platforms, and production support.

You will work across production and non-production systems, implement robust backup/recovery and disaster recovery drills, and collaborate with cross-functional teams to deliver controlled deployments and proactive health checks.

Qualifications

• 7+ years of hands-on SQL Server DBA experience in production environments.
• Experience with high availability, disaster recovery, and performance tuning.
• Strong scripting skills (T-SQL, PowerShell) and automation experience.

Responsibilities

• Manage SQL Server environments (2012-2022) and production/non-production systems.
• Perform advanced performance tuning using execution plans, DMVs, and wait statistics.
• Design and maintain backup/recovery strategies and disaster recovery drills.
• Implement and support HA/DR solutions (Always On, FCI, Log Shipping, Replication, CDC).
• Automate routine maintenance and monitoring tasks using T-SQL, SQL Agent, and PowerShell.
• Support Azure SQL workloads (Azure SQL Database, Managed Instance, SQL on Azure VM).
• Drive incident resolution, RCA, and long-term improvements.
• Collaborate with development, infrastructure, and security teams for controlled deployments.

Skills

SQL Server

Performance tuning

HA/DR

Automation

Azure SQL

PowerShell

T-SQL

Security/compliance

Education

Bachelor's degree in Computer Science/IT

Tools

DMVs

Query Store

Always On Availability Groups

Failover Clustering

Log Shipping

Replication

CDC

SQL Agent

Job description

We are seeking an experienced and highly skilled SQL Server Database Administrator to manage, optimize, and secure enterprise SQL Server environments. This role requires strong hands-on expertise in performance tuning, high availability and disaster recovery (HA/DR), automation, Azure SQL platforms, and production support.

Key Responsibilities

• Manage and support SQL Server environments (2012-2022) across production and non-production systems
• Perform advanced performance tuning using execution plans, Query Store, DMVs, and wait statistics
• Troubleshoot complex database issues including locking, blocking, deadlocks, memory grants, TempDB, and I/O bottlenecks
• Design and maintain robust backup and recovery strategies, including point-in-time recovery and disaster recovery drills
• Implement and support HA/DR solutions (Always On Availability Groups, Failover Clusters, Log Shipping, Replication, CDC)
• Execute SQL Server upgrades, patching, and version migrations with minimal downtime
• Implement and maintain SQL Server security features including TDE, encryption, auditing, and role-based access control
• Automate routine maintenance and monitoring tasks using T-SQL, SQL Agent, and PowerShell
• Support Azure SQL workloads (Azure SQL Database, Managed Instance, SQL on Azure VM)
• Drive incident resolution, root cause analysis (RCA), and long-term preventive improvements
• Collaborate with development, infrastructure, and security teams for controlled production deployments and CI/CD initiatives
• Focus on proactive monitoring, capacity planning, and regular performance health checks

• 7+ years of hands-on SQL Server DBA experience in production environments
• Strong expertise in SQL Server architecture and internals (Buffer Pool, Plan Cache, Transaction Log, TempDB)
• Advanced query and server-level performance tuning skills
• Deep understanding of Always On AGs, FCI, Replication, CDC, and Log Shipping
• Strong experience with backup, restore, and disaster recovery scenarios
• Solid knowledge of SQL Server security and compliance controls
• Experience with automation and scripting (T-SQL, PowerShell)
• Working knowledge of Azure SQL and monitoring tools
• Bachelor's degree in Computer Science, IT, or related field (or equivalent experience)
• Strong troubleshooting ability, communication skills, and ownership mindset