Passa al contenutoPassa al piè di pagina
  • Lavori
  • Aziende
  • Stipendi
  • Per le aziende

      Migliora la tua carriera

      Scopri le tue potenzialità di guadagno, trova lavori da sogno e condividi approfondimenti su lavoro e vita privata in forma anonima.

      employer cover photo
      employer logo
      employer logo

      MetLife

      Azienda coinvolta

      Circa
      Recensioni
      Stipendi e benefit
      Lavori
      Colloqui
      Colloqui
      Ricerche correlate: Recensioni su MetLife | Offerte di lavoro di MetLife | Stipendi di MetLife | Benefit di MetLife
      Colloqui di MetLifeColloqui per SQL Server Database Administrator presso MetLifeColloquio di MetLife


      Glassdoor

      • Chi siamo
      • Contattaci

      Aziende

      • Account Business gratuito
      • Spazio per le aziende
      • Blog per le aziende

      Informazioni

      • Aiuto
      • Linee guida
      • Condizioni d'uso
      • Privacy e scelte pubblicitarie
      • Non vendere né condividere le mie informazioni
      • Strumento per l'accettazione dei cookie

      Lavora con noi

      • Inserzionisti
      • Carriere
      Scarica l'app

      • Cerca:
      • Aziende
      • Lavori
      • Località

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" e il relativo logo sono marchi registrati di Glassdoor LLC.

      Aziende seguite

      Non lasciarti sfuggire opportunità e informazioni privilegiate seguendo le aziende dove vorresti lavorare.

      Ricerche di lavoro

      Ricevi suggerimenti e aggiornamenti personalizzati avviando le tue ricerche.

      Colloquio per SQL Server Database Administrator

      20 apr 2016
      Candidato anonimo a colloquio
      Cary, NC
      Nessuna offerta
      Esperienza positiva
      Colloquio difficile

      Candidatura

      Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso MetLife (Cary, NC) nel mese di apr 2016

      Colloquio

      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.

      Domande di colloquio [1]

      Domanda 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 risposta
      3