Role Summary
As an L1 Oracle Database Engineer, you'll execute standardized operations and first-line troubleshooting across Oracle estates—Exadata platforms with Oracle GoldenGate replication.
You'll follow runbooks, keep environments healthy, escalate effectively, and continually improve our knowledge base.
What You'll Do Operations & Monitoring Run daily health checks for Oracle (12c/19c+) on Exadata (cellsrv/ASM/storage), validate backups, and review alerts.
Monitor GoldenGate extract/replicat processes, investigate lags, and perform basic restarts under guidance.
Track performance baselines (AWR/ASH at a basic level), identify anomalies, and raise tickets as needed.
Backups, Patching & Changes Execute RMAN backup/restore tasks per runbooks; verify backup success and retention.
Apply standard patches and PSU/one-off updates in maintenance windows under change control.
Perform standard changes (user/role creation, quota updates, grants) with proper documentation.
Incident Response & Escalation Triage alarms, collect diagnostics (AWR, alert logs, trace files), and restore service using SOPs. Escalate to L2/L3 with clear context, timelines, and impact summaries; participate in post-incident reviews.
Security & Compliance Enforce least-privilege access, rotate credentials per policy, and follow data handling standards.
Maintain accurate inventory and CMDB attributes for DB/host objects.
Documentation & Collaboration Update runbooks, KEDB articles, and topology diagrams (DB/Exadata/GoldenGate).
Collaborate with app, infra, and network teams; provide crisp customer-facing updates when required.
Must-Have Qualifications 1 year hands-on Oracle DBA experience (12c/19c+): user/admin tasks, schema objects, roles/privileges.
Basic Exadata understanding (ASM, storage cells, smart scan concepts) and Linux administration.
Fundamentals of Oracle GoldenGate (process roles, trail files, simple start/stop, lag checks).
RMAN basics, Oracle Enterprise Manager/Cloud Control exposure, and SQL*Plus familiarity.
Clear written/verbal communication; comfort with shift work and rigorous change/incident processes.