(Remote) Technical Consultant – Oracle DBA

Harris Computer • Washington, PE

2d • CA$75,000 - CA$85,000 • Remote

About The Position

Cayenta, a division of Harris, is seeking a Technical Consultant with hands-on Oracle Database Administration experience to join its Managed Services team. The role focuses on administering, maintaining, troubleshooting, and optimizing Oracle 19c environments, including Real Application Clusters (RAC), Oracle Grid Infrastructure, and Data Guard standby databases. The successful candidate will support business-critical customer environments, helping ensure database availability, stability, performance, and recoverability. The position also includes broader infrastructure support, technical troubleshooting, customer communication, and collaboration with internal technical teams. The role is remote and open to candidates anywhere in Canada and the US; preference is given to candidates able to work in the PST time zone.

The consultant will support multiple customer environments in a managed services model, handle production incidents and service requests, and participate in scheduled after-hours maintenance and on-call support as required. Candidates are expected to take ownership of technical challenges, investigate issues thoroughly, and work comfortably in complex production environments. The company also expects curiosity and willingness to adopt AI-enabled tools, including copilots, chat-based assistants, and automation tools, while applying appropriate judgment and following security and compliance standards.

Cayenta offers 3 weeks’ vacation, 5 personal days, comprehensive medical, dental, and vision benefits starting on the first day of employment, employee stock ownership, RRSP/401k matching programs, lifestyle rewards, and remote work. Cayenta provides enterprise resource management solutions for local government, utility, and financial industries. Harris provides mission-critical software to the public sector in North America.

Requirements

• At least 3 years of hands-on experience deploying, administering, and supporting Oracle 19c databases, including Oracle RAC and Data Guard standby database environments.
• Production experience managing Oracle RAC clusters, including cluster administration, troubleshooting, and high-availability operations.
• Hands-on experience configuring, administering, and maintaining Oracle Data Guard standby databases.
• Strong working knowledge of Oracle Grid Infrastructure, Oracle Clusterware, and ASM.
• Experience administering Oracle databases on RHEL and/or Oracle Linux, with working knowledge of both operating environments.
• Ability to perform Oracle database performance tuning, including SQL optimization, execution-plan analysis, and use of Oracle diagnostic tools.
• Experience with Oracle RMAN backup, restore, and recovery operations.
• Practical experience with Oracle database patching, upgrades, and maintenance.
• Strong Linux troubleshooting skills and familiarity with shell scripting.
• Experience troubleshooting complex production incidents and performing root-cause analysis.
• Strong communication, analytical, documentation, and problem-solving skills.
• Ability to work independently, manage competing priorities, and take ownership of customer issues.
• Take responsibility for issues and follow them through to resolution.
• Investigate beyond obvious symptoms to understand underlying problems.
• Assess production risks before implementing changes.
• Use diagnostic tools, logs, documentation, testing, and responsible AI-assisted research to resolve unfamiliar problems.
• Work effectively with colleagues and communicate clearly with customers.
• Document lessons learned and identify opportunities to improve system reliability, monitoring, and operational processes.
• Willingness to adopt and leverage AI tools while maintaining appropriate judgment, security, and compliance standards.

Nice To Haves

• Microsoft SQL Server administration and troubleshooting experience.
• Experience administering Oracle databases or infrastructure in Microsoft Azure or other cloud environments.
• Familiarity with Windows Server administration and virtualization technologies.
• Experience with PowerShell, Azure CLI, or infrastructure automation.
• Knowledge of networking fundamentals, including TCP/IP, DNS, firewalls, SSL/TLS certificates, and connectivity troubleshooting.
• Experience with Apache Tomcat, web application infrastructure, and application troubleshooting.
• Familiarity with Microsoft Entra ID, Active Directory, and identity/access management.
• Experience with monitoring tools, Jira, TeamSupport, or similar service management platforms.
• Oracle Database administration certifications or relevant cloud certifications.
• Experience supporting ERP, Customer Information Systems (CIS), or utility-industry applications.
• Previous experience working in Managed Services or customer-facing production support environments.
• Ability to work in the PST time zone.

Responsibilities

• Deploy, configure, administer, and maintain Oracle Database 19c environments.
• Manage Oracle RAC cluster health, nodes, troubleshooting, and maintenance.
• Administer Oracle Data Guard physical standby databases, monitor redo transport and apply, troubleshoot replication issues, and support switchover and failover activities.
• Install, configure, patch, and maintain Oracle Grid Infrastructure, Clusterware, and 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 RMAN.
• Participate in disaster recovery planning, validation, and testing.
• Investigate and resolve database performance issues involving 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 query optimization, indexing analysis, and database configuration tuning.
• Troubleshoot Oracle database, RAC, Grid Infrastructure, ASM, and Data Guard issues using diagnostic logs and monitoring tools.
• Conduct root-cause analysis for production incidents and recommend corrective and preventive actions.
• Administer Oracle database environments running on RHEL and Oracle Linux.
• Troubleshoot Linux operating system, storage, networking, permissions, and resource-related issues affecting database operations.
• Support OS-level maintenance, patching, monitoring, and configuration.
• Develop and maintain shell scripts to automate routine database administration and monitoring tasks.
• Support multiple customer environments in a managed services model.
• Investigate production incidents, assess operational risks, and implement changes through established change-management procedures.
• Manage technical incidents, service requests, and maintenance activities through ticketing systems.
• Maintain technical documentation, operational procedures, and knowledge-base articles.
• Communicate technical findings, risks, and resolutions clearly to customers and internal stakeholders.
• Collaborate with application, infrastructure, cloud, and support teams to resolve complex technical issues.
• Participate in scheduled after-hours maintenance and on-call support as required.
• Use AI-enabled technologies and automation tools to improve workflows, solve problems, and increase efficiency while maintaining appropriate judgment, security, and compliance standards.

Benefits

• 3 weeks’ vacation and 5 personal days.
• Comprehensive medical, dental, and vision benefits starting from the first day of employment.
• Employee stock ownership.
• RRSP/401k matching programs.
• Lifestyle rewards.
• Remote work.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed