Role Overview:This role is for an experienced Oracle Database Administrator responsible for the full lifecycle management of Oracle databases across various environments. The individual will ensure high availability, performance, and security of critical database systems.
Key Responsibilities:- Install, configure, administer, patch, and upgrade Oracle databases across development, QA, and production environments.
- Perform database monitoring, performance tuning, capacity planning, and troubleshooting.
- Manage backup and recovery using RMAN, including periodic recovery validation and DR readiness.
- Support Oracle RAC, ASM, and Data Guard environments and troubleshoot availability/performance issues.
- Perform database refreshes, cloning, migrations, patching, and version upgrades.
- Monitor database health, tablespaces, storage utilization, alert logs, sessions, locks, and batch/database jobs.
- Troubleshoot complex database incidents and perform Root Cause Analysis (RCA) for critical production issues.
- Optimize SQL performance using execution plans, AWR/ASH reports, SQL tuning techniques, and database statistics.
- Manage Oracle users, roles, privileges, profiles, and database security requirements.
- Support High Availability and Disaster Recovery activities, including DR drills and failover/failback testing.
- Coordinate with application, infrastructure, Linux/Unix, storage, network, security, and middleware teams.
- Participate in production changes, maintenance activities, releases, and weekend/off-hours support when required.
- Handle incidents, service requests, problems, and changes in accordance with ITIL processes and defined SLAs.
- Maintain database documentation, operational procedures, SOPs, and troubleshooting knowledge articles.
Required Skills:- Oracle DBA expertise
- RMAN for backup and recovery
- Oracle RAC, ASM, and Data Guard
- SQL performance tuning (execution plans, AWR/ASH reports)
- Database security management
- High Availability and Disaster Recovery
- ITIL processes
Qualifications:- 10+ years of experience in Oracle Database Administration.
