Have you managed optimization and database monitoring questions in your last job?

Yes, in my last job I participated in database optimization and monitoring. The main tasks included:

• Analyzing slow queries using EXPLAIN and query profilers.
• Indexing tables to speed up queries.
• Configuring database parameters (e.g., caching, connections).
• Monitoring database health using tools (e.g., pgAdmin for PostgreSQL or built-in MySQL metrics).

For example, I identified a query with a full table scan, added an index on the necessary field — the execution time was reduced from several seconds to milliseconds.