MemSQL Data Modeling Expert

Posted 10 Days Ago
Be an Early Applicant
Dallas, TX, USA
In-Office
Senior level
Information Technology • Professional Services • Consulting
The Role
Design and model data in MemSQL (row and column stores), optimize SQL and stored procedures for performance, debug MemSQL performance issues, recommend columnar load optimizations, develop solution patterns, data flow diagrams and architectural specs, integrate with ETL tools, present solutions to technical and business stakeholders, and manage client deliverables independently.
Summary Generated by Built In
Company Description

Halo Group is a premier provider of IT talent. We place technology experts within
the teams of the world’s leading companies to help them build innovative
businesses that keep them one step closer to their customers and one step
ahead of the competition. We offer a meaningful work environment for
employees, attractive and interesting engagements for consultants, and cutting-edge
digital innovation for our customers.
We delight in helping our customers execute their digital vision. Big projects or
small, Halo Group knows that by combining the highest quality talent with our
unwavering support, we will become an invaluable extension of the team. Halo
Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all
areas of product/project governance, UX/UI, multi-platform applications, quality
assurance/testing, cloud computing, and data analytics.
Since its inception, Halo Group has been recognized for numerous awards, including: 
- INC 5000
- Future 50
- 101 Best and Brightest
- Michigan 50 Companies to Watch
- Goldline Research - “Most Dependable Companies”
- Ernst & Young - “Entrepreneur of the Year” Finalist

Job Description

• Minimum 8 Years of Experience with Relational Databases such as SQL Server, Oracle, DB2, HANA and good knowledge on in-memory functions
• 1 Year of experience with doing data modeling using MemSQL both Row Store and Column Store
• Responsible for performance tuning of database functions, SQL queries, and stored procedures to ensure scalability demands are satisfied.
• Excellent Data Modeling Skills with SQL database including good skills in designing complex queries, stored procedures, use of columnar tables
• Ability to perform debugging of performance issues with MemSQL and recommend optimizations in data loads in columnar tables
• Experience in developing solutions patterns, data flow diagrams, data models and architectural specifications
• Integration experience with ETL
• Any experience with Pentaho is a plus
• Client-centric mentality: reliable, professional, exceeds expectations
• Able to handle projects independently and manage client expectations and deliverables in a timely manner
• Demonstrated skill at presenting complex development topics to technical and business users

Qualifications

• Bachelor’s degree or foreign equivalent required. Will also consider three years of relevant work experience in lieu of every year of education.”

• At least 4 years of experience with Information Technology

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

  • Minimum 8 years of experience with relational databases (SQL Server, Oracle, DB2, HANA) and in-memory functions
  • At least 1 year of data modeling experience using MemSQL (Row Store and Column Store)
  • Experience with performance tuning of database functions, SQL queries, and stored procedures
  • Excellent SQL data modeling skills, designing complex queries and use of columnar tables
  • Ability to debug MemSQL performance issues and recommend optimizations for columnar data loads
  • Experience developing solution patterns, data flow diagrams, data models, and architectural specifications
  • Integration experience with ETL tools
  • Experience with Pentaho
  • Bachelor's degree or foreign equivalent (or relevant work experience substitution)
  • At least 4 years of experience in Information Technology
  • Strong client-facing skills; able to manage projects and present to technical and business users
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
80 Employees
Year Founded: 2011

What We Do

Sonoma Consulting Inc. is a national IT consulting and executive search firm founded in 2011 by Mark McGee. The company operates through two business divisions—IT Consulting Services and Executive Search—serving approximately 150 national clients that range from entrepreneurial start-ups to Global Fortune 500 companies. It specializes in harmonizing systems and application or infrastructure development projects.

Similar Jobs

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
8 Locations
40000 Employees
45K-85K Annually

Micron Technology Logo Micron Technology

Principal Engineer

Artificial Intelligence • Hardware • Information Technology • Machine Learning
In-Office
Richardson, TX, USA
45000 Employees

Micron Technology Logo Micron Technology

Design Engineer

Artificial Intelligence • Hardware • Information Technology • Machine Learning
In-Office
2 Locations
45000 Employees
177K-334K Annually

Micron Technology Logo Micron Technology

Design Engineer

Artificial Intelligence • Hardware • Information Technology • Machine Learning
In-Office
Richardson, TX, USA
45000 Employees

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account