Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

IT Consultant

Remote: 
Full Remote
Contract: 
Freelance
Experience: 
Mid-level (2-5 years)
Work from: 
United States

Offer summary

Qualifications:

Bachelor’s degree in Computer Science or IT, Proven experience with MS SQL administration, Experience with Azure AD B2C integration, Familiarity with Jira integration preferred, Certifications in SQL, Azure, or Azure AD a plus.

Key responsabilities:

  • Support MS SQL Server administration and maintenance
  • Assist with SQL Reporting Services setup and troubleshooting
  • Develop and optimize SQL queries for performance
  • Advise on SQL best practices and database design
  • Provide assistance during database outages
MetroSys, Inc. logo
MetroSys, Inc. Information Technology & Services SME https://www.metro-sys.com
11 - 50 Employees
About MetroSys, Inc.
MetroSys is a I.T. Professional Services company based in sunny San Diego, CA. Established in 2006, MetroSys has technical talent supporting the Americas. Our Mission Statement; To simplify our customers’ business solutions while having fun with what we do. Our creative geniuses have been pioneering data solutions for our valued customers and partners in the following areas: Data Mobility: Enterprise Storage, Cloud Migrations, Systems Integration & Installation: Storage, Networking, Virtualization, Database, Messaging Flexible Workforce: Recruiting, Staffing, Direct Placement Assessment Services: Storage, Networking, Performance, Periodic, Get Healthy ingenuity. Agility. Speed. These are key ingredients to our success. Navigating the world of I.T. Professional Services can pose many challenges. We help customers, channel partners, resellers & manufacturers deliver! Our team of highly experienced professionals can help bridge any gap for your I.T. requirements. Whether assistance with pre-sales or post-sales services, recruiting, or assisting with the launch of emerging technologies, We CAN Help! Great people. Great Company. MetroSys has carefully crafted its team of highly skilled talent by not only hiring industry experts, but by selecting people that share our view on company culture. Our core values include teamwork, integrity, accountability, & embracing diversity. Our customer first approach builds strong relationships as a trusted advisor and technology partner. Our team integrates with your business and maximizes efficiency. Simply put, we make it easy. For more information, please visit our website @ http://www.metro-sys.com
See more MetroSys, Inc. offers

Job description

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.

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Industry :
Information Technology & Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

SQL Server Reporting ServicesQuery OptimizationAzure Active DirectoryJIRADatabase TuningMicrosoft SQL ServersPhysical SecurityDatabase ManagementAzure Security

Other Skills

  • Problem Solving
  • Analytical Skills
  • Verbal Communication Skills
Are you interested?

IT Consultant Related jobs

See more IT Consultant jobs