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: * 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: * SecurityUnderstanding of SQL Server security best practices, including data encryption, access control, and vulnerability management. * Inventory ManagementAbility to track and manage SQL Server instances, databases, and other assets. * PatchingKnowledge of SQL Server patching procedures and best practices. * Cloud MigrationFamiliarity with migrating SQL Server workloads to cloud platforms (e.g., Azure, AWS). Job Segment Database, Cisco, System Administrator, SQL, Administrative Assistant, Technology, Administrative