MY SQL - Consultant

5 - 9 years

6 - 11 Lacs

Posted:1 week ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

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

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

hyderabad, coimbatore, bengaluru

hyderabad, chennai, bengaluru