Cloud Database Administrator

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