Role: Cloud DBA
High level Role Deliverables: Cloud DBA work under the guidelines of DBA Manager, collaborating with Cloud engineering, Digital Development, DevOps, Security and analytics team. Cloud DBA deliverables for cloud native databases
include:
- Backup Process Implementation: Set up and automate database backups, and provide regular reports that backups are running and can be restored successfully.
- Disaster Recovery (DR) Plan: Create, document, and test a disaster recovery plan with clear recovery objectives and failover strategies. Share test results and update the plan as needed.
- Monitoring & Alerts Setup: Implement monitoring dashboards and alerting systems for
- database health, usage, and errors. Ensure alerts are actionable and regularly review them with stakeholders.
- Health Check Reports: Perform regular database health checks (e.g., performance, storage, backups, security) and deliver summarized health reports with recommendations.
- Code & Query Performance Optimization: Analyse and tune slow-running queries or code and provide before-and-after performance reports and suggestions to development teams.
- Security & Compliance Review: Audit database access, encryption, and compliance status. Deliver a security checklist and implement required changes.
- Provisioning and Scaling: Set up and adjust database resources as needed. Provide
- documentation of resource changes and recommendations for scaling.
- Support for DevOps & CI/CD: Enable automated database deployment and schema updates within CI/CD pipelines. Deliver tested migration scripts and rollback plans.
- Documentation & Knowledge Transfer: Maintain up-to-date documentation of processes and provide training or handover sessions for internal teams.
- Continuous Improvement Suggestions: Regularly review and propose improvements in process, technology, or cost savings
Expected technical knowledge
- Proven experience as a Database Administrator (DBA) or Database developer in Azure
- cloud environment.
- Proficiency in SQL and experience with Azure SQL database management systems or
- similar such as like MySQL, PostgreSQL, Cosmos DB or NoSQL
- Hands on Experience with cloud-native database services (e.g., Azure SQL Database).
- Hands-on experience with SQL Code optimisations
- Strong experience with Azure Cloud Infrastructure and services
- Familiarity with infrastructure as code (IaC) tools like Terraform
- Knowledge of Agile, DevOps and CI/CD pipelines (Azure DevOps/Jira, GitHub Actions, etc.).
- Strong problem-solving skills and attention to detail.
- Excellent communication and teamwork skills.
- Knowledge of monitoring and observability tools.
- Knowledge of security best practices
