Position: Service /System administrator
Category: SQL
English level: fluent
Years of experience: 3


Installing SQL Server from SQL Server 2016 to SQL Server 2022.
•
Installed all Microsoft Patches that are Cumulative updates as well as Microsoft hotfixes.
•
Migrated database using backup and restore, detach and attach.
•
Power Shell scripting for the automation of tasks, and SQL Partitioning of tables, and indexes.
•
Managed indexes to improve performance, alongside database security and Identity.
•
Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Always On, Clustering, and Replication), TDE (Transparent Data Encryption)AE, and DDM.
•
Skills in Monitoring Tools like; Query Store, Import/Export Wizard, SSMS, SQL Server Profiler, Extended Events, and Tuning Advisor.
•
Experience with partitioned schemas and tables, creating File groups using SQL Server.
•
Experience in Administering SQL Server security(SID) by Creating User Logins with appropriate roles, and monitoring user accounts.
•
Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity, and Database Consistency Checks Using DBCC.
•
Backup and Recovery strategies and Capacity planning following the company’s Recovery Point Objective (RPO) Recovery Time objective (RTO) and Retention Policy.
•
Monitor key performance indicators (KPI) to enhance SQL server performance and Query Optimization techniques
•
ReviewT-SQ and Documentation.