Optimizations at database administration level, focused on enhancing performance through indexing, partitioning, and maintaining efficient database structures. At the DB query level, optimizations included refining query logic, utilizing execution plans, and ensuring efficient data retrieval techniques.