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 Solid 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 Good 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