Posted 15 days ago
Senior Oracle Database Administrator (DBA)
@ JSG (Johnson Service Group, Inc.)
Calgary, Alberta
SIGNALS
Overview
JSG (Johnson Service Group, Inc.) is hiring a Senior Oracle Database Administrator contractor for an electric utility client in Calgary, Alberta. The role implements and operates Oracle Exadata Cloud@Customer (ExaCC) as an enterprise database platform, covering migrations, GoldenGate replication, Data Guard, RAC, ASM and OCI administration. The posting states a contract engagement and requires 7+ years of hands-on Oracle DBA experience.
Responsibilities:
- Implement ExaCC database environments and onboard workloads
- Plan and execute database migrations, rehearsal and cutover
- Configure and troubleshoot GoldenGate replication
- Administer Data Guard, RAC and ASM for high availability
- Manage OCI tenancy resources supporting ExaCC
Requirements summary:
- 7+ years hands-on Oracle DBA experience
- Hands-on Oracle Exadata Cloud@Customer experience
- Practical GoldenGate implementation and troubleshooting
- Data Guard switchover and failover experience
- OCI IAM, networking and monitoring experience
Tools & skills
Source and dates
Source type not verified · apify-linkedin
- Employer posting date
- 2026-10-26
- First seen by our source
- 2026-11-11
- Source record updated
- 2026-11-11
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 7+ years |
| Work setting | Office, Client sites |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Education | Bachelor’s degree (required) |
| Fields of study | Computer Science, Engineering, Information Technology |
Summary and details written by AI from the posting; the employer’s posting is the authority.
JSG (Johnson Service Group, Inc.)
| Field | Value |
|---|---|
| Open jobs on Jobsy | 4 |
Job description
Johnson Service Group (JSG) is currently looking for a Senior Oracle Database Administrator (DBA) with experience in Oracle Exadata Cloud@Customer (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 Description
JSG’s client is seeking a highly skilled and experienced Oracle Exadata Cloud@Customer (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
ExaCC Implementation and Technical Delivery
Job Description
JSG’s client is seeking a highly skilled and experienced Oracle Exadata Cloud@Customer (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 Cloud@Customer; 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.
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.
- 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.
- 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 transfer knowledge to operations teams.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.