Perform development and monitoring of complex RAFM controls and trigger alarms to resolve and minimize revenue risk. Among my responsibilities is to analyze data related to telecommunications and billing that passes through the Extract, Transform and Load (ETL) mechanism, using different programming languages for CDR decoding, tools such as python, shellscript, PLSQL, generating streams load data and validations in the RAFM system
Major achievementKnowledge of the RAID tool, in the creation of information load flows (ETL) for subsequent validation and use of this in research, analysis and reports. Implementation of developments in Python for massive data analysis.
Installation, configuration and administration of Oracle, DB2, all engine databases in different versions. Manage multiple databases to my office on different engines, operating systems and versions. Keep the databases in optimal conditions, thus minimizing the unavailability of the operation. Steps to production, pre-production, testing and development. Development of scripts (Shell Scripting) that allow the automation of various processes.
Major achievementDevelopment of scripts (Shell) and procedures in PLSQL for optimal management of historical information. Data optimization and synchronization. Timely operation support. Installation of the Oracle cloud. Automation of various database monitoring processes through the Shell.
In charge of the DBAS group in the infrastructure area, coordinating the activities of each of the members of the group, as well as the service providers in their different disciplines in the Database area. Preparation and tuning of servers for the installation and subsequent configuration of high availability systems, installation and configuration of Oracle Database, Real Application Clusters, DataGuard, Enterprise Clound Manager, Automatic Storage Manager (ASM)
Major achievementMigration of obsolete databases and storage systems to new versions and ASM, improved management platforms such as PeopleSoft, InfoSphere, performance improvements in multiple databases that reduce response times in various processes.