Azure SQL DB Administration (Australia Shift)
ITC Infotech
Job Description
Azure SQL AdministrationLocation: BangaloreMode: HybridShift : Australia Shift (4:30 AM to 1:00 PM IST) Job Description: Manage Azure database services including: Azure SQL Database Azure SQL Managed Instance SQL Server on Azure VMConfigure: Azure Backup Geo-replication Failover groups Private endpoints and networking Monitor workloads using: Azure Monitor Log Analytics Query Performance Insight Optimize cost and performance of Azure SQL workloads Backup, Recovery, and DR Design and maintain backup strategies Perform database restore testing Implement disaster recovery solutions Support business continuity planning Performance Automation Troubleshoot blocking, deadlocks, and slow queriesUse tools like: SQL Profiler Extended Events DMVs Automate tasks using: PowerShell T-SQL scripting Azure Automation Runbooks Implement monitoring and alertingPatching Compliance Apply SQL Server CUs, service packs, and security patches Ensure compliance with security and audit standardsSupport audit and vulnerability remediation activities Incident Problem ManagementAct as L3 escalation point for database incidentsPerform root cause analysis RCA Support production releases and maintenance windowsRequired Skills:Core Technical Skills Microsoft SQL Server Administration5-8+ years T-SQL performance tuningHigh Availability Disaster Recovery HADRSQL Server security and encryptionBackup and restore strategiesWindows Server administration basicsAzure Skills Mandatory Azure SQL DatabaseAzure SQL Managed Instance Azure VM-based SQL ServerAzure Backup and Monitoring Azure networking fundamentals ScriptingAutomation PowerShell T-SQL automation Azure CLI preferred