Oracle DBA (Hybrid - Must be local to TN)

Client: State of TN/TN F&A STS Job ID: 65891 Job Title: Database Administrator 3 Location: 312 Rosa L. Parks Avenue N., 20th floor Nashville, Tennessee 37243 Estimated Duration: 07/13/2026 - 12/31/2026 Hybrid 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. #J-18808-Ljbffr