David Alba Herrera Email & Phone Number

Tunja, Boyaca, Co

Bogotá, Capital District, Colombia

Oracle and MSSQL database management, ensuring high availability across development, testing, and production environments through proactive monitoring of alerts and incidents. Experienced in resource and tablespace management, query performance tuning, and resolving blocking issues to enhance database efficiency.Proficient in user administration and handling service requests via ServiceNow, managing user access and fulfilling service requirements seamlessly. Skilled in deploying ETLs in SSIS and reports in SSRS, as well as managing jobs in Oracle and MSSQL, with continuous monitoring and error resolution. Additionally, focused on query and database performance optimization, contributing to improved system stability and operational effectiveness.

Bogotá, Capital District, Colombia

Solid track record in managing Oracle Fusion Middleware products, including Oracle BAM, OSB, SOA, Web Center Content, and ODI, with focus on installation, configuration, and user administration. Skilled in fulfilling requests and resolving incidents according to ITIL standards, ensuring compliance and high service quality.Monitoring production domains in WebLogic via Oracle Cloud 13c and Oracle Enterprise Manager, maintaining continuous, uninterrupted service and above 99% of avialibility. Experienced in user management within ODI and the deployment of ETLs to production, supporting seamless operations and data integrity. Additionally, proficient in Linux administration and scripting, automating repetitive tasks to streamline workflows and minimize manual intervention.

Bogotá, Capital District, Colombia

Query development for enterprise-level databases, including Oracle, Netezza, MySQL, and MSSQL. Successfully executed data migrations and ETL processes, contributing to an estimated 30% reduction in service provisioning loss through Oracle ODI. Proficient in query optimization, with improvements yielding up to 25% gains in performance efficiency for critical queries.Data modeling and documentation, enhancing data structure clarity and integrity by aligning requirements with business needs. This holistic approach has optimized database functionality by up to 40%, streamlining workflows and supporting strategic decision-making.

Bogota, D.C., Capital District, Colombia

Developement of complex SQL/PLSQL queries across Oracle, Netezza, MySQL, and MSSQL databases. Skilled in data migration and ETL development using Oracle ODI, ensuring efficient data provisioning and minimizing service loss. Expertise includes query optimization, data modeling, and comprehensive documentation and requirements gathering.

Bogotá, Capital District, Colombia

Experience in healthcare database management for Oracle systems, focusing 60% on monitoring, incident resolution, and provisioning. Maintained uninterrupted support to ensure high availability and rapid issue resolution. Skilled in backup and recovery processes using RMAN, achieving near-zero data loss in critical systems, with tablespace adjustments and performance tuning that improved system efficiency by up to 35%. Involving query optimization and advanced performance tuning, resulting in substantial reductions in resource consumption and latency.

Postgraduate Degree, Data Base Especialist

Bachelor'S Degree, Computer Software Engineering