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