Senior developers don’t have to be database experts, but they usually understand ACID, Normalization and Denormalization Concepts, Transaction Isolation Levels, Optimistic and Pessimistic Concurrency Models, Deadlocks problem, Indexing best practices and can analyze SQL query execution plan .