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).