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 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.
Linux & Infrastructure Administration
- Administer Oracle database environments running on Red Hat Enterprise Linux (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.
Managed Services & Customer Support
- 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 accurate 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.
Ideal Candidate
- The ideal candidate combines strong Oracle DBA and high-availability expertise with a customer-focused mindset and a willingness to develop broader infrastructure and cloud skills.
What we are looking for:
- Minimum 3 years of hands-on experience deploying, administering, and supporting Oracle 19c databases, including Oracle RAC and Data Guard standby database environments.
- Demonstrated 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.
- Proven 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.
- Ownership: Takes responsibility for issues and follows them through to resolution.
- Curiosity: Investigates beyond the obvious symptoms to understand the underlying problem.
- Sound judgment: Assesses production risks before implementing changes.
- Persistence: Uses diagnostic tools, logs, documentation, testing, and responsible AI-assisted research to resolve unfamiliar problems.
- Collaboration: Works effectively with colleagues and communicates clearly with customers.
- Continuous improvement: Documents lessons learned and identifies opportunities to improve system reliability, monitoring, and operational processes.
What would make you stand out:
- 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.
What we can offer:
- 3 weeks’ vacation and 5 personal days
- Comprehensive Medical, Dental, and Vision benefits starting from your first day of employment
- Employee stock ownership and RRSP/401k matching programs
- Lifestyle rewards
- Remote work and more!
About Cayenta:
Cayenta is a leading provider of enterprise resource management solutions in the local government, utility and financial industries. Cayenta’s products, services and customer relationships provide the foundation for continued innovation and growth.
About Harris:
Harris is a leading provider of mission critical software to the public sector in North America. As a wholly owned subsidiary of Constellation Software Inc. (“CSI”, symbol CSU on the TSX), Harris has become the cornerstone for CSI’s investment in utility, local government, school districts, public safety, and healthcare software verticals. Our success has been realized through investments in our proprietary software and market expertise. This focus, combined with acquiring businesses that build upon or complement our offerings, has helped drive our success. Harris will continue to growth through reinvestment – both in the people and products that we offer and making investments in acquiring new businesses.
#LI-remote
