Lead Consultant – SQL Server

0 years

0 Lacs

Posted:2 days ago| Platform: Foundit logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Inviting applications for the role of Lead Consultant- SQL Server

We are looking for an experienced Lead Consultant - SQL Server to lead end-to-end SQL Server database solutions for enterprise clients. The role requires strong technical leadership, solution architecture, performance optimization, and client consulting capabilities in mission-critical environments.

Responsibilities


  • Design, implement, and maintain SQL Server database infrastructure across development, testing, and production environments.


.Lead the architecture and deployment of high availability (HA) and disaster recovery (DR) solutions using AlwaysOn, Log Shipping, and Clustering.

.Perform performance tuning, query optimization, and indexing to ensure optimal database performance.

.Lead database migration projects, including upgrades and cloud/on-prem transitions.

.Develop and implement backup strategies, disaster recovery plans, and maintenance plans.

.Collaborate with application and infrastructure teams to ensure secure, scalable, and optimized database solutions.

.Guide clients on SQL Server licensing, capacity planning, and infrastructure cost optimization.

.Provide technical leadership, mentoring junior DBAs and developers.

.Drive automation of routine DBA tasks using PowerShell, T-SQL, or other scripting tools.

.Document database designs, best practices, troubleshooting guides, and client handover materials.

Qualifications we seek in you!

Minimum Qualifications / Skills


  • Bachelor%27s degree in information technology, Computer Science, or a related field.


.Expertise in SQL Server versions 2012 through 2019/2022.

.Strong knowledge of SQL Server AlwaysOn Availability Groups, Failover Clustering, Log Shipping, and Replication.

.Deep experience in performance tuning, execution plan analysis, and query optimization.

.Experience with backup/restore strategies, database security, and encryption methods.

.Hands-on experience with PowerShell, T-SQL scripting, and job automation.

.Exposure to SSRS, SSIS, SSAS and reporting/ETL tools.

.Knowledge of cloud platforms (Azure SQL Database, AWS RDS, or Google Cloud SQL) and hybrid deployments.

.Strong consulting, documentation, and client communication skills.

Preferred Qualifications/ Skills


  • Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server.


.Experience working in IT consulting, managed services, or client delivery models.

.Familiarity with DevOps tools, CI/CD pipelines for database deployments, and version control tools (e.g., Git)

.

.

.

.

.

.


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
Genpact logo
Genpact

Business Consulting and Services

New York NY

RecommendedJobs for You

Bengaluru, Karnataka, India