Senior Oracle Database Administrator (DBA)

- Pay Rate: $84.70/hour, depending on experience
- Contract End Date: November 2027
- Location: Calgary, Alberta

Raise is currently hiring a Senior Oracle Database Administrator (DBA) on behalf of our client. They’re expanding their team to meet growing needs, making this a unique chance to work with an industry leader. Our client is responsible for the safe and reliable operation of the Alberta Interconnected Electric System.

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 (ExaCC) Database Administrator (DBA) consultant will support a multi-year initiative to implement and operationalize ExaCC as an enterprise database platform for multiple applications and business services. The successful candidate will be a hands‑on technical implementer with deep Oracle database engineering expertise and demonstrated experience delivering ExaCC environments from implementation through database migration and onboarding, stabilization, and transition to production operations.

Responsibilities

- ExaCC Implementation and Technical Delivery
- Participate in technical planning and implement ExaCC database environments in accordance with approved strategy and architecture, security standards, prerequisites, and delivery plans.
- Coordinate with platform/infrastructure teams and Oracle support on ExaCC provisioning, connectivity, lifecycle activities, configuration, and technical issue resolution.




- Validate environment readiness, database prerequisites, network connectivity, access, monitoring, backup/recovery, and operational dependencies before onboarding workloads.
- Develop implementation plans, runbooks, test plans, rollback procedures, cutover plans, and technical documentation.
- Troubleshoot implementation issues across the database, RAC, ASM, Exadata, OCI connectivity, and related service components.
- Database Migration, Onboarding and Cutover
- Assess source databases and application dependencies for migration to ExaCC, including versions, configurations, database size, growth, workload characteristics, availability requirements, and compatibility considerations.
- Develop and execute database migration and onboarding plans, including migration method selection, prerequisites, rehearsal, validation, cutover, rollback, and post-migration verification.
- Coordinate with application owners and technical teams to schedule migrations, manage dependencies, minimize business disruption, and confirm application connectivity and functionality after cutover.
- Validate database objects, data consistency, performance, security, jobs, interfaces, and operational monitoring following migration.




- Maintain migration records, issue logs, acceptance evidence, and lessons learned; support remediation of migration‑related defects.
- Oracle GoldenGate Implementation and Replication
- Design, configure, implement, and troubleshoot Oracle GoldenGate replication for approved use cases, including source/target preparation, Extract and Replicat configuration, trail management, checkpoints, credentials, and supporting processes as applicable to the selected architecture and GoldenGate version.
- Implement and validate initial data load and ongoing change replication, including coordination of initial‑load and change‑capture approaches where required.
- Configure and validate replication mappings, table‑level inclusion/exclusion, supplemental logging, conflict/exception handling, and error‑handling procedures as required by the solution.
- Monitor replication lag, throughput, process health, trail growth, checkpoints, and data consistency; investigate and resolve abends, latency, data divergence, and other replication failures.
- Plan and execute GoldenGate deployment changes, upgrades or patching where in scope, failover/recovery procedures, restart/reposition activities, and controlled resynchronization when necessary.
- Develop repeatable implementation scripts, validation checks, operational runbooks, and alerting for GoldenGate services.
- Document replication topology, dependencies, recovery procedures, support boundaries, and service‑level expectations; demonstrate the solution and

📌 Senior Oracle Database Administrator (Calgary)
🏢 Ian Martin Group
📍 Calgary