Sr SQL DBA

Responsibilities:
1. Database Administration:
• Manage, monitor, and maintain Microsoft SQL Server databases, ensuring high availability and performance.
• Implement and manage Always-On AG to provide fault tolerance and high availability.
• Handle TB-sized databases, optimizing performance and resource utilization.
2. Sharding or Partitioning Experience:
• Design and implement database sharding strategies for efficient horizontal scaling.
• Monitor and manage sharded databases to ensure even distribution of data and optimal query performance.
3. Azure SQL Server:
• Experience in handling VM’s in Azure, Manage SQL Instances, and SQL Databases in Azure.
• Utilize Azure services for scalability, security, and performance enhancements.
4. Backup and Recovery:
• Develop and maintain robust backup and recovery strategies for large databases.
• Perform regular database backups and conduct periodic recovery tests to ensure data integrity.

5. Performance Tuning:
• Analyze and optimize query performance, indexing, and database configuration.
• Proactively identify and resolve performance bottlenecks to ensure optimal database responsiveness.
• Query Store experience required.
6. Security:
• Implement and enforce database security measures to protect sensitive data.
• Stay current with industry best practices and security trends to ensure databases are protected against potential threats.
7. Collaboration:
• Collaborate with cross-functional teams, including developers and system administrators, to address database-related issues and ensure smooth operations.
• Participate in the planning and execution of database-related projects.

Qualifications:
1. Bachelor's degree in Computer Science, Information Technology, or related field.
2. Proven experience as a Microsoft SQL Server Database Administrator.
3. In-depth knowledge of Always-On Availability Groups.
4. Experience managing TB-sized databases in a production environment.
5. Strong SQL scripting skills and expertise in performance tuning.
6. Familiarity with database security best practices.
7. Azure certifications and experience deploying SQL Server databases on Azure are a plus.
8. Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.