Performance Tuning: Utilize tools like AWR, ADDM, and SQL tuning to monitor and enhance database performance and optimize SQL queries.
High Availability and Disaster Recovery: Configure and manage Oracle Data Guard, RAC, and other high availability solutions to ensure minimal downtime.
Security Management: Ensure database security in compliance with industry standards; manage user access, roles, and privileges.
Database Monitoring: Use Oracle Enterprise Manager and other monitoring tools to proactively identify and resolve database issues.
Database Development Support: Assist developers with database design, efficient SQL coding, and data loading processes.
Automation and Scripting: Develop and maintain automation scripts for routine database maintenance tasks using Shell scripting or PL/SQL.
Documentation: Maintain accurate documentation for database configurations, processes, and changes.
Incident Management: Quickly troubleshoot and resolve complex database issues, ensuring minimal impact on production.
Qualifications
Experience: Minimum of 10 years of experience as an Oracle DBA, with expertise in managing Oracle 12c, 19c, and newer versions. Experience with SQL Server or DB2 is a plus.