Dba Skills

Audits and hardens PostgreSQL security including role management, pg_hba.conf authentication, SSL/TLS configuration, row-level security policies, and audit logging. Use when performing security reviews, setting up new instances, responding to security incidents, or preparing for compliance audits.

Diagnoses SQL Server instance health by analyzing DMVs, wait statistics, blocking chains, memory pressure, CPU usage, I/O stalls, and database integrity. Use when SQL Server is slow, unresponsive, experiencing errors, or when performing routine health audits.

Diagnoses PostgreSQL instance health by analyzing connections, wait events, lock contention, table and index bloat, autovacuum status, replication lag, and transaction ID wraparound risk. Use when PostgreSQL is slow, connections are being refused, tables are bloated, autovacuum is not keeping up, or during routine health audits.

Designs SQL Server backup strategies and guides restore operations including full, differential, and log backups, point-in-time recovery, and backup verification. Use when designing backup strategies, performing restores, troubleshooting backup failures, or verifying backup integrity.

Manages PostgreSQL backup and recovery using pg_dump, pg_basebackup, WAL archiving, and point-in-time recovery (PITR). Use when designing backup strategies, performing logical or physical backups, recovering from data loss, or setting up continuous WAL archiving for PITR capability.

Manages SQL Server indexes including fragmentation analysis, missing index evaluation, unused index detection, and maintenance strategy design. Use when diagnosing slow queries due to missing indexes, planning index maintenance windows, auditing index effectiveness, or designing indexes for new tables.

Configures and monitors SQL Server high availability using Always On Availability Groups, Failover Cluster Instances, and log shipping. Use when setting up HA/DR solutions, monitoring replication health, performing planned failovers, or troubleshooting synchronization lag.

Analyzes and optimizes slow SQL Server queries by reading execution plans, finding missing indexes, resolving parameter sniffing, and detecting implicit conversions. Use when queries are slow, consuming excessive CPU or I/O, after performance regressions, or when execution plans show warnings.

Analyzes and optimizes slow PostgreSQL queries using EXPLAIN ANALYZE, pg_stat_statements, index recommendations, and planner configuration. Use when queries are slow, pg_stat_statements shows expensive queries, sequential scans occur on large tables, or after schema changes cause plan regressions.