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
Skills Required
- 3+ years of experience in technical support, system administration, managed services, infrastructure, database administration, or a related technical role; equivalent education and experience considered
- Experience with or strong working knowledge of Microsoft SQL Server
- Working knowledge of Windows and/or Linux system administration
- Some experience with or knowledge of Microsoft Azure
- Strong analytical and troubleshooting skills
- Ability to independently investigate unfamiliar technical problems
- Ability to work independently with minimal supervision and collaborate or escalate appropriately
- Strong customer-service mindset and ability to develop trusted customer relationships
- Ability to balance multiple customer environments, priorities, and deadlines
- Experience with Apache Tomcat, including configuration, hardening, and SSL certificates
- Strong written and verbal communication skills
- Strong time-management and organizational skills
- Experience using Jira, TeamSupport, or comparable ticketing or work-management systems
- Willingness to participate in weekend schedules or alternative workweeks when required
- Willingness to participate in an on-call rotation when required
- Commitment to continuous learning, documentation, knowledge sharing, and improvement
- Comfort responsibly using AI-assisted tools for technical investigation, research, scripting, documentation, and daily work
- Previous managed services experience
- Experience administering both Microsoft SQL Server and Oracle
- Microsoft Azure administration or cloud infrastructure experience
- CompTIA A+, Network+, Security+, Microsoft AZ-104, or AZ-305 certification
- Experience with virtualization technologies
- Experience supporting highly available enterprise applications
- PowerShell, shell scripting, Azure CLI, or similar automation experience
- Experience with infrastructure or application monitoring tools
- Knowledge of TCP/IP networking, firewalls, certificates, DNS, and related infrastructure concepts
- Experience supporting or delivering Azure implementations or migrations
- Identity and access management experience with Active Directory and Microsoft Entra ID
- Experience explaining technical concepts to non-technical customers or stakeholders
- Experience with enterprise software, ERP, CIS, or utility technology
- Previous utility industry experience
Harris healthcare Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Harris healthcare and has not been reviewed or approved by Harris healthcare.
-
Leave & Time Off Breadth — PTO and paid holidays are characterized as generous, with ample time off emphasized. This breadth of time-off options is highlighted alongside favorable impressions of vacation and sick leave.
-
Flexible Benefits — Remote-work flexibility and trust to work from home are emphasized, indicating adaptable arrangements for many roles. Flexibility is positioned as a tangible part of the overall package.
-
Healthcare Strength — Core coverage includes medical, dental, and vision, along with life and disability insurance and HSA/FSA options. Health plans are often characterized as good, contributing to a solid foundational offering.
Harris healthcare Insights
What We Do
For over 25 years, Harris Healthcare has been rising to the challenge of bringing together the most innovative and sustainable solutions for today’s ever-changing healthcare environment, in order to improve patient care and safety. Each one of our solutions brings organizational efficiencies on its own. Powerful synergies are achieved when multiple solutions are implemented together. The Harris Healthcare portfolio includes the following solutions: ♦ HARRIS Flex - an enterprise-level EHR solution that improves patient safety and clinical workflows. It includes a full complement of applications integrated in one single database, provides solid clinical decision support to your clinicians and helps standardize care while enforcing protocols and best practices at any Healthcare Organization. HARRIS Flex conveys the digital solution’s flexibility and strength. Healthcare organizations are continuously faced with new challenges and situations and require flexible EHR’s that can be rapidly adapted to their evolving clinical practice. Contrary to other EHR solutions which are inflexible and where customizations require costly support from the vendor, HARRIS Flex gives you the freedom to "flex" your EHR as you need it entirely on your own. The enhanced HARRIS Flex solution comes with new functionality including: ♦Flex Telehealth which enables virtual visits directly from within the EHR/EPR, and ♦Flex Clinical Insight which facilitates extraction and analysis of your EHR/EPR data to improve your processes and outcomes. ♦ SynergyCheck – a proactive interface monitoring solution watching over Clinical, Financial and other interfaces 24/7 to ensure data is flowing between systems
