*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).