Use SQL Server tools such as SSMS, Extended Events, Query Store, DMVs, and PerfMon, as well as PostgreSQL tools such as EXPLAIN ANALYZE, pg_stat_statements, system catalogs, and VACUUM/autovacuum tuning to diagnose and resolve issues. Database Development & Design Design, write, and optimize database code across Microsoft SQL Server and PostgreSQL, including stored procedures, functions, views, triggers, tables, indexes, partitions, and constraints.