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.

75K - 85K

53K - 61K

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.

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

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

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

• 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…