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

      MetLife

      Engaged employer

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: MetLife reviews | MetLife jobs | MetLife salaries | MetLife benefits | MetLife conversations
      MetLife interviewsMetLife SQL Server Database Administrator interviewsMetLife 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.

      SQL Server Database Administrator Interview

      20 Apr 2016
      Anonymous interview candidate
      Cary, NC
      No offer
      Positive experience
      Difficult interview

      Application

      I applied online. The process took 4 weeks. I interviewed at MetLife (Cary, NC) in Apr 2016

      Interview

      Several interviews, the process takes several weeks (possibly months). First you'll meet with a talent recruitment specialist for a cursory chat they will feel you out a bit, next you talk to talent recruitment coordinator who will also interview you and feel you out a bit, they'll be your guide and aid throughout the entire process, after them is technical screening and after that you'll interview with members of your team (perhaps multiple times). All of the interviews can be phone or skype, if you are out of the area which is nice. The technical questions are very difficult and performance specific. I suggest reading up and studying hard on dynamic management views, troubleshooting long running queries and etc. The guy running the screening has a loose grip on the English language at best and is often hard to understand. He also has some strange prejudice against Oracle DBAs and databases so if you have experience with that just be sure to pronounce loud and early how you hate Oracle and love SQL-Server. The rest of the interviews are personality fit and personality type questions and everyone besides the technical ballbuster Indian guy is pretty friendly. Below are technical questions, the personality ones are the same generic ones everyone uses and are not MetLife specific (you can google those). Overall it's a good process and if you are just starting to look for a switch beyond your agency to giant enterprise like MetLife these types of interviews will harden you and make you better, study harder, etc. for the future.

      Interview questions [1]

      Question 1

      How would you identify a long running query? How would would find out the execution plan of that query? If you have a SPID how could you see what query that spid was executing? Name the types of waits in SQL-Server? What do they mean? Is there another way besides SQL Server Profiler, Extended Events and Performance Monitor to see waits, I/O, etc? What is the difference between an Implicit and Explicit query in SQL? With a large database using Blobs what sort of configuration changes do you have to make? How do you setup indexing specifically? What steps do you take to tune SQL queries? How would you go about rewriting a poorly performing query? How could you tell where indexes were missing? Why would you choose SQL-Server over Oracle?
      1 Answer
      3

      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.