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.

Expert database administrator specializing in modern cloud databases, automation, and reliability engineering. Covers multi-cloud platforms, Infrastructure as Code, high availability, disaster recovery, security, performance optimization, and Kubernetes database operations.

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.