MY SQL - Consultant

Greetings !!!

Role Overview :-

We are seeking an experienced MS SQL DBA Consultant with 5+ years of expertise in managing, administering, and optimizing Microsoft SQL Server environments. The consultant will be responsible for ensuring the performance, security, availability, and reliability of SQL Server databases across enterprise applications. The role requires hands-on experience with Always On Availability Groups, Clustering, Replication, Backup & Recovery, as well as migrations and upgrades. The consultant will also provide strategic guidance to improve database operations and efficiency.

Responsibilities :-

• Act as the SME for SQL Server Database Administration in consulting and managed services engagements.
• Install, configure, upgrade, and patch Microsoft SQL Server (2012/2016/2019/2022).
• Administer and maintain Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
• Perform proactive database monitoring, performance tuning, and query optimization.
• Implement and manage database backup and recovery strategies using SQL Server native tools.
• Troubleshoot and resolve database-related issues, ensuring minimal downtime and optimal performance.
• Manage security, roles, and user access to ensure compliance with enterprise policies.
• Support database migrations (on-premise, cross-version, and to cloud environments).
• Collaborate with development, application, and infrastructure teams to optimize database usage.
• Create operational documentation, SOPs, and provide knowledge transfer to support teams.
• Mentor junior DBAs and support complex database design decisions.
• Stay updated with SQL Server advancements and emerging database technologies

Requirements :-

• 5+ years of experience as a Microsoft SQL Server Database Administrator.
• Strong expertise in SQL Server 2012/2016/2019/2022 administration and troubleshooting.
• Hands-on experience with Always On Availability Groups, Clustering, Log Shipping, Replication.
• Proficiency in backup and recovery using SQL Server native tools and third-party solutions.
• Solid skills in performance tuning, query optimization, indexing, and execution plans.
• Experience with SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
• Familiarity with cloud-based SQL solutions (Azure SQL Database, AWS RDS for SQL Server).
• Strong T-SQL development and scripting (PowerShell preferred).
• Knowledge of database security, compliance, and auditing practices.
• Experience in database migration, consolidation, and upgrade projects.

Preferred :-

Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: SQL Server DBA.

Warm Regards,

Talent Acquisition Team

Deloitte