Role Overview
We are seeking a skilled SQL Server DBA responsible for managing, optimizing, and maintaining enterprise SQL Server environments. This role focuses on ensuring high availability, performance tuning, data replication, and analytical services support.
Key Responsibilities
Database Administration
- Install, configure, upgrade, and patch Microsoft SQL Server
- Manage databases across development, test, and production environments
- Perform backup and recovery operations
- Monitor database performance, availability, and storage utilization
High Availability & Disaster Recovery
- Design, implement, and support HA/DR solutions including:
- SQL Server Always On Availability Groups
- Failover Cluster Instances (FCI)
- Log Shipping and Database Mirroring
- Ensure minimal downtime and data loss (RPO/RTO objectives)
- Conduct regular DR testing and failover drills
Replication
- Configure and manage SQL Server Replication (Transactional, Snapshot, Merge)
- Monitor replication latency and troubleshoot failures
- Ensure data consistency across distributed systems
SSAS (SQL Server Analysis Services)
- Design, develop, and maintain SQL Server Analysis Services solutions
- Build and manage Tabular and Multidimensional models
- Optimize cube processing and query performance
- Support business intelligence and reporting teams
Performance Tuning
- Analyze and optimize slow-running queries using execution plans
- Implement indexing strategies and partitioning
- Monitor using DMVs, Query Store, and performance tools
- Identify and resolve blocking, deadlocks, and resource bottlenecks
Security & Compliance
- Manage logins, users, roles, and permissions
- Implement data encryption and auditing
- Ensure compliance with organizational and regulatory standards
Automation & Maintenance
- Create and maintain SQL Agent jobs
- Automate routine DBA tasks using PowerShell/T-SQL
- Maintain maintenance plans for backups, index rebuilds, and statistics updates
Required Skills
- Strong experience with Microsoft SQL Server (2016/2019/2022 or later)
- Hands-on expertise in:
- High Availability (Always On, Clustering)
- Replication
- SSAS (Tabular/Multidimensional)
- Query tuning and performance optimization
- Proficiency in T-SQL and troubleshooting
Preferred Qualifications
- Experience with Azure SQL (Managed Instance, Azure SQL DB)
- Familiarity with SSIS and SSRS
- Knowledge of monitoring tools (Redgate, SolarWinds, Sentry One)
- Microsoft certifications (e.g., Azure Database Administrator Associate)
