Azure SQL Database consultant with Security
Location; Remote
Design and Implement a strategy to secure and protect an Azure SQL database, that will serve as an internal-only reporting database (e.g. so the client can build PowerBI dashboards for various departments such as HRIS, GL, Finance, etc.).
Securing the Azure SQL DB will involve:
- Data/Information Protection
- Encrypt data at rest and in transit
- Secure based on various security contexts and personas (Different for each department)
- AD Security and policies
- Audit and Logging
- As well as other aspects of security, such as:
- Create server-level and database-level firewall rules
- Configure an Azure Active Directory (Azure AD) administrator
- Manage user access with SQL authentication, Azure AD authentication, and secure connection strings
- Enable security features, such as Microsoft Defender for SQL, auditing, data masking, and encryption
- Limit access using firewall rules
- Use authentication mechanisms that require identity
- Use authorization with role-based memberships and permissions
- Enable security features