Oracle DBA

Oracle Core DBA

A Core DBA traditionally manages on-premises databases. Their toolset revolves around direct database administration, storage, networking, and operating system integration.

Common Tools Used by Core DBAs

1. SQL*Plus / SQL Developer
   • Running queries, PL/SQL scripts, schema management.
2. Oracle Enterprise Manager (OEM / Cloud Control)
   • Centralized monitoring and administration for multiple databases.
3. RMAN (Recovery Manager)
   • Backup and recovery operations.
4. Data Pump (expdp/impdp)
   • Data migration and export/import.
5. Operating System Tools (Linux/Unix utilities)
   • top, vmstat, iostat, sar for performance monitoring.
   • Shell scripts for automation.
6. Grid Infrastructure / ASM tools
   • For RAC, ASM, and clustering management.
7. Listener Control (lsnrctl)
   • Network listener configuration and troubleshooting.
8. Performance Views and Reports
   • AWR, ASH, ADDM, v$ views for tuning and monitoring.

Cloud Ops DBA

A Cloud Ops DBA works in cloud-native or hybrid environments. They still use Oracle database tools, but the scope expands to cloud provider services, automation frameworks, and monitoring platforms.

Common Tools Used by Cloud Ops DBAs

1. Cloud Provider Portals
   • OCI Console (Oracle Cloud Infrastructure)
   • AWS RDS Console
   • Azure Portal
   • Used for provisioning, scaling, patching, and monitoring cloud databases.
2. Cloud CLI and SDKs
   • OCI CLI (oci db system list, oci db backup list)
   • AWS CLI (aws rds describe-db-instances)
   • Azure CLI (az sql db list)
3. Cloud-native Monitoring & Logging
   • OCI Monitoring & Logging
   • AWS CloudWatch
   • Azure Monitor
   • To track metrics like CPU, IOPS, storage, latency.
4. Terraform / Ansible
   • Infrastructure as Code (IaC) for automating database provisioning and configuration.
5. Database-native Tools (Still relevant)
   • SQL*Plus, SQL Developer, RMAN, Data Pump, OEM are still used inside cloud-hosted databases.
6. Third-party Monitoring Tools
   • Datadog, New Relic, Prometheus, Grafana (to integrate with cloud DB metrics).
7. Networking and Security Tools
   • Cloud IAM (Identity & Access Management)
   • Cloud security groups, firewalls, encryption services.
8. Automation & Scripting
   • Shell/Python scripts interacting with cloud APIs and CLIs.

In Short

• Core DBA → Focuses on Oracle-native tools and OS-level monitoring.
• Cloud Ops DBA → Uses cloud-native tools (OCI, AWS, Azure) along with traditional Oracle tools, and relies heavily on automation and monitoring platforms.