Senior Oracle Database Administrator

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

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

Other Information

• This is a Contract assignment with our Client: State Government
• Full Time: 37.5 Hours Per Week (7.5 hour days)
• Duration: 5.5 Months with possible extensions.
• Work Location: Hybrid with some onsite time required in Nashville,