This course is in active development. Preview the scope below and create a free account to be notified the moment it goes live.
OCI Database AWS Architect
The certification validates an architect’s ability to design, secure, and operate Oracle OCI Database Service within AWS environments, covering multi‑cloud architecture, networking, high availability, and operational best practices.
Who Should Take This
It is intended for senior cloud architects, solutions engineers, or database specialists who have several years of experience designing enterprise‑grade workloads on AWS and OCI and seek to demonstrate strategic expertise in integrating Oracle database services across multi‑cloud platforms and complex data pipelines.
What's Covered
1
Multi-Cloud Architecture
2
Networking
3
Security
4
High Availability
5
Database Operations
6
Backup and Recovery
7
Monitoring and Observability
8
Cost and Migration
What's Included in AccelaStudy® AI
Course Outline
64 learning goals
1
Multi-Cloud Architecture
2 topics
Architecture Fundamentals
- Configure OCI Database Service deployment in AWS regions with Exadata infrastructure provisioning and capacity planning.
- Implement multi-cloud architecture with OCI database tier and AWS application tier connected via low-latency interconnect.
- Analyze multi-cloud requirements to evaluate OCI Database Service positioning versus AWS-native database alternatives.
- Design multi-cloud database strategies optimizing performance, cost, and operational efficiency across OCI and AWS.
Deployment Models
- Implement Exadata VM cluster deployment with shape selection, node configuration, and storage allocation in AWS regions.
- Configure Autonomous Database Dedicated deployment on Exadata in AWS with container database and PDB provisioning.
- Analyze workload characteristics to select between Exadata VM clusters and Autonomous Dedicated for deployment scenarios.
- Recommend deployment architectures balancing database licensing, performance requirements, and operational complexity.
2
Networking
2 topics
Cross-Cloud Connectivity
- Configure OCI-AWS interconnect with private connectivity, CIDR planning, and routing table management for database access.
- Implement VCN-to-VPC connectivity with subnet design, security rules, and DNS resolution for cross-cloud name lookup.
- Analyze network latency and bandwidth to evaluate interconnect performance impact on application-database communication.
- Design network architectures minimizing cross-cloud latency while maintaining security isolation between environments.
Private Endpoints
- Implement private endpoint configuration for database access from AWS VPCs without public internet exposure.
- Configure DNS resolution with private hosted zones, conditional forwarders, and service endpoint name resolution.
- Analyze endpoint security to evaluate private connectivity options preventing data exposure during cross-cloud transit.
- Recommend endpoint architectures supporting multiple AWS accounts and VPCs accessing shared OCI database resources.
3
Security
2 topics
Encryption and Keys
- Configure database encryption with TDE, customer-managed keys, and OCI Vault integration for key lifecycle management.
- Implement data-in-transit encryption with TLS certificates, mutual authentication, and minimum protocol version enforcement.
- Analyze encryption requirements to evaluate key management strategies spanning OCI and AWS security boundaries.
- Design end-to-end encryption architectures meeting compliance requirements for multi-cloud database deployments.
Access Control
- Implement IAM integration with OCI policies, AWS IAM roles, and cross-cloud identity federation for database access.
- Configure database user authentication with wallet-based connections, mutual TLS, and password vault integration.
- Analyze access control requirements to evaluate identity management strategies for multi-cloud administrative access.
- Recommend access governance frameworks ensuring least-privilege database access across OCI and AWS security domains.
4
High Availability
2 topics
Database HA
- Configure Data Guard for database HA with standby databases, protection modes, and role transition procedures.
- Implement automatic failover with Fast-Start Failover, observer configuration, and application reconnection handling.
- Analyze HA requirements to evaluate RPO and RTO targets achievable with Data Guard in OCI-AWS environments.
- Design HA architectures maximizing database uptime while minimizing failover impact on AWS-hosted applications.
Disaster Recovery
- Implement cross-region DR with remote Data Guard standbys, backup replication, and DR testing procedures.
- Configure automated backup strategies with retention policies, cross-region backup copying, and point-in-time recovery.
- Analyze DR scenarios to evaluate recovery strategies for different failure modes including region-level outages.
- Recommend DR architectures balancing recovery objectives with infrastructure cost for multi-cloud Oracle databases.
5
Database Operations
2 topics
Patching and Maintenance
- Implement database patching strategies with rolling patches, out-of-place patching, and maintenance window scheduling.
- Configure automated patching policies with patch level selection, pre-check validation, and rollback procedures.
- Analyze patch management to evaluate maintenance strategies minimizing downtime for AWS application dependencies.
- Design maintenance frameworks coordinating OCI database patching with AWS application deployment schedules.
Scaling and Performance
- Implement database scaling with CPU adjustment, storage expansion, and Exadata shape resizing for workload changes.
- Configure performance monitoring with AWR, ASH, SQL Monitor, and OCI Performance Hub for proactive tuning.
- Analyze database performance to identify bottlenecks in cross-cloud query execution and I/O throughput.
- Recommend scaling strategies optimizing database resources for variable workloads while controlling infrastructure cost.
6
Backup and Recovery
2 topics
Backup Configuration
- Implement automated backup with RMAN, Object Storage targets, retention policies, and incremental backup strategies.
- Configure backup encryption with customer-managed keys, backup validation, and cross-region backup copy procedures.
- Analyze backup requirements to evaluate strategies balancing recovery speed, storage cost, and data protection.
- Design backup architectures supporting compliance requirements for data retention across multi-cloud environments.
Recovery Procedures
- Implement database recovery using point-in-time, SCN-based, and tablespace-level recovery for different failure modes.
- Configure recovery testing with restore validation, DR drill automation, and recovery time measurement procedures.
- Analyze recovery scenarios to evaluate procedure effectiveness for data corruption, human error, and infrastructure failures.
- Recommend recovery frameworks ensuring tested, documented procedures for all identified failure scenarios.
7
Monitoring and Observability
2 topics
OCI Monitoring
- Implement OCI monitoring with alarm definitions, metric queries, and notification channels for database health tracking.
- Configure Operations Insights with database fleet monitoring, SQL analytics, and capacity planning recommendations.
- Analyze monitoring data to identify performance trends, capacity constraints, and anomalous database behavior patterns.
- Design observability architectures integrating OCI database metrics with AWS monitoring tools for unified visibility.
Operational Automation
- Implement OCI CLI and SDK automation for database lifecycle operations including provisioning, scaling, and patching.
- Configure event-driven automation with OCI Events, Functions, and Notifications for automated operational responses.
- Analyze automation opportunities to evaluate operational efficiency improvements from infrastructure-as-code adoption.
- Recommend automation strategies reducing manual operational burden while maintaining governance and audit compliance.
8
Cost and Migration
2 topics
Cost Management
- Implement cost tracking with OCI Cost Analysis, budgets, and tagging strategies for database infrastructure spending.
- Configure cost optimization with reserved capacity, flexible scaling, and workload-appropriate shape selection.
- Analyze cost structures to evaluate TCO comparison between OCI Database Service and AWS-native database alternatives.
- Recommend cost management strategies balancing performance requirements with budget constraints for multi-cloud databases.
Migration Planning
- Implement database migration using Zero Downtime Migration, Data Pump, and GoldenGate for AWS-to-OCI database moves.
- Configure migration assessment with OCI Database Migration Service prerequisites, network readiness, and compatibility checks.
- Analyze migration complexity to evaluate downtime impact, data volume challenges, and application dependency mapping.
- Design migration strategies ensuring minimal disruption when transitioning AWS-hosted databases to OCI Database Service.
Scope
Included Topics
- All domains in the OCI Database Service for AWS Architect exam: multi-cloud architecture, database deployment, networking, security, HA/DR, and operations.
- OCI Database Service deployed in AWS regions: Exadata infrastructure, VM clusters, and Autonomous Database on Dedicated.
- Multi-cloud networking: OCI-AWS interconnect, private endpoints, DNS resolution, and cross-cloud traffic routing.
- Database operations: backup, patching, scaling, monitoring, and performance tuning across OCI-AWS infrastructure.
Not Covered
- AWS-native database services including RDS, Aurora, and DynamoDB configuration.
- OCI-only database services not available through the AWS multi-cloud deployment model.
- Application development, SQL programming, and database schema design beyond infrastructure architecture.
- Third-party database products and non-Oracle database migration patterns.
Official Exam Page
Learn more at Oracle
1Z0-1117 is coming soon
Adaptive learning that maps your knowledge and closes your gaps.
Create Free Account to Be Notified