Senior SQL Server DBA with Azure Data Factory (ADF)

12 years

25 - 30 Lacs

Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

Remote

Job Type

Contractual

Job Description

Job Title:

Senior SQL Server DBA with Azure Data Factory (ADF) Expertise

Experience:

8–12 Years

Location:

Remote

Engagement Type:

Contract

Role Overview

We are seeking an experienced

SQL Server Database Administrator (DBA)

with strong expertise in

Azure Data Factory (ADF)

to design, develop, and maintain data integration pipelines, support

SSIS-to-ADF migration

, and ensure optimal database performance across on-premise and Azure environments. The ideal candidate will combine deep SQL Server administration experience with hands-on cloud data integration and automation skills.

Key Responsibilities

  • Design, develop, and maintain ADF pipelines for data ingestion, transformation, and orchestration.
  • Lead or support migration of SSIS packages to Azure Data Factory.
  • Administer and manage SQL Server databases (on-premise and Azure SQL DB).
  • Optimize SQL queries, indexes, and stored procedures for maximum performance and scalability.
  • Implement and maintain backup, recovery, and high-availability strategies.
  • Integrate ADF with Azure services including Blob Storage, Key Vault, and Synapse Analytics.
  • Collaborate with infrastructure, DevOps, and data engineering teams to support deployment and automation.
  • Monitor performance using native and third-party tools, resolving database issues proactively.
  • Support CI/CD implementation for ADF pipelines and SQL deployments using Azure DevOps.
  • Automate operational workflows using Logic Apps, PowerShell, or Python scripts.

Required Skills & Qualifications

  • 8–15 years of experience in SQL Server Database Administration and performance tuning.
  • Strong experience in Azure Data Factory (ADF) – pipelines, data flows, and linked services.
  • Hands-on experience with SSIS and SSIS-to-ADF migration projects.
  • Advanced proficiency in T-SQL, query optimization, and index management.
  • Solid understanding of Azure ecosystem – Azure SQL, Blob Storage, Key Vault, Synapse Analytics.
  • Experience in automation and CI/CD using Azure DevOps, Logic Apps, or PowerShell.
  • Strong troubleshooting, analytical, and communication skills.
  • Experience with backup, restore, and disaster recovery in hybrid environments.

Preferred Qualifications

  • Microsoft Certified: Azure Database Administrator Associate or Azure Data Engineer Associate.
  • Experience with monitoring tools (e.g., Azure Monitor, Log Analytics).
  • Exposure to data security and compliance frameworks in Azure.
  • Familiarity with infrastructure as code (ARM/Bicep/Terraform) is a plus.
Skills: sql server,sql,automation,database,azure,data,pipelines

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps 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 Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You