Database Administrator

Jetzt loslegen. Gratis!
oder registrieren mit Ihrer E-Mail-Adresse
Database Administrator von Mind Map: Database Administrator

1. Project

1.1. MS SQL Consolidation

1.2. MySQL Modernization

1.3. PostgreSQL Modernization

1.4. Migration

1.5. ExaCC non-Prod/Prod Modernization

2. Operation

2.1. Audit and Security

2.1.1. Encryption at Rest and in Transit

2.1.2. Audit Logging and Monitoring

2.1.3. Data Masking and Anonymization

2.2. Performance and Tuning

2.2.1. Regular Application Performance (ex: Java, dynatrace)

2.2.2. Database Performance

2.3. CRQ

2.4. O&M

2.4.1. MySQL OEM

2.4.2. PEM

2.4.2.1. Diagnostic

2.4.2.2. SQL Profiler Plugin

2.4.3. Idera

2.5. Troubleshooting dan incident handling

2.6. Patch and Upgrades

2.7. Documentation and SOP

2.8. Regular Review

2.8.1. Operational

2.8.2. Configuration

2.8.3. Performance

3. Budget

3.1. Licenses/Assets

3.1.1. Opensource

3.1.2. Proprietary

3.2. Tender

3.2.1. Oracle

3.2.1.1. MySQL

3.2.1.2. Oracle

3.2.2. Non-Oracle

3.3. RKAP

3.3.1. Opex/Capex

4. Technology Adoption (PoC)

4.1. Infrastructure as Code (IaC)

4.1.1. EDB Trusted Postgres Architect (TPA)

4.1.1.1. Virtualization

4.1.1.2. Consolidation (Multiple cluster/instances)

4.1.2. Database as Code

4.1.2.1. Liquibase

4.1.3. Security as Code

4.1.4. Terraform

4.2. Active-Active Solution

4.2.1. EDB Postgres Replication Server for Active-active replication

4.2.2. Oracle Goldengate - Active-active replication

4.2.3. EDB BDR (Bi-Directional Replication)

4.2.4. Innodb Clusterset

4.3. New Tech-DBMS

4.3.1. Couchbase

4.3.2. yugabyte

4.3.3. Cloud database

4.3.3.1. AWS

4.3.3.2. Azure

4.3.4. MongoDB

4.3.5. No-SQL

4.4. Cloud-Native and DBaaS

4.4.1. Autonomous/Self-Driving Databases

4.4.1.1. Oracle ADB

4.4.1.2. Nutanix ERA

4.4.1.3. On-Premis CMP

5. Continuous Improvement

5.1. AI Ops

5.1.1. GenAI DBA Ops

5.1.2. Anomaly Detection

5.1.3. Forecasting and Predictive Analytics

5.2. MySQL Operator for Kubernetes

5.3. Oracle Fleet Patching and Provisioning

5.4. Automation and Orchestration

5.5. Training, Certification, Sharing

6. Role

6.1. Database Administrator

6.1.1. L1

6.1.1.1. BAU

6.1.2. L2

6.1.2.1. Migration

6.1.2.2. Upgrade

6.1.2.3. Normal Change

6.2. Database Architect

6.2.1. Database Catalog and Assessment

6.2.2. Database design standards

6.3. Data Engineer

6.3.1. ETL (Extract, Transform, Load)

6.3.2. Optimize queries and data transformation processes