Er Nasir

📁 Portfolio / Project Highlights

Production RAC Environment Setup: Configured and managed 2-node Oracle RAC (19c) with ASM and SCAN listeners to ensure high availability and load balancing for critical applications.

Active Data Guard Implementation: Successfully implemented Oracle Active Data Guard for real-time disaster recovery and failover capability, ensuring near-zero data loss.

Database Upgrade Project: Upgraded databases from 12c to 19c in a live production environment with minimal downtime, using DBUA and manual upgrade methods.

Performance Tuning: Conducted AWR/ASH analysis to resolve high-load issues, optimize SQL queries, and improve overall database performance by 30%.

Backup and Recovery Strategy: Designed and managed RMAN backup policies (full/incremental), including crosscheck, validate, and disaster recovery drills.

Database Security & Patching: Applied PSU patches and configured TDE for securing sensitive data, along with regular auditing.