Senior Oracle Database Administrator

Johnson Service Group (JSG) is currently looking for a
Senior Oracle Database Administrator (DBA)
with experience in
Oracle Exadata View email address on ca.hrm.tc (ExaCC), Oracle Database administration, RAC, ASM, Data Guard, GoldenGate, OCI, database migrations, and high availability/disaster recovery. This is a
contract opportunity
with an
electric utility client
in
Calgary, Alberta .
Job DescriptionJSG’s client is seeking a highly skilled and experienced Oracle Exadata View email address on ca.hrm.tc (ExaCC) Database Administrator (DBA) consultant to 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.
Required Qualifications And Experience
Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field, or an equivalent combination of education and relevant professional experience.
7+ years of hands‑on Oracle Database administration experience, including advanced administration and troubleshooting of Oracle RAC, ASM, backup/recovery, and Data Guard.
Demonstrated hands‑on experience implementing and operating Oracle Exadata View email address on ca.hrm.tc;
experience with Oracle Exadata engineered systems is essential.
Strong practical experience implementing, configuring, and troubleshooting Oracle GoldenGate replication. Candidates should be able to explain and demonstrate implementation choices, monitoring, recovery, and problem resolution—not only routine monitoring.
Hands‑on experience planning and executing Oracle database migrations and onboarding, including assessment, rehearsal, validation, cutover, rollback planning, and post‑migration stabilization.
Experience implementing and testing Oracle Data Guard high‑availability and disaster‑recovery configurations, including switchover/failover procedures as applicable.
Practical experience with Oracle RAC and ASM administration, performance tuning, database troubleshooting, patching, and production support.
Experience administering relevant OCI tenancy services, including IAM, compartments, networking, monitoring, and other OCI services used by the ExaCC solution.
Experience with Oracle Enterprise Manager (OEM) or equivalent tooling for database monitoring, alerting, diagnostics, and operational visibility.
Experience with scripting and automation to make implementation and operational processes repeatable and supportable.
Strong understanding of change management, incident/problem management, technical documentation, operational readiness, and production service transition.
Key ResponsibilitiesExaCC 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 resolveabends, 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 transfer knowledge to operations teams.
Oracle Data Guard, RAC and High Availability / Disaster Recovery
Implement, configure, and maintain Oracle Data Guard environments, including physical standby configurations and role transitions, in accordance with approved recovery objectives and design.
Configure and validate Data Guard transport/apply, monitoring, switchover, failover, reinstatement, and recovery procedures as applicable to the architecture and licensed features.
Administer Oracle RAC databases and related Clusterware and ASM components, including installation/configuration support, service management, troubleshooting, patching coordination, and availability validation.
Plan and participate in high‑availability and disaster‑recovery tests;
capture results, resolve defects, and maintain documented recovery procedures.
Understand and clearly document the distinct purposes and operational implications of RAC, Data Guard, and GoldenGate;
implement each according to the workload's approved requirements.
Oracle Database and Exadata Administration
Install, configure, patch, upgrade, and maintain Oracle databases hosted on ExaCC, following approved change management and vendor‑supported procedures.
Perform advanced performance analysis and tuning across SQL execution, execution plans, wait events, memory, I/O, storage, database services, and Exadata‑specific capabilities where applicable.
Manage database capacity, tablespaces, space usage, growth forecasting, database configuration, users, roles, privileges, schemas, jobs, and database security controls.
Administer and validate backup and recovery, including restore/recovery testing and coordination with applicable OCI/ExaCC backup capabilities.
Investigate complex database incidents, identify root causes, implement corrective actions, and recommend preventative improvements.
OCI Tenancy and ExaCC Supporting Services
Administer relevant OCI tenancy resources, compartments, IAM policies and groups, network resources, monitoring, alerts, and service configurations required to support ExaCC.
Support VCN, subnet, routing, security list/Network Security Group, DNS, connectivity, and access troubleshooting in coordination with network and security teams.
Use applicable OCI monitoring, logging, Object Storage, and backup services where included in the approved solution.
Coordinate ExaCC and OCI lifecycle activities with Oracle and internal stakeholders, following assigned responsibilities and service boundaries.
Apply least‑privilege access, secure configuration, auditability, and organizational change and access‑management controls.
Monitoring and Operational Readiness
Establish and maintain actionable monitoring, alerting, health checks, capacity indicators, and operational dashboards for databases, RAC, GoldenGate, Data Guard, and relevant OCI components.
Develop and maintain standard operating procedures, implementation guides, support runbooks, configuration records, dependency maps, and knowledge‑transfer materials.
Support production readiness reviews, service acceptance, incident/problem/change management, root‑cause analysis, and continuous service improvement.
Define and report relevant operational measures such as availability, backup success, recovery‑test outcomes, replication lag, incident trends, and capacity/performance indicators.
Security, Compliance and Collaboration
Apply database security and hardening practices, access controls, audit requirements, patching standards, and data‑handling requirements in accordance with JSG’s client policies and approved designs.
Work collaboratively with application owners, solution architects, infrastructure, networking, cybersecurity, service management, project delivery, Oracle support, and other delivery partners.
Provide clear technical status, risks, dependencies, implementation decisions, incident findings, and recommendations to technical and project stakeholders.
Support audits and compliance evidence gathering related to database access, configuration, changes, availability, backup/recovery, and operational controls.
Key Attributes
Strong analytical, diagnostic, and problem‑solving skills, including the ability to investigate complex cross‑layer issues.
Implementation‑oriented and hands‑on, with a disciplined approach to testing, change control, risk management, and production readiness.
Effective communicator who can work independently while collaborating with multidisciplinary teams and external service providers.
High‑quality technical documentation, knowledge transfer, and operational discipline.
Strong focus on security, reliability, availability, recoverability, and continuous improvement.
Johnson Service Group (JSG) is an Equal Opportunity Employer. JSG provides equal employment opportunities to all applicants and employees without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, marital status, protected veteran status, or any other characteristic protected by law.
#J-18808-Ljbffr