IT Consultant

Remote
Contracted
Mid Level

Job Overview:
We are seeking an experienced IT Support Consultant for ad-hoc assistance in managing and optimizing our 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 Active Directory B2C integration with our tenant and Jira.


Key Responsibilities:

MS SQL and Associated Services:

  1. SQL Server Maintenance & Support:

    • Provide support for the administration and maintenance of Microsoft SQL Server environments.
    • Manage backup, recovery, and updates to ensure consistent and reliable service delivery.
  2. Reporting Services:

    • Assist with setup, configuration, and troubleshooting of SQL Reporting Services (SSRS).
    • Optimize reporting tools to deliver accurate and timely data insights.
  3. Query Formation & Optimization:

    • 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.
  4. Best Practices Advisory:

    • Offer guidance on SQL Server best practices, including performance tuning, indexing, partitioning, and security.
    • Provide recommendations for database design and architecture improvements.
  5. System Down/Recovery Assistance:

    • Provide immediate support in case of database outages or system downtime.
    • Troubleshoot and resolve issues quickly to restore services and minimize disruptions.

Azure Active Directory B2C:

  1. Azure AD B2C Integration:

    • 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.
  2. Configuration & Best Practices:

    • Ensure that Azure AD B2C is configured following security and operational best practices.
    • Offer strategic input for improving identity management and enhancing seamless integrations.

Knowledge, Skills, and Abilities:

  • In-depth knowledge of Microsoft SQL Server, SQL Reporting Services (SSRS), and query optimization.
  • 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.

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.
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*