Description:
We are hiring an experienced Oracle Database Administrator for a remote support role as per the below JD.
Role: Oracle Database Administrator
Experience: 8 to 12 years
Time Zone : UAE
Location: Remote / WFH
Key Responsibilities:
- Monitor and maintain Oracle EBS applications and databases in production environments.
- Perform proactive health checks and day-to-day maintenance of EBS application servers and database servers.
- Monitor application nodes, services, and concurrent manager statuses; troubleshoot failures and long-running jobs.
- Apply critical patch updates and patches across UAT, DEV, and PROD instances.
- Clone Oracle Applications from PROD to UAT and DEV instances using Rapid Clone.
- Manage code migrations between environments (UAT/DEV to PROD).
- Prepare RMAN backup scripts, perform recoveries, and monitor daily backups.
- Import/export database dump files and create on-demand tables, users, and roles.
- Upgrade Oracle EBS databases and troubleshoot middleware and connectivity issues.
- Support development teams and create/monitor scheduled jobs and alerts in SQL Server.
- Implement security measures, including database security hardening and application security hardening.
- Monitor disaster recovery (DR) sites and conduct quarterly failover testing.
Add-On Responsibilities with OCI:
- Schedule automatic backups for critical components like boot volumes, databases, and applications.
- Create and manage volume groups for cloning and consistent data replication.
- Set up and manage Site-to-Site VPNs, load balancers, and virtual machines (VMs) in OCI.
- Implement security best practices in the existing network setup.
- Clone volume groups and manage compute instances for seamless deployment.
Desired Skills:
- Strong expertise in Oracle EBS and Database administration.
- Proficiency in Oracle Cloud Infrastructure (OCI) operations.
- Experience with RMAN backups, database recovery, and high-availability setups.
- Solid understanding of middleware troubleshooting, security hardening, and DR failover scenarios.
- Hands-on experience with Site-to-Site VPN, load balancers, and VM management in OCI.