Oracle DBA

Must Have Technical/Functional Skills

Database Administration

• Install configure and maintain Oracle databases (11g / 12c / 19c) on Linux/Unix platforms
• Perform database creation configuration cloning and decommissioning
• Manage tablespaces datafiles redo logs control files and storage growth
• Perform routine maintenance activities such as space management and housekeeping

Backup & Recovery

• Design and implement backup and recovery strategies using RMAN
• Perform database restores and recoveries (complete and pointintime recovery)
• Test backup and recovery procedures regularly to ensure DR readiness
• Handle archive log management and retention policies

Performance Monitoring & Tuning

• Monitor database performance using AWR ADDM ASH OEM
• Identify and resolve performance issues related to CPU memory I/O SQL
• Tune SQL queries indexing strategies and optimizer statistics
• Manage Oracle initialization parameters for optimal performance

High Availability & Disaster Recovery

• Implement and support Oracle Data Guard (Physical / Logical Standby)
• Manage Oracle RAC environments for high availability
• Perform planned and unplanned failover and switchover operations
• Support DR drills and business continuity testing

Security & Compliance

• Manage database users roles profiles and privileges
• Ensure database security standards and compliance requirements are met
• Implement auditing password policies and access controls
• Apply security patches and CPU updates

Upgrades Patch & Migration

• Perform Oracle patching PSU/CPU upgrades and version upgrades
• Support database migrations across platforms or versions
• Coordinate with application and infrastructure teams during releases
• Follow change management and release processes

Production Support

• Provide 24x7 oncall support for production databases
• Troubleshoot database incidents and perform root cause analysis
• Work with vendors and internal teams to resolve complex issues
• Maintain SOPs runbooks and operational documentation

Roles & Responsibilities

• Install configure and administer Oracle databases (11g 12c 19c) in development test UAT and production environments
• Perform daytoday database administration including creation configuration cloning and deletion
• Monitor database health and availability; proactively identify and resolve issues
• Execute backup and recovery operations using RMAN including restore and pointintime recovery
• Manage database storage: tablespaces datafiles redo logs archive logs and control files
• Ensure optimal database performance through SQL tuning index management statistics gathering and parameter tuning
• Monitor and tune database resources using AWR ADDM ASH OEM and performance views
• Implement and support High Availability and Disaster Recovery solutions using Oracle RAC and Data Guard
• Perform Data Guard switchover and failover operations during planned and unplanned events
• Apply Oracle patches CPUs PSUs and perform version and platform upgrades
• Support database migrations across environments and Oracle versions
• Manage database security including users roles privileges profiles and auditing
• Ensure compliance with security standards operational policies and regulatory requirements
• Troubleshoot production incidents perform root cause analysis and implement preventive measures
• Coordinate with application system and network teams during deployments and outages
• Automate routine DBA tasks using shell scripting where applicable
• Maintain DBA documentation SOPs and operational runbooks
• Participate in 24x7 support and oncall rotations for critical production systems.