Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      Morningstar

      Engaged employer

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Morningstar reviews | Morningstar jobs | Morningstar salaries | Morningstar benefits | Morningstar conversations
      Morningstar interviewsMorningstar SQL Database Administrator/Senior Developer interviewsMorningstar interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Glassdoor LLC.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Top companies for "Compensation and Benefits" near you

      avatar
      S&P Global
      3.8★Compensation and benefits
      avatar
      Canadian Nuclear Laboratories
      3.8★Compensation and benefits
      avatar
      Kinectrics
      3.9★Compensation and benefits
      avatar
      Morningstar DBRS
      3.7★Compensation and benefits

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      SQL Database Administrator/Senior Developer Interview

      Apr 4, 2011
      Anonymous employee
      Chicago, IL
      Accepted offer
      Positive experience
      Difficult interview

      Application

      The process took 2 days. I interviewed at Morningstar (Chicago, IL) in Apr 2011

      Interview

      I was flown in for this interview that consisted of sitting down and talking with 10 different people that consisted of the HR manager all the the way to the CEO himself! The first couple of interviews consisted of me just telling them about myself and some of my background. As the day moved on, the deep SQL technical questions started. They never asked anything to caught me off guard, but the questions where in depth and you have to know what you are talking about as these are some smart people. I would highly recommend anyone walking in to this interview know, query optimizing, and SQL administration at a professional level. They took me to lunch and showed me around the office (very very nice building/office space) and even went as far as introducing me to some of the people around the place. Overall it was a very long day (I flew in that morning and left the same night), but overall the interview process was very professional and straight forward.

      Interview questions [1]

      Question 1

      We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
      1 Answer