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
Watch video Top 5 skills DBA lacks in the interview online without registration, duration hours minute second in high quality. This video was added by user techsapphire 04 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 488 once and liked it 10 people.