Remote IT Consultant

Summary

Join our team as an IT Support Consultant to provide ad-hoc assistance in managing and optimizing Microsoft SQL services and Azure Active Directory B2C integration. The ideal candidate will provide on-demand support for database management, query optimization, best practices, and system recovery, as well as help with Azure AD B2C integration with our tenant and Jira.

Requirements

• In-depth knowledge of Microsoft SQL Server
• Strong understanding of Azure Active Directory B2C, including integration with third-party systems like Jira
• Experience troubleshooting database and Active Directory issues, with a focus on rapid problem resolution
• Familiarity with database performance tuning, security measures, and general IT best practices
• Excellent analytical, problem-solving, and communication skills
• Ability to work independently and respond to urgent support requests on short notice

Responsibilities

• Provide support for the administration and maintenance of Microsoft SQL Server environments
• Manage backup, recovery, and updates to ensure consistent and reliable service delivery
• Assist with setup, configuration, and troubleshooting of SQL Reporting Services (SSRS)
• Optimize reporting tools to deliver accurate and timely data insights
• Develop, review, and optimize SQL queries for efficiency and performance
• Assist in creating complex queries, ensuring they follow best practices to minimize load times and resource usage
• Offer guidance on SQL Server best practices, including performance tuning, indexing, partitioning, and security
• Provide recommendations for database design and architecture improvements
• Provide immediate support in case of database outages or system downtime
• Troubleshoot and resolve issues quickly to restore services and minimize disruptions
• Assist with the integration of Azure Active Directory B2C with our tenant and Jira
• Provide guidance on identity management, multi-factor authentication, and user experience optimization
• Ensure that Azure AD B2C is configured following security and operational best practices

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field
• Proven experience with MS SQL administration and Azure AD B2C implementation and management
• Experience with Jira integration is highly preferred
• Certifications in Microsoft SQL, Azure, or Azure AD are a plus