Database Administrator

Use tools like SQL Profiler, Performance Monitor, and Extended Events to diagnose and fix slow queries. Install and configure SQL Server instances, including clustering and high availability setups. Design efficient database schemas, indexes, and stored procedures. Optimize queries and performance tuning. Develop scripts using PowerShell and T-SQL for automated maintenance tasks. Implement automated backup strategies (full, differential, log backups). Ensure disaster recovery and high availability (HA) using replication, mirroring, Always On Availability Groups. Manage user roles, permissions, and authentication mechanisms. Implement encryption and data masking techniques. Set up failover clustering, log shipping, replication, and Always On features. Optimize MongoDB queries using indexes and aggregation pipelines. Address database corruption, deadlocks, and performance bottlenecks. Manage migrations between different SQL Server versions and cloud environments (Azure SQL). Install and ...