Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
We are looking for a SQL Server Database Administrator with 3–6 years of experience in database administration and hands-on knowledge of Microsoft Azure cloud infrastructure. The role involves managing, maintaining, securing, and optimizing SQL Server environments, supporting production databases, and assisting with Azure infrastructure operations. Key Responsibilities
Install, configure, maintain, patch, and upgrade SQL Server instances (2016, 2019, and 2022).
Manage database backups, restores, recovery procedures, integrity checks, SQL Server Agent jobs, and routine maintenance activities.
Monitor database performance, capacity, storage, CPU, memory, disk I/O, blocking, deadlocks, and troubleshoot production issues.
Optimize SQL queries, stored procedures, indexes, and execution plans using Query Store, Extended Events, SQL Server Profiler, and monitoring tools.
Configure and support SQL Server Always On Availability Groups, high availability, disaster recovery, and failover activities.
Manage database security, including logins, users, roles, permissions, auditing, and access controls.
Support SQL Server databases hosted on Azure Virtual Machines and assist with on-premises to Azure database migrations.
Manage and troubleshoot Azure infrastructure, including virtual machines, managed disks, storage, virtual networks, subnets, NSGs, and VNet peering.
Monitor Azure infrastructure using Azure Monitor, Log Analytics, alerts, and Azure Backup.
Support access management and cloud security using Azure RBAC and Microsoft Entra ID.
Automate routine DBA activities using PowerShell and T-SQL.
Handle incident management, root cause analysis, change management, documentation, and production troubleshooting.
Collaborate with application, infrastructure, development, and DevOps teams and participate in production maintenance and on-call support.
Key Skills
3–6 years of hands-on experience in Microsoft SQL Server Database Administration.
Strong knowledge of SQL Server 2016, 2019, and 2022 installation, configuration, maintenance, and troubleshooting.
Expertise in database backup, recovery, performance tuning, indexing, and query optimization.
Experience with SQL Server Always On Availability Groups, High Availability, and Disaster Recovery.
Practical knowledge of Microsoft Azure cloud infrastructure, particularly Azure Virtual Machines and networking.
Experience with Azure Monitor, Log Analytics, Azure Backup, Azure RBAC, and Microsoft Entra ID.
Proficiency in T-SQL and PowerShell scripting.
Familiarity with SQL Sentry or similar database monitoring tools.
Knowledge of Terraform, Azure DevOps, CI/CD pipelines, and infrastructure automation is an added advantage.
Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
Azure certifications such as AZ-104 or DP-300 are preferred.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
