Database Admin Senior Specialist

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

Job Type: Permanent