MemSQL Data Modeling Expert at Sonoma Consulting in Dallas, TX

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.