Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this (Remote) Technical Consultant – Oracle DBA role.

Rezi rewrites your resume against Harris Computer's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the (Remote) Technical Consultant – Oracle DBA posting at Harris Computer — free, in seconds.

About the Role

Cayenta is seeking a Technical Consultant with strong Oracle Database Administration experience to join their Managed Services team. This role focuses on administering, maintaining, troubleshooting, and optimizing Oracle 19c database environments, ensuring high availability, stability, performance, and recoverability for business-critical customer environments. The position also involves broader infrastructure support, technical troubleshooting, customer communication, and collaboration with internal teams. The ideal candidate takes ownership of technical challenges, investigates issues thoroughly, and is comfortable working in complex production environments.

Responsibilities

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, troubleshooting replication, and supporting switchover/failover.
Install, configure, patch, and maintain Oracle Grid Infrastructure, Clusterware, and Automatic Storage Management (ASM).
Perform database and Grid Infrastructure patching, upgrades, and scheduled maintenance.
Monitor database availability, capacity, storage, performance, and system health.
Support backup and recovery procedures using Oracle Recovery Manager (RMAN).
Participate in disaster recovery planning, validation, and testing.
Investigate and resolve database performance issues, including slow SQL queries, locking, blocking, memory utilization, and resource contention.
Analyze AWR, ADDM reports, ASH data, execution plans, and 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.
Conduct root-cause analysis for production incidents and recommend corrective and preventive actions.
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.
Support multiple customer environments in a managed services model.
Investigate production incidents, assess operational risks, and implement changes through 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.

Requirements

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.
Takes responsibility for issues and follows them through to resolution.
Investigates beyond the obvious symptoms to understand the underlying problem.
Assesses production risks before implementing changes.
Uses diagnostic tools, logs, documentation, testing, and responsible AI-assisted research to resolve unfamiliar problems.
Works effectively with colleagues and communicates clearly with customers.
Documents lessons learned and identifies opportunities to improve system reliability, monitoring, and operational processes.
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.

Skills

Oracle Database Administration
Oracle 19c
Oracle Real Application Clusters (RAC)
Oracle Grid Infrastructure
Oracle Data Guard
Oracle Recovery Manager (RMAN)
Linux Administration
Red Hat Enterprise Linux (RHEL)
Oracle Linux
Shell Scripting
Performance Tuning
SQL Optimization
AWR
ADDM
ASH
Troubleshooting
Root Cause Analysis
Backup and Recovery
Disaster Recovery
Microsoft SQL Server administration
Cloud administration (Azure)
Windows Server administration
PowerShell
Azure CLI
Networking fundamentals
Apache Tomcat
Microsoft Entra ID
Active Directory
Monitoring tools
Jira
TeamSupport

Location

Canada
US

Work Type

Remote

Experience Level

Minimum 3 years of hands-on experience

Salary/Compensations

75K - 85K
53K - 61K

Benefits

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

About the Company

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.
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.