Azure SQL DBA

Senior Software Engineer – (Azure SQL DBA)

Responsibilities

•  Responsible to understand the functionality of the existing system and underlying data architecture
•  Interact with different teams and identify the root cause of concerns/incidents
•  Responsible to analyze the scenario and provide appropriate solutions
•  Follow up and get issues fixed within SLA
•  Responsible for communicating effectively with other teams and stakeholders
•  Install, configure, maintain, and administer Azure SQL Database and SQL Server instances
•  Ensure that databases achieve maximum performance, availability, and security
•  Perform query tuning, index design/maintenance, and performance optimization (execution plans, wait stats, Query Store)
•  Design and implement high availability and disaster recovery
•  Write and maintain procedures for backup and disaster recovery; conduct periodic DR drills
•  Upgrade and patch databases; manage database deployments and refreshes across environments
•  Responsible for migrating client data to various environments with minimal downtime
•  Administer and support Azure Data Factory – monitor pipeline runs, troubleshoot failures, manage linked services, integration runtimes, and triggers
•  Administer Azure Databricks workspaces – cluster configuration and management, workspace access control, job monitoring, and troubleshooting failed jobs
•  Monitor database health and data platform services proactively; set up alerts using Azure Monitor / Log Analytics
•  Create logins, roles, and users; manage permissions and database security (encryption, auditing, firewall rules, Private Endpoints)
•  Manage access control across data platform services (Databricks workspace permissions, ADF access)
•  Write automation scripts using Powershell or Python for automation of repetitive tasks.
•  Working understanding of AI/GenAI concepts and hands-on use of AI-assisted tools (e.g., GitHub Copilot, Microsoft Copilot, Claude) to improve productivity in database administration, troubleshooting, and automation.
•  Keep clear documentation of database setup, architecture, and operational runbooks

Requirements

•  Minimum 4 years of experience in SQL Server / Azure SQL database administration and data modeling
•  Strong hands-on experience with Azure SQL Database, Azure SQL Managed Instance, and on-prem SQL Server administration
•  Expertise in performance tuning – query optimization, indexing strategies, execution plan analysis, and troubleshooting bottlenecks (CPU, memory, IO, blocking/deadlocks)
•  Experience administering systems that deal with large data sets and a high volume of transactions
•  Experience in optimizing insertions/loads of large amounts of data (bulk operations, partitioning)
•  Experience with high availability and disaster recovery
•  Experience administering and supporting Azure Data Factory – monitoring pipelines, troubleshooting failures, managing integration runtimes and linked services
•  Working knowledge of Azure Databricks administration – cluster management, workspace administration, job monitoring
•  Strong T-SQL skills for administration and troubleshooting
•  Experience with DevOps automation tools (PowerShell, shell scripting, Terraform, Azure DevOps)
•  Experience with Microsoft Azure (primary) | AWS | Google Cloud Platform
•  Experience with database security management (TDE, Always Encrypted, auditing, RBAC, vulnerability assessment)
•  Demonstrated analytical, problem-solving, presentation, and interpersonal skills to handle critical situations

Preferred

•  Experience with Azure Data Lake Storage (ADLS Gen2) and Azure Synapse administration
•  Exposure to NoSQL databases (MongoDB, Cosmos DB, Neo4j)
•  Experience with monitoring tools (Azure Monitor, Log Analytics etc.)
•  Azure certifications (DP-300: Azure Database Administrator, AZ-104: Azure Administrator)
•  Experience with Infrastructure as Code (Terraform / ARM templates)