**Responsibilities:** **_Advanced SQL Server Administration:_** * Manage complex SQL Server environments (2014, 2016, 2017, 2019, and 2022) * Implement and maintain high availability and disaster recovery solutions (e.g., Always On availability groups, log shipping) * Patching and updating SQL Server instances * Performance tuning and optimization (e.g., query optimization, index tuning) **_Database Design:_** * Design and implement normalized and denormalized database structures * Create and optimize stored procedures, functions, and triggers **_Troubleshooting:_** * Diagnose and resolve complex SQL Server performance and availability issues * Use performance monitoring tools (e.g., SQL Server Profiler, DMVs) **_Automation:_** * Automate routine SQL Server tasks using scripting (e.g., PowerShell, T-SQL) **_Required Skills and Experience:_** * In-depth knowledge of SQL Server architecture and internals * Strong T-SQL programming skills * Experience with high availability and disaster recovery solutions * Proven ability to troubleshoot complex SQL Server issues * Familiarity with scripting languages (e.g., PowerShell, T-SQL) * Experience with performance tuning tools and techniques **_Additional Considerations:_** * Security: Understanding of SQL Server security best practices, including data encryption, access control, and vulnerability management. * Inventory Management: Ability to track and manage SQL Server instances, databases, and other assets. * Patching: Knowledge of SQL Server patching procedures and best practices. * Cloud Migration: Familiarity with migrating SQL Server workloads to cloud platforms (e.g., Azure, AWS).