| Roles and Responsibilities |
-
Database Installation & Configuration:
Install, configure, and upgrade Oracle databases (version 11g, 12c, 18c, 19c, etc.) and related components. Set up and configure Oracle Real Application Clusters (RAC) and Oracle Data Guard for high availability and disaster recovery solutions.
-
Database Management & Monitoring:
Perform regular database maintenance including backup, recovery, patching, and upgrades. Monitor database performance, troubleshoot and resolve issues related to slow performance, deadlocks, and resource usage. Ensure optimal database health and performance through regular optimization, indexing, and query tuning. Implement and maintain database security policies, user roles, and permissions.
-
Backup & Recovery:
Implement and maintain a robust backup strategy using RMAN (Recovery Manager) and Data Guard. Perform point-in-time recovery and data restoration, ensuring business continuity.
-
Capacity Planning & Performance Tuning:
Analyze, plan, and optimize database resources (CPU, memory, disk space) to meet application requirements. Conduct database performance tuning using Oracle tools such as AWR, ADDM, and ASH. Implement and manage partitioning, clustering, and indexing strategies for large databases.
-
Database Migration & Upgrades:
Lead the migration and upgrade of Oracle databases across different environments (e.g., on-premise to cloud, or lower version to higher version). Ensure data integrity and minimize downtime during migrations.
|
