Database Management

Proactive alerts were configured to monitor for long running queries, high connection, continuous blocking, job failed, DB replica latency and high CPU usage. The alerts will trigger call to the DBA on duty to keep the issue checked before it impacts  your business.    

Proper DB Backup maintenance will be in place to ensure your backup chain is maintained. So that, point in time recovery restoration can be arranged during disaster Recovery. 

Replica DB will be setup in different geolocation to help your business withstand a disaster happen on your primary data center.

We offer query tuning services on your query that capture in our query timeout / slowness report and gather the requirement from your application team to simplify and rewrite the query to speed up the performance.

Azure DevOps with branching strategy to automate the build and release management for your DB deployment. The DB script only release to production after it passed the review from DBA and Development Team Lead .

All the pull request DB script in source control will be reviewed by DBA according to the best practices.