Job Description
Roles & Responsibilities
Technical Skills Required:
Core: Oracle EBS 12.2, Oracle 19c, WebLogic, ADOP, Rapid Clone.
Databases: MySQL, MS-SQL Server.
OS/Infrastructure: Solaris, Oracle Linux, Shell Scripting, SAN/NAS Storage.
Key Responsibilities:
1. Oracle EBS & Middleware Lifecycle Management
Application Administration: Manage the full lifecycle of Oracle EBS 12.2, including complex upgrades to Oracle 19c and cross-platform migrations.
Online Patching: Expertly execute the ADOP (Online Patching) cycle to ensure minimal downtime and system stability.
WebLogic & Fusion Middleware: Configure, tune, and troubleshoot WebLogic Admin and Managed Servers (e.g., Forms, OACORE) tailored for the EBS 12.2 stack.
DMS Governance: Maintain the integrity of the Oracle Document Management System, overseeing user permissions, security protocols, and storage workflows.
2. Multi-Platform Database Administration
Database Management: Provide expert-level support for Oracle 19c (utilizing Multitenant architecture), MySQL, and MS-SQL Server.
High Availability: Design and manage high-availability solutions, including Oracle Data Guard and SQL Server Always On clusters.
Infrastructure Synergy: Administer Solaris and Linux environments; collaborate with storage teams to optimize SAN/NAS capacity, I/O performance, and OS-level configurations.
Automation: Architect advanced Shell, WLST, and Python scripts to automate routine maintenance and system monitoring.
3. Data Protection, Backup & Recovery
RMAN Mastery: Design and implement comprehensive backup strategies using Oracle RMAN, including incremental backups and advanced block media recovery.
Disaster Recovery (DR): Lead DR planning and execution for EBS 12.2 to guarantee zero data loss and meet strict Recovery Time Objectives (RTO).
Environment Refreshes: Streamline the cloning process (Production to non-prod) using Rapid Clone and RMAN to support agile development cycles.
Cross-Platform Recovery: Standardize backup/restore procedures for MySQL and MS-SQL Server, including Point-in-Time Recovery (PITR) to safeguard against data corruption.
Compliance & Validation: Conduct quarterly restoration drills to validate backup integrity and ensure adherence to corporate data retention policies.
4. Testing & Optimization
Validation: Execute rigorous regression and functional testing for all patches, upgrades, and configuration changes.
Performance Engineering: Proactively tune SQL queries, database parameters, and OS kernels to maintain peak application performance.