Oracle DBA (Hybrid - Must be local to TN)

Description

Position Summary

• As a Senior Oracle Database Administrator, you will be responsible for the architecture, administration, optimization, and security of enterprise Oracle database environments across a hybrid landscape including Oracle Cloud Infrastructure (OCI), Oracle workloads hosted in AWS, and traditional on-premises systems. This role is critical to ensuring high availability, performance, and compliance of shared database platforms supporting mission-critical applications.
• You will serve as a strategic partner to application teams, infrastructure, security, and data governance functions, driving modernization, automation, and operational excellence.

Schedule

• Days - Monday  Yes Tuesday  Yes Wednesday  Yes Thursday  Yes Friday  Yes Saturday  No Sunday  No
• Hours/Day - 7.5
• Time Zone - CST
• Shifts - Shift 1
  • Start Time - 8:00 AM
  • End Time - 4:30 PM
  • Active - Yes

Key Responsibilities

Enterprise Database Administration

• Manage, monitor, and support Oracle database environments (11g through 23c) across OCI, AWS (EC2/RDS for Oracle), and on-prem platforms.
• Administer multi-tenant architectures (CDB/PDB), RAC, and Data Guard configurations.
• Ensure database uptime, availability, and performance meet enterprise SLAs.

Cloud & Hybrid Architecture

• Design and manage Oracle deployments in OCI (Autonomous DB, Exadata Cloud Service, DB Systems).
• Support Oracle databases running in AWS (EC2-hosted Oracle, RDS Oracle where applicable).
• Implement hybrid connectivity strategies (VPN, FastConnect, Direct Connect).
• Lead cloud migration and modernization initiatives (lift-and-shift, re-platforming).

Performance & Capacity Management

• Proactively monitor performance using AWR, ASH, OEM, and cloud-native tools.
• Tune SQL, PL/SQL, and database configurations for optimal performance.
• Forecast capacity and storage growth across environments.

Backup, Recovery & High Availability

• Implement and manage RMAN backup strategies across hybrid environments.
• Maintain and test disaster recovery solutions (Data Guard, Active Data Guard).
• Ensure RPO/RTO targets are met and validated regularly.

Security & Compliance

• Enforce database security standards including encryption (TDE), patching, and access controls.
• Partner with security and compliance teams to support audits and regulatory requirements.
• Implement least-privilege access and database activity monitoring.

Automation & DevOps Enablement

• Develop automation using Shell, Python, Ansible, Terraform, or OCI Resource Manager.
• Integrate database operations into CI/CD pipelines.
• Standardize provisioning, patching, and configuration management.
• AI Tool Integration: Proficiency in managing AI-powered database features and other LLM's

Data Governance & Quality Enablement

• Support enterprise data initiatives including data cataloging, lineage, and quality controls.
• Ensure database environments align with governance standards and metadata management practices.
• Collaborate with data engineering and analytics teams to optimize data accessibility.

Operational Excellence

• Provide 24/7 support as part of an on-call rotation.
• Troubleshoot complex incidents and perform root cause analysis.
• Maintain documentation, runbooks, and SOPs for database operations.
• Proven ability to lead projects, work both independently and in a team environment, take ownership of projects from the beginning to the finish line.
• Able to prioritize tasks and make adjustment as needed

Background

• Multiple years of hands-on enterprise Oracle database support
• Strong SQL and PL/SQL background.
• Good command of Linux Operating system (Redhat or Oracle) and Shell scripting
• Deep understanding of ORACLE database concepts, including process, memory, storage, ASM management, DR and Cloud infrastructure.

“Cleo Consulting is an equal opportunity employer (Minorities/Women/Veterans/Disabled)”