Skill UI

This skill provides expert guidance for modern, multi-cloud database administration. It covers comprehensive knowledge across AWS, Azure, and GCP platforms, spanning relational, NoSQL, and graph databases. Key areas include Infrastructure as Code (Terraform, Flyway), achieving high availability, disaster recovery, advanced performance optimization, and ensuring strict regulatory compliance (HIPAA, GDPR). It is essential for managing complex, highly reliable cloud data architectures.

This skill covers expert-level database administration for modern cloud environments. It includes managing AWS, Azure, and Google Cloud databases, implementing Infrastructure as Code, ensuring high availability and disaster recovery, optimizing performance, and securing data. Suitable for automating maintenance, handling migrations, and managing containerized databases.

Implement comprehensive automated database backup strategies for PostgreSQL, MySQL, and MongoDB. Configure retention policies, schedule backups using cron or systemd, and upload to S3-compatible storage. Includes scripts for logical and physical backups, point-in-time recovery, and disaster recovery testing. Essential for DevOps and database administration roles to ensure data safety and business continuity.

Administer, optimize, and secure MongoDB NoSQL databases in development and production. Covers installation, user setup, CRUD operations, indexing, aggregation pipelines, replica sets, and backup/restore.

Administer and optimize MySQL/MariaDB databases in production environments. Covers installation, configuration tuning, security hardening, backup strategies using mysqldump or XtraBackup, and source-replica replication setup. Essential for managing relational database deployments and ensuring high availability.

Administer, optimize, and secure PostgreSQL databases in development and production environments. Covers installation, configuration tuning, backups, streaming replication, and security best practices.