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