Job Description

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: