Key Facts

Remote From:

Freelance

English

Hard Skills

Data Encryption SQL Azure Database Security Azure Active Directory Data Security Context-Based Access Controls Data Masking Microsoft Business Intelligence Role-Based Access Control (RBAC) Database Security Azure Security Well Logging Auditing Privileged Access Management Azure Active Directory Identity And Access Management

Roles & Responsibilities

Experience designing and implementing security for Azure SQL Database, including encryption at rest and in transit, auditing, and Defender for SQL
Proficiency with Azure Active Directory integration, AD security policies, authentication methods (SQL authentication and Azure AD), and RBAC-based access control
Hands-on experience configuring server- and database-level firewall rules, secure connection strings, and managing access across departments
Knowledge of data masking, encryption, and secure authentication/authorization practices and ability to document security controls

Requirements:

Design and implement a security strategy for an internal Azure SQL Database used for Power BI reporting
Configure and manage firewall rules (server and database level), Azure AD administrator, and authentication/authorization mechanisms
Enable and monitor security features such as Defender for SQL, auditing, data masking, encryption, and enforce RBAC-based access controls
Establish AD security policies, conduct access audits, and produce security documentation for compliance

Georgia IT, Inc.

About Georgia IT, Inc.

Georgia IT, Inc. provides IT Consulting for a wide range of IT services and custom build turn-key enterprise solutions. GIT specializes in improving business scalability and efficiency through BSM and SBA Solutions. GIT transforms business with service management and service automation solutions. We are BMC & HP partners. GIT Services include custom built enterprise software and customer-centric web portals, network design and implementation, remote and site-to-site VPN, network and server security assessment and setup, server and desktop virtualization, and many others. GIT also provides IT Consulting in many areas such as Disaster Recovery Planning, Enterprise Data Backup Strategy, Long Term Strategic IT Planning and Augmentation Professional Services Solutions. Professional Services Specialties: Business Process Integration, Software Integration & Development, Web portal, Networking, Remote and site-to-site VPN, Virtualization Solutions, Product Development Please contact us Hrus@georgiait.com / uthay@georgiait.com/470-798-5000 x 1010 / (732) 890-2535 direct

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Job Title : Azure SQL Database consultant with Security
Location : Remote
Position Type : Contract
US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp.
Job Description:
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