David Alba Herrera

David Alba Herrera Email and Phone Number

SQL Developer and Oracle Analyst @ Smart Process Automation
Tunja, Boyaca, CO
David Alba Herrera's Location
Tunja, Boyacá, Colombia, Colombia
About David Alba Herrera

Database Administrator and Middleware Specialist with extensive experience managing Oracle and MSSQL databases, ensuring high availability through RMAN, GoldenGate, and Data Guard in Oracle, and deploying ETLs in SSIS and reports in SSRS in MSSQL. Skilled in user administration and job scheduling to maintain consistent operations.Proficient in SQL and PL/SQL for developing complex queries and task automation. Experienced in data migration across databases (Oracle, Netezza, MySQL, PostgreSQL) and data integration within DWH environments using Oracle Data Integrator (ODI), applying agile methodologies like SCRUM.Additionally, specialized in administration and deployment of Oracle Fusion Middleware in Weblogic Domains (Oracle BAM, SOA, OSB, WebCenter Content, and ODI), providing continuous support to ensure seamless functionality in enterprise middleware solutions.

David Alba Herrera's Current Company Details
Smart Process Automation

Smart Process Automation

View
SQL Developer and Oracle Analyst
Tunja, Boyaca, CO
David Alba Herrera Work Experience Details
  • Smart Process Automation
    Sql Developer And Oracle Analyst
    Smart Process Automation
    Tunja, Boyaca, Co
  • Asesoftware
    Database Administrator
    Asesoftware Sep 2024 - Present
    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.
    View
  • Iteractiva Group
    Middleware Administrator
    Iteractiva Group Jul 2022 - Sep 2024
    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.
    View
  • Iteractiva Group
    Sql/Etl Developer
    Iteractiva Group Mar 2021 - Jul 2022
    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.
    View
  • Dimensions Sas
    Sql/Etl Developer
    Dimensions Sas Jun 2020 - Feb 2021
    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.
    View
  • Dimensions Sas
    Oracle Dba
    Dimensions Sas Jun 2019 - Feb 2021
    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.
    View

David Alba Herrera Education Details

Frequently Asked Questions about David Alba Herrera

What company does David Alba Herrera work for?

David Alba Herrera works for Smart Process Automation

What is David Alba Herrera's role at the current company?

David Alba Herrera's current role is SQL Developer and Oracle Analyst.

What schools did David Alba Herrera attend?

David Alba Herrera attended Universidad Pedagógica Y Tecnológica De Colombia, Universidad Pedagógica Y Tecnológica De Colombia.

Not the David Alba Herrera you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.