OCI Database Engineer

Job Purpose
Responsible for managing, optimizing, securing, and maintaining Oracle database systems in
Oracle Cloud Infrastructure (OCI). This role includes database provisioning, migrations, backup
and recovery, performance tuning, high availability, and collaboration with development and
infrastructure teams to ensure database reliability and scalability.
Key Tasks and Duties
• Design, deploy, and operate Oracle database services in OCI (Autonomous Database, Exadata
Cloud, Oracle Database Cloud Service, DB Systems).
• Plan and execute database migrations from on-premise to OCI using Data Pump, RMAN,
GoldenGate, Data Guard, and other migration tools.
• Perform capacity planning, database sizing, SQL and instance performance tuning, and query
optimization.
• Implement and manage backup, restore, and disaster recovery strategies, including validation
of backup and DR procedures.
• Apply database security best practices including encryption (TDE), access control, auditing,
and vulnerability remediation.
• Automate provisioning and configuration using Terraform, OCI Resource Manager, Ansible,
and scripting (PL/SQL, Python, Bash).
• Monitor database performance using OCI Monitoring, AWR/ASH Reports, and Enterprise
Manager; proactively resolve performance issues.
• Perform patching and upgrades; plan maintenance windows and manage lifecycle of OCI
database instances.