Senior Oracle Database Administrator

Tech Mirrors; Nashville (TN); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Tech Mirrors in Nashville, Tennessee is seeking a Senior Oracle Database Administrator. This role is crucial for managing the architecture, administration, optimization, and security of Oracle database environments across cloud platforms and on-premises. Candidates should have extensive experience in Oracle database support and a strong commitment to performance and compliance.

The successful candidate will engage in database management using modern tools and strategies, aiding in the evolution of a highly available and reliable database infrastructure.

Qualifications

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

Responsibilities

• Manage, monitor, and support Oracle database environments.
• Design and manage Oracle deployments in OCI.
• Proactively monitor performance using AWR, ASH, OEM.
• Implement and manage RMAN backup strategies.
• Enforce database security standards including encryption and patching.
• Develop automation using Shell, Python, Ansible, Terraform.
• Provide 24/7 support as part of an on-call rotation.

Skills

Oracle database administration

SQL and PL/SQL

Linux Operating system

Shell scripting

Automation (Shell, Python, Ansible, Terraform)

Education

Years of hands-on enterprise Oracle database support

Tools

Oracle Cloud Infrastructure (OCI)

AWS EC2/RDS for Oracle

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

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.