Senior Azure Cloud Database Administrator

Role Overview

An Azure Database Administrator specializes in managing and optimizing cloud-native

and hybrid database environments using Microsoft Azure data services. In this role, the

individual will be responsible to ensure optimal performance, robust security, seamless

scalability, and high availability across Azure SQL Database, SQL Server VMs, and

potentially NoSQL platforms such as Cosmos DB.

Key Responsibilities

• Provisioning & Configuration

Design, deploy, and configure Azure SQL Databases (PaaS/IaaS), including

selecting tiers, autoscaling, and managing instance settings.

• Performance Monitoring & Tuning

Use tools like Azure Monitor, Query Performance Insight, and SQL Analytics to

monitor performance, optimize queries, tune indexes, and resolve bottlenecks.

• Security & Compliance

Implement database security practices: RBAC, Transparent Data Encryption (TDE),

firewall configurations, vulnerability assessments, and auditing. Ensure compliance

(e.g. GDPR, HIPAA).

• Backup & Disaster Recovery

Configure automated backups, georeplication, highavailability (failover/replication),

and test recovery processes. Define recovery point/time objectives.

• Data Migration & Architecture Support

Plan and execute migration from onpremise to Azure SQL/VM, assist with data

warehousing and ETL setups (e.g. Azure Data Factory, Synapse).

• Automation & Infrastructure as Code

Automate routine tasks using PowerShell, Azure CLI, ARM templates, Terraform, or

Azure DevOps pipelines.

• Troubleshooting & Support

Diagnose database issuesperformance slowness, locking/blocking, backups, SQL

errors—and provide 24/7 critical-path support.

• Documentation & Reporting

Maintain detailed documentation (design diagrams, SOPs, change logs) and produce

database performance/capacity reports.

• Collaboration & Mentorship

Work closely with developers, DevOps, data engineers, system admins, and project

leads. Mentor junior DBAs and promote best practices.

• Always-On Availability

Design and establish Always-On Availability Groups, Windows Server Failover

Clustering to ensure high availability and disaster recovery capabilities. Configuring

clustering infrastructure, setting up shared storage, network configurations, and

quorum settings. Setup for peak performance by fine-tuning parameters like

synchronization modes, heartbeat intervals, and data replication settings to minimize

latency and maximize throughput. Adhere to industry best practices by applying

recommended configurations.

• Zone or Geo location wise replication hands-on experience.

Required Qualifications & Skills

• Experience: 10+ years managing SQL Server databases plus at least 5 years

administering Azure SQL in a professional setting.

• Technical Foundation: Proficiency in TSQL, PowerShell, Azure CLI, and database

management tools (SSMS, Azure portal).

• Core Expertise: Azure SQL Database architecture, performance tuning, security,

backups, HA/DR, and compliance frameworks.

• Tools & Services: Familiarity with Azure Monitor, Automation, SQL Analytics, Data

Factory, Synapse, Cosmos DB (optional).

• Automation & DevOps: Experience with scripting and automation (PowerShell,

ARM/Terraform, CI/CD pipelines).

• Soft Skills: Strong analytical, problem-solving, attention to detail, and

communication skills.

Preferred/Desirable

• Certifications: Microsoft Certified: Azure Database Administrator Associate

(DP300), Azure Solutions Architect, Azure Admin, or related.

• Industry Tools: ETL/BI tools like SSIS/SSRS/SSAS, Power BI, Data Factory, and

NoSQL experience (MongoDB, MySQL, etc.).

• Advanced Practices: Database partitioning, PolyBase, clustering, managing Elastic

Pools, autoscaling.

• Domain Experience: Prior work in industries with strict compliance needs (finance,

healthcare, education), or large-scale data environments.