SQL Database Administrator
Core
Administer, maintain, optimize, and support enterprise Microsoft SQL Server database environments to ensure system reliability, performance, availability, and security.
Role type
Senior IC SQL Database Administrator
Builds
Enterprise Microsoft SQL Server database environments
Domain
Enterprise IT / Database Administration
Required skills
Microsoft SQL Server administration, database performance tuning, backup and recovery procedures, query optimization, index management, database security controls, high-availability and disaster recovery solutions, database maintenance and patching, capacity management, technical documentation
Preferred skills
Microsoft SQL Server certifications, SQL Server Always On Availability Groups and failover clustering, database migration and modernization, PowerShell scripting, SQL Server Integration Services (SSIS) and Reporting Services (SSRS), enterprise application integration, database monitoring and auditing tools, federal government or large enterprise IT experience
Technologies
Microsoft SQL Server, PowerShell, SSIS, SSRS
Responsibilities
Install, configure, administer, maintain, and support Microsoft SQL Server databases in enterprise production environments; Monitor database performance, availability, capacity, and operational health; Perform advanced SQL Server performance tuning, including query optimization, indexing strategies, and database configuration improvements; Develop, implement, and maintain database backup, restoration, and recovery procedures; Diagnose and resolve complex database performance issues, connectivity problems, system errors, and production incidents; Implement and maintain database security controls, including user access management, permissions, authentication, and auditing; Perform database maintenance activities, including integrity checks, index maintenance, statistics updates, and capacity management; Support database upgrades, patches, migrations, and configuration changes; Configure, monitor, and troubleshoot SQL Server high-availability and disaster recovery solutions; Collaborate with application developers, system administrators, and technical teams to define and implement database requirements; Review and optimize SQL queries, stored procedures, and database objects to improve application performance and operational efficiency; Support database deployments, application releases, and system integration activities; Monitor database storage utilization and recommend improvements to capacity, performance, and resource allocation; Implement database administration best practices to improve reliability, security, maintainability, and operational efficiency; Develop and maintain technical documentation, including database configurations, backup and recovery procedures, maintenance schedules, and standard operating procedures (SOPs); Participate in technical planning, troubleshooting discussions, and project execution activities; Evaluate existing database environments and recommend improvements to performance, scalability, security, and availability
Seniority
Senior, hands-on IC