JC Technology & Solutions LLC
12/2022 - Present
- Optimized database performance, reducing query response time by 30% through advanced tuning techniques.
- Implemented Azure Data Warehouse solutions, improving data processing efficiency by 25%.
- Automated backup processes using RMAN, reducing manual intervention by 40%.
- Led the migration of critical databases to Oracle Cloud, ensuring zero downtime and data integrity.
- Employ basic monitoring procedures and manage performance Plan effective backup and recovery procedures
- Configure the database for recoverability
- Use Recovery Manager (RMAN) to create backups and perform recovery operations
- Use the Data Recovery Advisor to diagnose and repair failures
- Use Oracle Flashback Technologies to recover from human error
- Perform an encrypted database backup and restore Perform tablespace point-in-time recovery Manage PDB snapshots
- Encrypt data in PDBs and isolate PDB keystore
- Monitor performance in CDBs and PDBs
- Protect data with Database Vault policies in CDB and PDBs Manage a CDB fleet
- Manage resource allocation between PDBs and within a PDB
- Use Data Pump operations from a non-CDB or CDB into a PDB