12 Nov
|
Embee Software
|
Mumbai
12 Nov
Embee Software
Mumbai
Senior Software Engineer – (Azure SQL DBA)
Roles & 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
Required Skills
Technical Skills / Experience 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
Positive To Have Skills
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)
Location: Mumbai - EMBI, Mumbai, Maharashtra, India
📌 Azure SQL DBA (Mumbai)
🏢 Embee Software
📍 Mumbai