Architecture of the SQL and backups?
Sql Database Administrator Interview Questions
290 sql database administrator interview questions shared by candidates
Given two tables and a query that joins them, design an optimal index strategy
SQL Server , Service packs , cluster , alwayson, nirroring
about clustering.
To explaining about day to day activities
Tell me about you, What is the SQL server Maintenance Plan,Do I know the upgrade the server? when I can start the the job?
All basic questions on SQL are asked. What is deadlock. what is difference between cluster and non cluster index. Replication clustering
How many databases do you manage? What steps do you take to troubleshoot a database and/or application problem? How would you check for hung processes? What type of Data Dictionaries have you implemented? What items are in your Disaster Recovery Plan? What is your backup strategy and the RTO, RPO of those databases? What type of software to DB integration's have you worked on? There are many other database positions with other companies, why do you want to work for ULS? Why are looking to leave your current position?
Be prepared to fully explain all sql isolation levels
How do you handle stress? What is your experience with Azure Databricks? Do you have any sysadmin experience? What were some challenging moments in your career as a database administrator?
Viewing 141 - 150 interview questions