Install and configure Oracle databases and related software (e.g., Oracle RAC, Data Guard, etc.).
Monitor and optimize database performance, including tuning SQL queries, and adjusting database parameters.
Implement backup and recovery strategies using Oracle RMAN or other tools, ensuring data integrity and disaster recovery preparedness.
Configure and maintain database security, including user accounts, roles, and privileges. Ensure databases comply with security policies and standards.
Apply patches and upgrades to Oracle databases to ensure they are up-to-date and secure.
Resolve database issues quickly, including performance bottlenecks, connectivity problems, and corruption.
Manage Oracle replication and clustering technologies such as Oracle Data Guard, RAC (Real Application Clusters), and GoldenGate.
Plan and execute database migrations, including upgrades to new Oracle versions or moving data between systems.
Utilize Oracle Enterprise Manager or other tools to monitor system performance and produce reports for system health, utilization, and security.
Work with stakeholders to assess system growth and prepare for future database capacity needs.
Maintain accurate documentation for all database configurations, procedures, and policies.
Required Skills and Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related field.
Proven experience as an Oracle DBA (typically 5+ years or more).
In-depth knowledge of Oracle database architecture, including installation, administration, performance tuning, and security.
Experience with Oracle database backup and recovery tools (e.g., RMAN).
Strong knowledge of SQL, PL/SQL, and scripting languages.
Familiarity with database replication technologies like Oracle Data Guard and GoldenGate.
Experience with Oracle RAC and Oracle Exadata is a plus.
Strong troubleshooting and problem-solving skills.
Knowledge of cloud platforms (e.g., Oracle Cloud, AWS, Azure) is a plus.