Oracle Exadata Cloud@Customer (ExaCC) Senior DBA Consultant
- Pay Rate: $86.39/hour, depending on experience
- Contract:1 year
- Location: Calgary, Alberta
Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable.
Description
The Oracle Exadata Cloud@Customer (ExaCC) Database Administrator (DBA) Consultant in this role will support a strategic, multi-year enterprise initiative. In this role, you will implement and operationalize ExaCC as an enterprise database platform across multiple core applications and business services. As a hands-on technical implementer with deep Oracle database engineering expertise, you will lead the end-to-end delivery of ExaCC environments—from initial provisioning, OCI infrastructure setup, and database migrations to stabilization, performance optimization, and transition into production operations.
Responsibilities
- ExaCC Platform Implementation & Delivery: Lead the end-to-end setup and provisioning of ExaCC environments, including OCI tenancy administration, IAM policy creation, compartment structures, VCN networking/peering, Object Storage, and monitoring configurations.
- Database Migration & Cutover Management: Plan, execute, and validate Oracle database migrations onto the ExaCC platform. Develop comprehensive migration strategies, manage dry-run rehearsals, execute cutovers, establish rollback plans, and stabilize environments in partnership with application owners.
- High Availability & Disaster Recovery (HA/DR): Architect, deploy, and troubleshoot Oracle Data Guard (switchover, failover, DR testing) and Oracle GoldenGate replication (Extract/Replicat, initial loads, lag resolution, resyncs, abends). Correctly align HA/DR patterns (RAC vs. Data Guard vs. GoldenGate) based on business RPO/RTO requirements.
- Performance Tuning & Optimization: Conduct deep-dive performance analysis using advanced Exadata capabilities (Smart Scan, Offloading, HCC, Storage Indexing) as well as SQL tuning, wait-event analysis, and I/O optimization.
- Operational Readiness & Transition: Establish Oracle Enterprise Manager (OEM) monitoring, build automated operational scripts, author runbooks, enforce change/incident/security compliance, and deliver clear status reporting to technical leads and project stakeholders.
Qualifications
Education and
- 7+ Years of Senior Oracle DBA Expertise: Deep, hands-on experience managing enterprise Oracle environments, Real Application Clusters (RAC), Automatic Storage Management (ASM), Grid Infrastructure/Clusterware, patching, upgrades, and backup/recovery (RMAN).
- Proven ExaCC & OCI Delivery: Demonstrated history of delivering ExaCC environments from bare-metal provisioning and readiness checks through production handover.
- Proven Migration Success: Track record of leading complex, multi-terabyte database migrations with minimal downtime and zero data loss.
- Technical Skills
- Oracle Exadata & OCI: ExaCC architecture, ExaCC Cloud Control / OCI Console, OCI IAM, Compartments, VCNs/Subnets, Dynamic Routing Gateways (DRG), Object Storage, and OCI Monitoring/Logging.
- Replication & HA/DR: Advanced Oracle GoldenGate engineering (Classic/Microservices, bidirection/unidirectional) and Oracle Active Data Guard setup, configuration, and testing.
- Database Administration & Tuning: Oracle 19c/23c, RAC, ASM, RMAN, AWR/ASH analysis, SQL Tuning Advisor, Execution Plans, and Exadata-specific features (Smart Scans, Flash Cache, HCC).
- Automation & Scripting: Shell scripting (Bash), Python, or Ansible for database automation, health checks, and routine maintenance tasks.
- Tooling & Governance: Oracle Enterprise Manager (OEM) 13c/14c, ITIL processes (Change, Incident, Problem Management), and security auditing standards.
- Core Competencies & Soft Skills
- Technical Leadership: Ability to guide project teams and application owners through complex database transformations and migrations.
- Clear Communication: Excellent verbal and written communication skills for delivering precise status reports and technical updates to both technical teams and business stakeholders.
- Problem-Solving & Agility: Strong diagnostic skills under pressure during critical cutovers, production issues, or performance bottlenecks.
- Certifications
- Bachelor’s Degree in Computer Science, Information Technology, Software Engineering, Computer Engineering, or a closely related STEM field.
- Recommended & Preferred Certifications
- Oracle Cloud Infrastructure Database Services Certified Professional
- Oracle Cloud Infrastructure Architect Associate or Professional
- Oracle Cloud Database Migration and Integration Certified Professional
- Calgary (onsite at client office 4 days a week)
Additional Information
Location: Calgary (onsite at client office 4 days a week)
#WES
#LI-SC1