(Remote) Technical Consultant – Oracle DBA

Cayenta, a division of Harris; is seeking a Technical Consultant who has strong hands-on experience in Oracle Database Administration to join our Managed Services team.

 

This role will primarily focus on administering, maintaining, troubleshooting, and optimizing Oracle 19c database environments, including Real Application Clusters (RAC), Oracle Grid Infrastructure, and Data Guard standby databases.

 

The successful candidate will support business-critical customer environments, ensuring database availability, stability, performance, and recoverability.

The position also involves broader infrastructure support, technical troubleshooting, customer communication, and collaboration with internal technical teams.

 

We are looking for someone who takes ownership of technical challenges, investigates issues thoroughly, and is comfortable working in complex production environments.

 

This remote role welcomes candidates anywhere in Canada and the US.

Preference will be given to candidates who can work in PST timezone.

 

Salary:

75K - 85K

53K - 61K

 

AI & Innovation Mindset

We are committed to leveraging emerging technologies to improve how we work, serve our customers, and drive business outcomes.

The successful candidate will demonstrate curiosity and a willingness to actively adopt and leverage AI tools to improve workflows, solve problems, and increase efficiency.

Candidates should be comfortable using AI enabled technologies, including copilots, chat based AI assistants, and automation tools, as part of their everyday work while maintaining appropriate judgment, security, and compliance standards.

 

What your impact will be:

Oracle Database Administration & High Availability


* Deploy, configure, administer, and maintain Oracle Database 19c environments.


* Manage Oracle Real Application Clusters (RAC), including cluster health, node management, troubleshooting, and maintenance.


* Administer Oracle Data Guard physical standby databases, including monitoring redo transport and apply, troubleshooting replication issues, and supporting switchover and failover activities.


* Install, configure, patch, and maintain Oracle Grid Infrastructure, Clusterware, and Automatic Storage Management (ASM).


* Perform database and Grid Infrastructure patching, upgrades, and scheduled maintenance while minimizing customer disruption.


* Monitor database availability, capacity, storage, performance, and overall system health.


* Support backup and recovery procedures using Oracle Recovery Manager (RMAN).


* Participate in disaster recovery planning, validation, and testing.

 

Performance Tuning & Troubleshooting


* Investigate and resolve database performance issues, including slow SQL queries, locking, blocking, memory utilization, and resource contention.


* Analyze AWR and ADDM reports, ASH data, execution plans, and database wait events to identify performance bottlenecks.


* Perform SQL q...