**Job Description:**
We are seeking an experienced SQL DBA with at least 10+ years of experience managing production-critical databases and servers. The ideal candidate will be a subject matter expert in performance tuning, with hands-on experience in encryption technologies such as Always Encrypted and TDE.
**Key Responsibilities:**
1. **Performance Tuning:** SME-level expertise in SQL Server performance tuning.
2. **Encryption:** Hands-on experience with Always Encrypted and TDE.
3. **High Availability:** Expertise in SQL Always-on technologies, including troubleshooting on the latest versions.
4. **Upgrade & Migration:** Proficiency in upgrading and migrating databases to the latest versions.
5. **Database Administration:** Manage SQL Server versions from 2016 to 2019/2021, including maintenance, security, upgrades, and performance tuning.
6. **Installation & Configuration:** Install, configure, and upgrade SQL Server; apply service packs as needed.
7. **Disaster Recovery:** Extensive experience in designing and managing disaster recovery and high availability solutions.
8. **Backup & Recovery:** In-depth knowledge of all MS SQL Server backup and recovery scenarios, including backing up and restoring databases.
9. **Identification & Monitoring:** Use native tools like Profiler, Perfmon, dynamic management views, custom stored procedures, and third-party tools for identification and monitoring.
10. **Security Administration:** Manage server and database security effectively.
**Preferred Candidates:**
- Early or immediate joiners, preferably internal HCL resources.
