Oracle Database Administrator

Role: Oracle Database Administrator 3

Location:   Hybrid ( 312 Rosa L. Parks Avenue N., 20th floor   Nashville,  Tennessee    37243);

Duration: Long term contract.

Position Summary

• Serve as a Senior Oracle Database Administrator across hybrid environments (OCI, AWS, On-Prem).
• Responsible for architecture, administration, optimization, and security of enterprise databases.
• Ensure high availability, performance, and compliance for mission-critical applications.
• Collaborate with application, infrastructure, security, and data governance teams.
• Drive modernization, automation, and operational excellence.

Key Responsibilities

• Enterprise Database Administration
• Manage and support Oracle databases (11g to 23c) across OCI, AWS (EC2/RDS), and on-prem.
• Administer CDB/PDB (multi-tenant), RAC, and Data Guard environments.
• Ensure database uptime and performance meet enterprise SLAs.

2. Cloud & Hybrid Architecture

• Design and manage Oracle deployments in OCI (Autonomous DB, Exadata, DB Systems).
• Support Oracle workloads in AWS (EC2 & RDS Oracle).
• Implement hybrid connectivity (VPN, FastConnect, Direct Connect).
• Lead cloud migration and modernization initiatives.

3. Performance & Capacity Management

• Monitor performance using AWR, ASH, OEM, and cloud tools.
• Tune SQL, PL/SQL, and database configurations.
• Perform capacity planning and storage forecasting.

4. Backup, Recovery & High Availability

• Implement and manage RMAN backup strategies.
• Maintain disaster recovery using Data Guard / Active Data Guard.
• Ensure and validate RPO/RTO targets.

5. Security & Compliance

• Enforce security standards (TDE encryption, patching, access controls).
• Support audits and regulatory compliance.
• Implement least-privilege access and monitoring.

6. Automation & DevOps Enablement

• Develop automation using Shell, Python, Ansible, Terraform, OCI Resource Manager.
• Integrate database operations into CI/CD pipelines.
• Standardize provisioning, patching, and configurations.
• Work with AI-powered database features and LLM tools.

7. Data Governance & Quality

• Support data cataloging, lineage, and quality initiatives.
• Align databases with governance and metadata standards.
• Collaborate with data engineering and analytics teams.

8. Operational Excellence

• Provide 24/7 on-call support (rotation).
• Troubleshoot issues and perform root cause analysis.
• Maintain documentation, SOPs, and runbooks.
• Lead projects and manage tasks independently or in teams.
• Prioritize and adapt to changing workloads.

Required Background & Skills

• Extensive experience in enterprise Oracle database administration.
• Strong expertise in SQL and PL/SQL.
• Hands-on experience with Linux (RedHat/Oracle) and Shell scripting.
• Deep knowledge of:
• Oracle architecture (process, memory, storage)
• ASM, Disaster Recovery, Cloud infrastructure