Description

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 independently and in a team environment, and take ownership of projects from start to finish
• Able to prioritize tasks and make adjustments as needed

Required Background & Skills

• Multiple years of hands-on enterprise Oracle database support
• Strong SQL and PL/SQL background
• Good command of Linux operating system (Red Hat or Oracle) and Shell scripting
• Deep understanding of Oracle database concepts including:
  • Process, memory, and storage management
  • ASM management
  • Disaster recovery (DR)
  • Cloud infrastructure

Key Skills

Education

Bachelor's degree