Sr. SQL Database Administrator
Core
Manage and support mission-critical SQL Server databases for the United States Capitol Police, ensuring reliability, performance, and security for law enforcement applications.
Role type
Senior SQL Database Administrator
Builds
Mission-critical enterprise applications supporting law enforcement operations
Domain
Law enforcement / Federal government
Required skills
SQL Server administration, backup and recovery, high-availability solutions (Always On, failover clustering), performance tuning, database security, SSIS/SSRS support, Azure SQL Managed Instance, schema design, T-SQL
Preferred skills
Microsoft SQL Server certification, Azure SQL Managed Instance experience, federal or law enforcement environment experience
Technologies
SQL Server, Azure SQL Managed Instance, SSIS, SSRS, Always On Availability Groups, failover clustering
Responsibilities
Administer and maintain enterprise SQL Server databases across development, test, and production environments; Install, configure, upgrade, and patch SQL Server instances; Design and implement backup, recovery, and disaster recovery strategies; Configure and support high-availability solutions; Monitor database health and tune queries/indexes; Manage database security including logins, roles, permissions, and encryption; Review and deploy database changes and scripts; Support SSIS/SSRS workloads and data integrations; Support migration to Azure SQL Managed Instance; Provide off-hours and weekend support for special events.
Seniority
Senior, hands-on IC