Senior MS SQL DBA Freelancer 1 week duration

About the job

• Review of the SQL Server architecture and hardware configuration.

• Analysis of the SQL Server instance configuration and security settings.

• Assessment of the SQL Server backup and recovery strategy and procedures.

• Evaluation of the SQL Server monitoring and alerting systems.

• Review of the SQL Server performance metrics and tuning recommendations.

• Analysis of the SQL Server replication, clustering, and availability options.

• Recommendations for improving the SQL Server environment's performance, security, and reliability.

• Review of the Always On-Availability Group (AG) architecture, including the number of nodes and replicas and their configuration.

• Analysis of the AG configuration and security settings, including authentication and authorization, endpoint configuration, and encryption.

• Review of the AG replication, clustering, and availability options, including failover strategies and disaster recovery options.

• Recommendations for improving the AG environment's performance, security, and reliability.

• Conduct a post-incident review as part of the Audit. The post-incident review should aim to identify the root cause of the incident, assess the impact on the environment, and make recommendations to prevent similar incidents from occurring in the future.