Technical Proficiencies:

Deep expertise in SQL Server Management Studio (SSMS) and underlying database internals.

Advanced command of Transact-SQL (T-SQL) language syntax.

Experience implementing SQL Server Integration Services (SSIS) packages and Extract, Transform, Load (ETL) workflows.

Experience supporting Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.

Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure role-based access control.

Experience migrating and integrating databases between on-premises SQL Server and Azure environments.

Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities.

Hands-on familiarity with third-party monitoring and backup tools, such as Redgate.

Requirements

Skill

Required / Desired

Amount

of Experience

College degree

Required

Years

Performance Monitoring & Tuning

Required

Years

Security & Compliance: Implement strict role-based access control (RBAC)

Required

Years

Developer Support & Code Review

Required

Years

dedicated hands-on experience managing enterprise-level Microsoft SQL Server database environments, including on-premises and Azure-based platforms.

Required

Years

Erforderliche Kompetenzen

SQL Server Management Studio (SSMS) and database internalsTransact-SQL (T-SQL) programmingSQL Server Integration Services (SSIS) and ETL developmentAdministration of Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMsAzure Monitor and Log AnalyticsMicrosoft Entra ID (Azure AD), Azure Key Vault, and Azure role-based access control (RBAC)Database migration and integration between on-premises SQL Server and AzureAzure database security, networking, scalability, cost optimization, and HA/DR capabilitiesThird-party monitoring and backup tools (e.g., Redgate)Performance monitoring and tuning for SQL ServerSecurity and compliance implementation (strict RBAC)Developer support and SQL code reviewEnterprise-level Microsoft SQL Server database administration (on-premises and Azure)

Ähnliche Stellen