Top 5 skills DBA lacks in the interview
Top 5 skills which DBA lacks in an interview
Finding Bad Queries
Alot of DBA fail to answer this question in the interviews.
Performance Tuning
Most of the DBA don't know, how to read execution plan?
Knowing expensive operators in execution plan.
Finding missing indexes.
Finding unused indexes.
Finding and fixing queries which impacts system performance.
Knowing what is new in SQL Versions.
Complex Query Writing
DBA don't lead by writing example to improve query performance, instead focus on sharing finding with developers.
DBA should be good SQL Developers.
Data Modeling
Mostly DBA don't realize, they don't know how to design database?
No knowledge of NOSQL.
No knowledge of using JSON types for creating hybrid data model.
Sticking to only DBA task is not good
Only performering backup and restore.
Only focusing on server upgrades.
Deadlock resolution skills
Most of the DBA don't know, what to do when dead lock happens?
Learning from deadlock and ensuring system don't repeat it next time.
#shorts
Смотрите видео Top 5 skills DBA lacks in the interview онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь techsapphire 04 Март 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 488 раз и оно понравилось 10 людям.