*Security Compliance:
- Perform extensive security and compliance audit in order to identify areas for remediation and improvement.
- Advise on the development and implementation of processes, policies and procedures in order to ensure the integrity and security of the databases.
- Perform review of User / Group / Role management for each database instance.
*Resilience:
- Advise on how best to monitor the system's health and performance thru periodic reports and real-time “health checks” as well as raising alerts for high priority abnormalities.
- Advise on how to implement procedures to ensure high levels of performance, availability, sustainability and security.
*Disaster Recovery:
- Review current backup & recovery procedures.
- Review current high availability & disaster recovery solutions and advise on best strategies (including region locations).
*Fine Tuning, Troubleshooting & Performance Optimization.
- Advice on best practices for database performance troubleshooting, optimization, and tuning on Server/database/query levels.
- Advice on best practices to proactively identify and handle locking, blocking, and deadlock situations.
- Advice on Index tuning, rebuild, and reorg strategies.
- Advise on designing, configuring, deploying, and supporting caching solutions such as Redis
*Database Design and Modeling – Diagrams.
- Provide general advice on database design (logical and physical) regarding best practices, procedures, and tools.
*Data Dictionary.
- Provide advice on how to build an extensive data dictionary based on the existing applications (internal and external platforms), data governance, and taxonomy.
*Database Source Control.
- Provide advice on how effectively implement source control for database objects.
*Database DevOps Implementation.
- Provide advice and guidance regarding Database DevOps implementation (aligned with the overall department DevOps effort).