Microsoft Azure (Required): Advanced proficiency in Azure SQL Database, SQL Managed Instances, Azure Databricks, Cosmos DB, Power BI, Fabric, and related services.
Amazon Web Services (AWS) (Optional): Familiarity with database services such as Amazon Aurora (SQL Server, MySQL, PostgreSQL), Oracle, and Amazon EMR.
Google Cloud Platform (GCP) (Optional): Basic knowledge of Cloud SQL, Cloud Spanner, Bigtable, and BigQuery.
Key Responsibilities
Configure and manage databases on Azure, including SQL Databases, Managed Instances, Cosmos DB, and Azure Database for MySQL/PostgreSQL.
Lead migration of on-premises databases to Azure, ensuring minimal downtime and enhanced performance through cloud-native features.
Monitor and optimize performance using Azure SQL Analytics, SSMS, and Query Performance Insights.
Implement automated backup strategies and disaster recovery plans to ensure data integrity and high availability.
Enforce security policies including encryption, access control, authentication, and authorization.
Apply updates, patches, and hotfixes to both on-premises and cloud-hosted databases.
Design and support high availability solutions such as Always-On Availability Groups, geo-replication, and failover clusters.
Analyze database usage and scale infrastructure to meet growing performance demands.
Automate recurring tasks with Azure Automation, PowerShell, and other scripting tools.
Troubleshoot and resolve database issues related to performance, downtime, or security.
Continuously monitor database health and performance using Azure Monitor, Log Analytics, SolarWinds, and similar tools.
Required Qualifications
Minimum 10 years of on-premises SQL Server database administration experience in large enterprise environments.
Minimum 5 years of hands-on experience with SQL Server in an Azure environment (Azure SQL, Managed Instances, or SQL VMs).
Proven expertise with Always-On Availability Groups, failover clustering, and DR/HA strategies.
Experience in securing databases and ensuring compliance with industry standards (HIPAA, SOC, PCI, PII).
Strong skills in performance tuning, query optimization, and index management.
Education
Bachelor’s degree in Computer Science or a related field