Job ID: TN-65891 (98890618)
Oracle DBA with OCI, AWS, On-Prem, EC2/RDS, CDB/PDB, RAC, Data Guard, Exadata, VPN/FastConnect/Direct Connect, migration/modernization, AWR/ASH/OEM, PL/SQL, RMAN, DR, RPO/RTO, DevOps, Shell/Python/Ansible/Terraform, CI/CD, AI/LLM, Redhat Linux, ASM experience
Location: Nashville, TN (F&A STS)
Duration: 5 Months
Candidate Must Be Local
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.
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 LLMs
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.