SME - AzureMSSQL DBA, Microsoft Azure

10 years

India

Posted:7 hours ago

Job Description

Job Summary

Job Summary : \"We are looking for an experienced Senior Microsoft SQL Server Database Administrator with 10+ years of hands-on experience managing large-scale, business-critical SQL Server environments. The ideal candidate will have strong expertise in SQL Server administration, Always On Availability Groups, clustering, performance tuning, backup and recovery, database security, migrations, automation, troubleshooting, and high availability/disaster recovery solutions. Experience with Microsoft Azure and hybrid database environments is highly desirable.
Job Description : \\\\\\\"• 10+ years of hands-on Microsoft SQL Server database administration experience.\\\\r\\\\n• Strong experience supporting enterprise production SQL Server environments.\\\\r\\\\n• Experience administering multiple versions of SQL Server in large or complex environments.\\\\r\\\\n• Strong hands-on experience with Always On Availability Groups and HA/DR technologies.\\\\r\\\\n• Proven expertise in database performance troubleshooting and tuning.\\\\r\\\\n• Experience managing large databases and high-transaction workloads.\\\\r\\\\n• Experience planning and executing SQL Server migrations and upgrades.\\\\r\\\\n• Strong understanding of database security, access management, and auditing.\\\\r\\\\n• Experience handling critical production incidents and performing RCA.

Key Responsibilities

Job Responsibilities : \"SQL Server Administration • Install, configure, patch, upgrade, and administer Microsoft SQL Server environments. • Manage SQL Server instances and databases across Development, UAT, Staging, and Production environments. • Perform database refreshes, restores, migrations, upgrades, and server consolidation activities. • Manage database files, filegroups, storage capacity, SQL Server Agent jobs, linked servers, and database configurations. • Maintain database standards, documentation, operational procedures, and runbooks. High Availability & Disaster Recovery • Design, implement, administer, and troubleshoot SQL Server Always On Availability Groups. • Manage Windows Server Failover Clustering (WSFC) and SQL Server Failover Cluster Instances where applicable. • Support synchronous and asynchronous replicas, automatic/manual failover, listener configuration, and read-only routing. • Work with clusterless/read-scale Availability Group architectures where appropriate. • Design and maintain backup, recovery, DR, RPO, and RTO strategies. • Participate in scheduled DR drills and validate database recoverability. Performance Monitoring & Tuning • Troubleshoot complex performance issues involving CPU, memory, disk I/O, blocking, deadlocks, waits, and query execution. • Analyze execution plans and optimize poorly performing SQL queries. • Perform index analysis, statistics maintenance, fragmentation management, and database health checks. • Use tools such as Query Store, Extended Events, Dynamic Management Views (DMVs), Performance Monitor, and SQL Server execution plans. • Identify database performance bottlenecks and provide long-term remediation rather than temporary fixes. Backup, Recovery & Maintenance • Design and manage Full, Differential, and Transaction Log backup strategies. • Perform point-in-time database recovery when required. • Regularly test database backups and recovery procedures. • Configure and monitor integrity checks using DBCC CHECKDB. • Design and maintain database maintenance and housekeeping processes. Security & Compliance • Administer SQL Server logins, database users, roles, permissions, and schemas. • Implement the principle of least privilege and role-based access controls. • Manage Windows/Active Directory authentication and SQL authentication. • Support encryption technologies such as Transparent Data Encryption (TDE) and TLS where required. • Conduct database access and permission reviews. • Assist security and audit teams with database compliance requirements and remediation. Migration & Upgrades • Plan and execute SQL Server version upgrades and database migrations with minimal downtime. • Perform compatibility assessments and post-migration validation. • Support migrations between physical, virtual, cloud, and hybrid SQL Server environments. • Participate in on-premises to Microsoft Azure migration initiatives. • Support Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure Virtual Machines where applicable. Automation & Scripting • Automate recurring database administration activities using: o T-SQL o PowerShell o SQL Server Agent • Develop scripts for monitoring, health checks, database deployment, backup validation, capacity management, and operational reporting. • Reduce manual DBA activities through standardization and automation. Production Support • Provide Level 3 support for critical database incidents. • Diagnose and resolve production database outages and performance degradation. • Participate in an on-call support rotation where required. • Perform root cause analysis for Sev-1/Sev-2 incidents and implement permanent corrective actions. • Coordinate with application, infrastructure, Windows, storage, network, security, and cloud teams during major incidents and changes.

Skill Requirements

Skill Requirement : \"Technology / Skill Expected Expertise Microsoft SQL Server Expert SQL Server Administration Expert Always On Availability Groups Expert WSFC / Failover Clustering Advanced T-SQL Advanced Performance Tuning Expert Execution Plan Analysis Advanced Backup & Recovery Expert Database Security & Permissions Advanced SQL Server Agent Advanced Query Store / DMVs / Extended Events Advanced PowerShell Automation Intermediate to Advanced Database Migration & Upgrades Advanced Azure SQL Desirable Azure SQL Managed Instance Desirable SQL Server on Azure VM Desirable

Must Have Skill
Microsoft Azure,MS SQL,Azure MSSQL DBA,Iaas - Azure
Good to Have Skill
Other Requirements

Other Requirement : \"• 10+ years of hands-on Microsoft SQL Server database administration experience. • Strong experience supporting enterprise production SQL Server environments. • Experience administering multiple versions of SQL Server in large or complex environments. • Strong hands-on experience with Always On Availability Groups and HA/DR technologies. • Proven expertise in database performance troubleshooting and tuning. • Experience managing large databases and high-transaction workloads. • Experience planning and executing SQL Server migrations and upgrades. • Strong understanding of database security, access management, and auditing. • Experience handling critical production incidents and performing RCA.

Skills Required

Microsoft Azure SQL Server Performance Tuning Backup and Recovery Database Security Automation Troubleshooting High Availability Disaster Recovery Database Administration Access Management Auditing

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
HCLTech logo
HCLTech

Information Technology Services

New Delhi

RecommendedJobs for You