Oracle DBA

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 point-in-time 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 on-call 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 day-to-day 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 point-in-time 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 on-call rotations for critical production systems.

Oracle DBA (Database Administrator), Database Administration, Oracle Database, Unix Operating Systems, Linux Operating System, Oracle 11i, Cloning, Housekeeping/Cleaning, Data Recovery, RMAN