SQL Server Subject Matter Expert

SQL Server Subject Matter Expert

Location :

You'll have the flexibility to work fully remote from anywhere across the United States.

Salary : $10k / month

Duration of contract : 18 months

Now is the time to bring your research expertise to an SQL Server SMErole for a Fortune 500 Solutions Integrator where success and fulfillment go hand in hand.

You'll be at the forefront of helping businesses transform their cloud, data, AI, cybersecurity, and analytics to ensure they are future-ready.

As an SQL Server Subject Matter Expert with Insight, you'll be a passionate self-starter who can work in a fast-paced environment, pay attention to detail, contribute to conceptual discussions and decisions, thrive working in both independently and in a team environment, as well as the ability to set timelines and estimate the work required to complete a task.

This role is within our Residency Offering, which is a solution that provides strategic technical resources to our customers on a contractual basis.

What to Expect

We're legendary for taking care of our teammates. We want you to enjoy a full, meaningful life and stick around Insight for the long haul.

As a W2 teammate, we offer great benefits that include health, 401K and In it Together Foundation. You will also have access to 11 thriving and diverse Teammate Resource Groups.

As an SQL Server SME, you'll get to :

• Provide Enterprise level support and administration focused specifically on Power BI, Power BI Embedded, SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability.
• Illustrate extensive experience with Power BI embedded skills, Power BI solution design, PBI embedded development skills, and Performance optimization skills
• Act as Subject Matter Expert on SQL Server (2012 and onwards), Power BI, DAX, Azure Data Factory, and Azure SQL DB.
• Be AmbITious : This opportunity is not just about what you do today but also about where you can go tomorrow. As a W2 contract teammate OCM Consultant, your position is highly visible and could lead to extended contracts, consideration for a full-time opportunity within Insight, or with our client to elevate your career.

What you will need to succeed :

• Power BI Solution design and embedded development
• Data modeling and database design , data warehouse concepts
• DAX, Power Query M Language, development and optimization
• Power BI Service, Power BI Desktop skills
• Data connectivity best practices to SQL, Oracle, MySQL, Azure, AWS and other services
• Custom visualizations
• Power BI Row Level security along with other Security features
• Indexing strategy
• Performance Optimization and Tuning Capabilities
• Partitioning data implementations
• Database schema creation and management
• Ensuring High availability and Disaster recovery
• SQL code reviews with ability to dissect query plan, T-SQL code
• Data Encryption
• Auditing
• Replication of data
• SQL Edition and version differences with discontinued and deprecated features
• Upgrade process
• Storage management techniques
• Data Engine Capacity planning
• General database management, Policy based management
• Extended events and Traces
• Basic Licensing and support scenarios
• Windows Failover Clustering
• SQL Server Reporting and Analysis Service

Insight at a Glance

• Received 35+ industry and partner awards in the past year
• $9.2 billion in revenue

20 on Fortune's World's Best Workplaces™ list

• 14,000+ engaged teammates
• Geo-specific award
• $1.4M+ total charitable contributions in 2023 by Insight globally

We're not just a tech company; we're a people-first company. We believe that by unlocking the power of people and technology, we can accelerate transformation and achieve extraordinary results.

As a Fortune 500 Solutions Integrator with deep expertise in cloud, data, AI, cybersecurity, and intelligent edge, we guide organizations through complex digital decisions.

But what really sets us apart are our core values of Hunger, Heart, and Harmony, which guide everything we do, from building relationships with teammates, partners, and clients to making a positive impact in our communities.

Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.