JHON CAMILO DE LA CUADRA

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

07/2019 - 02/2020

Reduced incident resolution time by 20% through proactive monitoring and automation of backup processes.

Managed database recovery operations using RMAN, ensuring 99.9% uptime for critical systems.

Supervised and resolved incidents for clients such as Accor Colombia and Chile.

· Move data between databases and files

· 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

07/2018 - 02/2019

•       Automatic procedures for the copies of the databases
•       Performed routine maintenance, upgrades, and patches for Oracle and SQL Server databases.
•        Perform the maintenance of the database.
•        Monitor and manage the security of databases.
•        Perform backup tests, evaluation,
•        recovery, perform tasks in the emergency discotheques of the operating system,
•        backup of the servers.
•        Perform scheduled tasks for cleaning open sessions in databases.
•        Installation of new software components requirements for the operation of the database; control of problems or situations related to the operation of the database engine.
•        The management of changes in the database engine, according to the needs, needs and good practices of Oracle.
•        Document and maintain a periodic record of hardware and software updates and operations.
•        Assign the profiles of application users and security process.
•        Pay permanent attention to the problems presented to the user.
•        Perform the sizing of the objects in the database.
•        Oracle: Backup and Recovery RMAN,
•        Configuration Alerts (Database -Grid Control), Linux

04/2011 - 02/2018

Assisted application teams with SQL tuning, improving system performance by 25%.

Managed database security, backup, and recovery using RMAN in a Linux environment.

Led network technology projects using Cisco systems, improving network efficiency by 15%.

·       Developed and maintain Oracle 12c database

·       Created physical database structures for small projects based on physical design for development, test, and production environments.

·       Performs routine maintenance, including upgrades and patches. Resolves issues via service tickets. Performs daily data backup and recovery as needed. Generates scheduled and ad hoc reports.

·       Assisted application teams with tuning of SQL statements

·       Performed security management, backup and recovery using RMAN, database installed/upgraded, and shell scripting in a Linux environment

·       Management methods for the SGA, and for the instance PGA memory, both manually and automatically.

·       Experience in memory management methods for the SGA, and for the instance PGA memory, both manually and automatically setting, Emphasis of the oracle DBA architecture

8/2023 - 12/2024

• Specialized in Cloud Computing, Database Optimization, and Cybersecurity.

• Focused on IT Strategy, Agile Methodologies, and Digital Transformation.

02/2009 - 03/2015