Senior Oracle Database Administrator

Role overview

Required experience and skills

• 10+ years of Oracle Database Administration experience in large enterprise production environments.
• Strong hands-on experience with Oracle RAC, Data Guard Broker, Flashback, RMAN, ASM, and Oracle Enterprise Manager.
• Advanced performance tuning using AWR, ASH, ADDM, execution plans, and database wait-event analysis.
• Experience managing high-volume OLTP and large Data Warehouse databases.
• Strong understanding of Oracle architecture, internals, high availability, and recovery concepts.
• Hands-on expertise in partitioning, indexing strategies, table maintenance, statistics, and space management.
• Experience in Oracle patching, automation, and technical root cause analysis.
• Ability to take end-to-end ownership and resolve issues independently with minimal supervision.

Key responsibilities

• Administer and support Oracle databases, Oracle RAC, ASM, RMAN, and Data Guard using Broker.
• Monitor, diagnose, and tune database, SQL, and system performance in high-volume OLTP and Data Warehouse environments.
• Troubleshoot complex production issues, restore service, identify root causes, and implement preventive actions.
• Manage Flashback technologies, partitioning, indexes, tables, statistics, and database maintenance activities.
• Perform database patching, upgrades, migrations, backups, recovery, and disaster recovery validation.
• Automate recurring DBA activities using Shell, SQL, PL/SQL, or relevant automation tools.
• Review database architecture and recommend improvements to availability, scalability, resilience, and performance.
• Collaborate with application, infrastructure, and engineering teams during incidents, changes, and planned maintenance.