Manage the MySQL and Oracle databases of the Plan Jarillón de Cali project. Make backup copies and monitoring of the database. Generate flat files from the database according to various requests. Until Dec 31, 2019, Comply with the guidelines emanating from decree 0239 of 2004, which creates the Operational Technology Committee. Manage, monitor and support the technological infrastructure of the Project Plan Jarillón de Cali.
Major achievementCreate the first version of the Management and Consultation System of the PJC, which gave access to the information in the MySQL database to online users. Migrate Jarillon Plan database from MySQL database engine to Oracle, with data model change.
Until Jan 31, 2017, manage the SQL Server databases of the Municipal Companies of Cali, EMCALI. As of Feb 1, 2017, infrastructure support for various clients.
Major achievementImprove daily data collection for the generation of SQL Server-EMCALI monthly reports. Adjustment of the monthly reports of SQL Server-EMCALI.
Monitor the performance of the databases, guaranteeing their stability and normal operation. Perform periodic maintenance of the databases. Cloning of development and test databases. Provide support to the DBA in various database activities. Make backups and restorations. Generate statistical reports from databases. Install and configure databases.
Major achievementAutomation of database maintenance. In the last 2 years, managing the database and infrastructure of the Human Resources platform migration project, creating documentation that became the standard for data migration processes in the company.