Job Summary:
We are looking for an experienced MS SQL Server DBA with 5+ years of hands-on experience in managing, maintaining, and optimizing SQL Server environments. The candidate will be responsible for ensuring database performance, availability, security, and reliability across production and non-production systems.
Key Responsibilities:
- Install, configure, and maintain Microsoft SQL Server databases.
- Monitor database performance and implement tuning (queries, indexes, execution plans).
- Manage backup, restore, and disaster recovery processes.
- Ensure high availability using Always On, clustering, or replication.
- Implement and maintain database security (users, roles, permissions).
- Troubleshoot database issues and support application teams.
- Perform regular maintenance (patching, upgrades, health checks).
- Develop and maintain automation scripts for routine tasks.
Required Skills:
- 5+ years of experience with MS SQL Server (2016/2019/2022).
- Strong knowledge of T-SQL, performance tuning, and indexing.
- Experience with High Availability & Disaster Recovery (HA/DR).
- Good understanding of Windows Server and networking basics.
- Familiarity with monitoring tools and backup solutions.
Preferred Skills:
- Experience with Azure SQL / Cloud environments.
- Knowledge of PowerShell scripting.
- Exposure to SSIS, SSRS, SSAS.
Key Competencies:
- Strong troubleshooting and analytical skills
- Ability to work under pressure
- Good communication and documentation skills