Back to board
Early applicant
proarch-3·1 day ago

SQL Server Database Adminstrator

Hyderabad, IndiaRemoteContractSenior · 7+ years

About this role

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

Requirements

  • 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