Aller au contenuAller au pied de page
  • Emplois
  • Entreprises
  • Salaires
  • Pour les employeurs

      Boostez votre carrière

      Découvrez votre salaire potentiel, décrochez des emplois de rêve et partagez vos témoignages de manière anonyme.

      employer cover photo
      employer logo
      employer logo

      MetLife

      Employeur impliqué

      À propos
      Avis
      Salaires et avantages
      Emplois
      Entretiens
      Entretiens
      Recherches associées: Avis sur MetLife | Offres d’emploi chez MetLife | Salaires chez MetLife | Avantages sociaux chez MetLife
      Entretiens chez MetLifeEntretiens d’embauche pour SQL Server Database Administrator chez MetLifeEntretien chez MetLife


      Glassdoor

      • À propos
      • Récompenses
      • Blog
      • Nous contacter
      • Guides

      Employeurs

      • Compte employeur gratuit
      • Centre employeur
      • Blog pour les employeurs

      Informations

      • Aide
      • Règles de la communauté
      • Conditions d'utilisation
      • Confidentialité et choix publicitaires
      • Ne pas vendre ni partager mes informations
      • Outil de consentement aux cookies

      Travailler avec nous

      • Annonceurs
      • Carrières
      Télécharger l'application

      • Parcourir par :
      • Entreprises
      • Emplois
      • Lieux

      Copyright © 2008-2026. Glassdoor LLC. « Glassdoor », son logo, « Worklife Pro » et « Bowls » sont des marques déposées de Glassdoor LLC.

      Entreprises suivies

      Tenez-vous au courant des dernières opportunités et profitez de conseils d’initiés en suivant les entreprises de vos rêves.

      Recherche d’emplois

      Obtenez des recommandations et des mises à jour personnalisées en démarrant vos recherches.

      Entretien pour SQL Server Database Administrator

      20 avr. 2016
      Candidat à l'entretien anonyme
      Cary, NC
      Aucune offre
      Expérience positive
      Entretien difficile

      Candidature

      J'ai postulé en ligne. Le processus a pris 4 semaines. J'ai passé un entretien chez MetLife (Cary, NC) en avr. 2016

      Entretien

      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.

      Questions d'entretien [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 réponse
      3