Senior Cloud Database Adminstrator

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 issues—performance 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.