Database Administration: Oversee the installation, configuration, maintenance, and upgrades of Oracle databases (latest versions) on various operating systems.
Performance Tuning: Utilize tools like AWR, ADDM, and SQL tuning to monitor and enhance database performance and optimize SQL queries.
Backup and Recovery: Implement and maintain robust backup and recovery strategies using RMAN and Oracle Data Pump to ensure data integrity and availability.
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.