Job Description
Job Summary
Seeking experienced SQL Server professionals (2-12 years) with strong expertise in on-prem SQL Server and Azure SQL for design, administration, performance, HA/DR, migration, and optimization of mission-critical databases.
Key Responsibilities- Install, configure, upgrade, patch, and maintain SQL Server instances.
- Design and implement high availability/disaster recovery: Always On Availability Groups, Failover Cluster Instances, Log Shipping, Database Mirroring, and Azure Site Recovery.
- Perform advanced performance tuning: query optimization, indexing strategies, statistics, execution plans, DMVs, Extended Events, and Query Store.
- Manage database backups, restores, point-in-time recovery, and automated backup strategies.
- Monitor and troubleshoot database performance using SQL Server Profiler, Performance Monitor, Azure Monitor, Log Analytics, and Dynamic Management Views.
- Implement security: Transpar...