Oracle DBA

Required Skills & Experience

Core Oracle DBA Skills (10 Years)

• 10 years of hands-on experience in Oracle Database Administration.
• Expertise in Oracle Database versions 11g, 12c, 19c, and higher.
• Strong experience in database installation, configuration, upgrades, migration, patching, and maintenance.
• Hands-on experience with Oracle RAC, ASM, Data Guard, and RMAN.
• Expertise in performance tuning, SQL tuning, and query optimization.
• Experience with backup, recovery, disaster recovery, and high-availability solutions.
• Knowledge of Oracle database security, user management, auditing, and compliance requirements.

Oracle Exadata Administration (5-6 Years)

• 5-6 years of hands-on experience administering Oracle Exadata environments.
• Experience managing Exadata storage cells, compute nodes, and InfiniBand networks.
• Expertise in Exadata performance tuning and optimization.
• Experience with Exadata patching, upgrades, and health monitoring.
• Strong understanding of Smart Scan, Storage Indexes, Hybrid Columnar Compression, and Exadata-specific features.
• 5-6 years of experience implementing and supporting Oracle GoldenGate.
• Experience configuring real-time database replication and synchronization.
• Expertise in GoldenGate installation, upgrades, troubleshooting, and performance tuning.
• Experience in heterogeneous and homogeneous database replication environments.
• Ability to monitor and resolve replication latency and data consistency issues.

Responsibilities

• Manage and administer Oracle database environments across production, DR, and non-production systems.
• Perform database installation, upgrades, patching, migrations, and cloning activities.
• Monitor database performance and proactively resolve issues.
• Maintain Oracle Exadata infrastructure and optimize system performance.
• Configure and support Oracle GoldenGate replication environments.
• Manage Oracle Enterprise Manager for monitoring and alerting.
• Implement backup, recovery, and disaster recovery strategies.
• Ensure database security, compliance, and data integrity.
• Develop automation scripts for routine DBA activities.
• Collaborate with application, infrastructure, and support teams to resolve production issues.
• Participate in 24x7 on-call support and critical incident management.