Key Responsibilities
Windows & System Administration
• Install, configure, patch, and manage standalone Oracle 19c databases natively on Windows Server platforms.
• Perform OS-level database administration on Windows, including Windows Service management (net stop/start), Windows Registry configuration, and thread-level session troubleshooting using native utilities (orakill).
• Manage memory allocation (SGA and PGA) within the single-process oracle.exe Windows memory boundary to prevent pagefile swapping and ORA-04030 errors.
Core Database Operations & SE2 Optimization
• Administer databases within Standard Edition 2 (SE2) architecture, leveraging CDB/PDB multitenant models while working within SE2 hardware and CPU limits.
• Perform routine database maintenance: user management, tablespace/datafile growth forecasting, schema management, and security auditing.
• Execute Release Update (RU) patching and database upgrades on Windows environments with minimal operational downtime.
• Execute database migrations, refreshes, and Data Pump (EXPDP/IMPDP) exports/imports across Windows hosts.
Monitoring, Performance Tuning & Documentation
• Perform performance analysis, wait-event tracking, and SQL tuning in SE2 environments using Statspack, V$ performance views, and enterprise APM tools (e.g., SolarWinds DPA / SAM) rather than Enterprise AWR/ADDM packs.
• Author clear, standardized Standard Operating Procedures (SOPs) and step-by-step runbooks to allow NOC/L1 teams to handle daily backup checks and baseline health monitoring.
• Manage production incidents, blocking sessions, lock escalations, and out-of-space conditions via Jira ticket workflows.
Backup, Recovery & Disaster Recovery
• Manage database backup, restore, and point-in-time recovery strategies using RMAN.
• Integrate Oracle backup processes with enterprise media managers and third-party backup solutions (e.g., Veeam, Cohesity).
• Maintain Disaster Recovery (DR) readiness and standby databases compatible with Standard Edition architectures.