SQL Server Database Administrator
P
ProArchDatabase Management
Hyderabad, Telangana, IndiaContractSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 7+ years
- Required Skills
- Microsoft SQL Server
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 using T-SQL and 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.
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 such as Always On Availability Groups, Failover Clusters, Log Shipping, Replication, and 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 including Azure SQL Database, Managed Instance, and SQL on Azure VM.
- Drive incident resolution, root cause analysis (RCA), and long-term preventive improvements.
View Full Description & ApplyYou'll be redirected to the employer's site
