Job Description
Strong knowledge of MS SQL Server 200020052008201220142016 and 2019 environments database administration in Windows and virtual environments
Azure PaaS and IaaS Sybase
Experienced in implementation of HA options like Log Shipping Mirroring and Replication and Clustering options for SQL Server
Experience in writing TSQL including stored procedures functions views and triggers
Experience with High Availability HA and Disaster Recovery DR options for SQL Server
Experience in Performance Tuning and Query Optimization for MSSQL
Having Experience in SQL AlwaysON
Having Experience in SQL server service pack and security patches installation
Good Experience in scheduling SQL Server Agent Jobs s and automating scripts
Strong knowledge of backups restores recovery models database shrink operations DBCC commands Database mirroring Replication
Having knowledge of Profiler DTS SSIS packages
Ability to detect and troubleshoot SQL Server related CPU memory IO disk space and other resource contention
Proficient with automation technologies such as MicroSoft DMA