azure sql dba

ConfidentialHyderabad / Secunderabad, Telangana

30+ days ago

Job description

An Azure SQL DBA is responsible for managing and maintaining Azure SQL databases, ensuring optimal performance, security, and availability. This role requires a deep understanding of database administration principles and a strong proficiency in Azure SQL Server. You will be responsible for the full lifecycle management of Azure SQL databases, from design and implementation to monitoring, performance tuning, and security.

Key Responsibilities

Database Administration :
Design, implement, and manage Azure SQL databases , including configurations, security settings, and performance tuning.
Monitor database health, performance, and resource utilization .
Optimize database queries for efficiency and performance.
Implement backup and recovery strategies to protect data.
Manage user accounts and permissions .
Azure SQL Management :
Utilize Azure portal and Azure SQL tools for database management tasks.
Configure and manage high availability options like Always On Availability Groups and geo-replication .
Implement disaster recovery plans and test failover scenarios.
Manage Azure SQL Database elastic pools and database scaling .
Performance Tuning :
Identify and resolve performance bottlenecks .
Analyze query execution plans and optimize queries .
Implement indexing strategies to improve query performance.
Monitor resource usage and adjust configurations as needed.
Security :
Implement robust security measures to protect database data.
Manage user accounts, roles, and permissions .
Apply security patches and updates promptly.
Monitor for security threats and vulnerabilities .
Troubleshooting and Support :
Diagnose and resolve database-related issues .
Provide technical support to application developers and users.
Document troubleshooting steps and solutions .

Required Skills and Qualifications

7+ years of relevant experience as an Azure SQL DBA.

Deep understanding of Azure SQL Server architecture, features, and best practices .

Proficiency in SQL language and query optimization .

Experience with Azure portal and Azure SQL tools .

Knowledge of database backup and recovery strategies .

Familiarity with performance tuning techniques .

Understanding of security concepts and best practices .

Strong analytical and problem-solving skills .

Ability to work independently and as part of a team.

Excellent communication and interpersonal skills .

Attention to detail and accuracy.

Ability to adapt to new technologies and trends.

Preferred Qualifications

Certification in Azure SQL Database Administration .

Experience with cloud computing and virtualization .

Knowledge of scripting languages (e.g., PowerShell) .

Experience with data warehousing and business intelligence concepts .

Skills Required

Database Administration, Azure Sql, Performance Tuning, Troubleshooting, Interpersonal Skills, Analytical Techniques

Create a job alert for this search

Sql Dba • Hyderabad / Secunderabad, Telangana