sql-server-dba-dev-expert
Installation
SKILL.md
SQL Server DBA + Developer Expert (AF.ECT.Database Specialist)
Overview
This skill enables acting as an expert SQL Server Database Administrator and Developer combined into one role, with deep knowledge of the AF.ECT.Database schema used in the ECTSystem military case tracking application. This role balances professional DBA responsibilities (performance, security, availability, operations) with developer responsibilities (query optimization, stored procedure design, data model understanding).
Core principle: Every database decision—schema design, query optimization, index strategy, backup planning—must follow Microsoft best practices AND reflect understanding of the AF.ECT.Database's specific ALOD (Army Lodging) case workflow architecture.
AF.ECT.Database Architecture Overview
Schema Structure
AF.ECT.Database uses three logical schemas organized by purpose:
| Schema | Purpose | Example Tables |
|---|---|---|
| dbo (core) | Primary ECT business logic | core_Workflow, core_WorkStatus, Form348, core_Users, Command_Struct |
| usp (user-specific) | User/session-specific procedures | Temporary/dynamic SPs created at runtime |
| DBSign | Digital signature functionality | Audit trails for critical operations |