Open Skills Logo
Open Skills

database-admin

Expert database administrator specializing in modern cloud databases, automation, and reliability engineering. Masters AWS/Azure/GCP database services, Infrastructure as Code, high availability, disaster recovery, performance optimization, and compliance. Handles multi-cloud strategies, container databases, and cost optimization. Use PROACTIVELY for database architecture, operations, or reliability engineering.

Author

@sickn33

Category

Other Tools

Install

Hot:6

Download and extract to your skills directory

Copy command and send to OpenClaw for auto-install:

Download and install this skill https://openskills.cc/api/download?slug=sickn33-skills-database-admin&locale=en&source=copy

Database Admin - Cloud Database Automation and Operations Expert

Skills Overview


Database Admin is an expert in cloud-native databases, automation of operations, and reliability engineering, covering AWS, Azure, and GCP multi-cloud database platforms. Provides high-availability architectures, performance tuning, disaster recovery strategies, and security and compliance guidance.

Applicable Scenarios


  • Cloud Database Architecture Design - Design cross-region high-availability database architectures, configure read-write separation and automatic failover, and achieve RPO/RTO objectives.

  • Database Operations Automation - Implement IaC database deployments using Terraform/CloudFormation, and configure automated backups, monitoring alerts, and routine maintenance tasks.

  • Database Performance Optimization - Analyze slow queries, optimize execution plans, configure connection pooling, and implement resource monitoring and cost optimization.

    • Core Features


  • Multi-Cloud Database Management - Supports managed database services such as AWS RDS/Aurora, Azure SQL Database, and GCP Cloud SQL, and provides migration, replication, and cross-cloud deployment strategies.

  • High Availability and Disaster Recovery - Configure primary/replica replication, multi-region deployments, and automated failover, and implement comprehensive backup strategies and regular recovery drills.

  • Security and Compliance - Implement RBAC access control, at-rest and in-transit encryption, and audit logging to meet compliance requirements such as HIPAA, PCI-DSS, and GDPR.

    • Common Questions

    How do you design a cross-region database disaster recovery plan?


    Database Admin can help design multi-region disaster recovery architectures, including primary/replica replication configuration, automated failover, backup strategies, and recovery procedures. RPO and RTO objectives will be defined based on business requirements, and a disaster recovery exercise plan will be provided.

    What is the difference between cloud databases and self-managed databases?


    Cloud databases offer advantages such as automated operations, built-in high availability, and on-demand scaling, which reduce management overhead; self-managed databases provide more control but require managing the infrastructure yourself. Database Admin can evaluate and recommend the appropriate solution based on specific needs.

    What are common methods for database performance optimization?


    Methods include query optimization (analyzing slow query logs and optimizing execution plans), connection pool configuration, index optimization, resource monitoring (CPU, memory, I/O), read-write separation, and caching strategies. Database Admin can provide specific performance diagnostics and optimization plans.

    Limitations


    This skill focuses on database architecture and operations guidance and does not perform direct database writes or data operations. For changes affecting production environments, it is recommended to validate them first in a test environment.