How do database administrators (DBAs) utilize performance monitoring and tuning techniques, such as query profiling, index optimization, and database partitioning, to optimize the performance and resource utilization of database systems in production environments?