Database Design & Recommendations: Review database schema and query design, and propose recommendations to improve indexing, query efficiency, and overall database performance.
Upgrades & Migrations: Plan and execute database version upgrades, patching, and migrations (including cross-engine or cross-environment migrations) with minimal downtime and clear rollback plans.
Backup & Restoration: Own backup strategy, retention, and restoration testing across managed database services, ensuring recovery objectives (RPO/RTO) are consistently met.
...
Configure and manage MariaDB high-availability topologies including Galera Cluster or primary-replica replication, ensuring RPO and RTO targets are met
Configure and manage ClickHouse replication, sharding, and data distribution for the analytical layer
Implement and manage database backup and recovery procedures, conducting regular recovery drills to validate backup integrity and RTO compliance
...
Strong familiarity and experience with solution design and delivery using cloud platforms like AWS, Azure.
Experience to handle scalable projects with complex integration requirements, with the ability to architect or explain complex systems interactions including data flows, common interfaces, APis and other methods.
Ability to work independently as well as part of a team, with strong communication and collaboration skills.
...
Ensure the security and integrity of data through managing database users and access control procedures. Assist in maintaining an accurate asset inventory.
Optimise database performance through monitoring, identification, analysis and resolution of performance bottlenecks.
Manage storage and capacity planning to account for the requirements of data growth and data archiving.
...