Jaime Aguiar Email & Phone Number

Santiago Metropolitan Region, Chile

Chile

Responsible for the operational continuity of Infrastructure and Database platforms.Responsible of the Backup and Replicas Strategy.My main objective achieved and in continuous improvement was to transform the Database and Backup area into an area capable of delivering cutting-edge, high-quality, robust and collaborative services, capable of keeping pace with the digital transformation of the company. Scope: Architecture, development, design, operation of databases, backups and replicas; support and integration with applications, operating systems and databases, on-premises infrastructure and cloud infrastructure, cybersecurity and data risk, administration of technological assets of databases and storage/appliance, access control to infrastructure, incident management and issues.My main achievements:•Collaborate and raise the score in Entel Internal Satisfaction Survey, during the years 2020-2021-2022.• Implement a model that maintains the operational continuity of Entel business, with a park of more than 3,000 databases, both for Entel Chile and Entel Peru; based on several different technologies and ecosystem of complex and highly integrated applications. Being an enabler, creator and manager of the Database governance, reducing SLAs with the resolving of requirements and problems, keeping reports visible to leaders and capacity planning; distributing the knowledge in the team of collaborators that supports me in this mission. High degree of collaboration with various IT Development and Exploitation teams working under a DevOps concept, Automation in supportprocesses, and more.• Leading complex and critical projects in the Migration to Cloud infrastructure. Involved as a leader of Oracle Infrastructure and Database in the first worldwide migration of Siebel to Cloud infrastructure in OCI. In addition, I take part of multiple migrations of Entel Core and Legacy systems to clouds such as AWS, OCI• Design and implementation of the Information Architecture

Chile

Outsourcing at ENTEL

Around The World

For the last years involved on projects in multidisciplinary, international environments on four continents and multiple countries.Experience and achievements include: • Planning and deployment of Databases, design, implementation and optimization of High Availability solutions and Disaster & Recovery. • Cross-platform migration, consolidation to Oracle Database including engineering systems. • Oracle GoldenGate replication, migration and consolidation of Oracle databases, Exadata and other databases systems. • Oracle Cloud Control 12c/13c: Deployment and Integration of Oracle Cloud Control 12c/13c in Oracle Maximum Availability Architecture with Fusion Middleware platform, Oracle Database, Oracle Engineering Systems (Exadata, Exalogic, Big Data Appliance, ZDLR, ZFS). • Design and implementation of Edition-based Redefinition to minimize downtime. • Analysis, Assessments, Forecasting, debugging, resolution and Optimization of Oracle Platforms. • Evaluate data life cycle, design Housekeeping and purging solutions. • Liaising with Development and application functional teams to better support the business needs. • Involve in Projects that deals with order care systems, Billing systems, CRM, BUS ,SOA, AIA and BI. • Troubleshooting and firefight. • DBA technical leader. • Mentoring junior DBA's.

Lisbon Area, Portugal

Outsourced for several projects at Tax and Customs authority of Portuguese Government that include: • Near Zero downtime migration of Invoice Database with approximately 6 Terabytes from Sun Solaris 5.10 single instance to Oracle Exadata using Oracle Goldengate.• Near Zero downtime Migration of taxpayers unique information database from 9iR2 database on Sun Solaris 5.9 to Oracle Exadata using Oracle Goldengate. • Implementation Active-Active bidirectional architecture in Goldengate clusterware to serve the authentication system that is use by all the public finance of Portugal. • Implementation of a broadcast architecture on the taxpayers system to disseminate the information and cross-reference whit several subsystems to detect anomalies. • strategy for the migration in terms of database from the actual data center environment “heterogeneous and legacy system” to a consolidate system in IBM Z/linux 12. • Involve in a taskforce for designing a disaster recovery mission statement and implementation of a hot site for the organization. • i'm also active committed in Management. • Maintenance and performance tuning activities on Database of high criticality. • Administration PowerCenter, PowerExchange. • Analysis, debugging and resolution of system and end users reported problems. • Replication on several sites using oracle advance replication. • Implementation, maintenance and Monitoring SqlServer using T-SQL scripts and Microsoft System Center Operation Manager. • Implementation and management Oracle Veridata and Oracle Director. • Liaising with Development and application functional teams to better support the business needs.

• Principal in charge for the database that support the Portuguese finance Portal.• Principal in charge for the database of taxpayer’s heritage of Portugal.• Main responsible on various databases (electronic certificates, access control, authentication systems, compliments and complaints system suggestions, statements, history and archive).• Backup on several databases (Tax collection, Community Transit, misdemeanors, ELearning, etc..).• Implementation and administration of Oracle Application Server 10g Forms and Reports.• Creation, patching, migration, cloning and administration of Oracle database Business critical. 24x7 (9i, 10g, 11g) in Sun Solaris (Sparc and x86), Linux (RHEL 4, RHEL 5).• Tuning Application support to solve issues and technical performance.• Troubleshooting Oracle Grid Infrastructure.• Testing the viability of Oracle Golden Gate.• Testing the viability of the IBM Optim tool.• Administering Power Center.• Administering Power Exchange.• Developing Workflows and procedures for transfer’s data between DB2 and Oracle to implement the pre-filling of electronic declarations. (Resource to Power Center tool and database procedures).• Basic Administration SqlServer 2005 and SqlServer 2008.• Establishing procedures to file for electronic certificates.• Permanent contacts with the areas of development to assess the creation of structures to better support the needs of the business.• Analysis and debug issues reported by end users.

Outsourced by Glintt (please read Glintt job description)

• Main responsible for database support system of Portuguese customs• Administration environment Updatable Snapshot Replication with 370 sites.• Creating, Migrating and Upgrading Oracle database.• Administration of Oracle database (8.0.x, 8i and 9i) on Sun Solaris, HP-UX, AIX, Windows (NT/2000) and Linux environments.• Development on monitoring Oracle databases using OEM and shell scripting.• Contributed in planning and implementing projects database.• Testing for Oracle 9i Real Application Cluster in Linux.• Analyze, debug, system resolution and end-user Reported problems.• Definition and implementation of strategies "backup & recovery".• Troubleshooting and retrieval database crashed.• Installation, Administration Power Center.• Installation, Administration of Power Exchange.

Lisbon Area, Portugal

• Migration from Oracle 8i database to 9i and NT platform to Unix.• Implementation and Administration of Oracle Fail Safe• Oracle Procedural Gateway Administration.• Analyze, debug, troubleshoot system reported by the end user.• Monitoring and Administration of Oracle Database (Windows; UNIX).• Development in PL / SQL.

Master Degree In Computer Science And Computer Engineering

Software Engineering, Distributed Systems Infrastructure, Information Systems Architectures; Special emphasis on the fundamental.

Degree Informatics Engineering, Computer Science

Algorithms and programming, design and planning of information systems; Advanced Systems architecture

Teti - Technical Expert In Information Technology, Computer And Information Sciences

Course with partnership of Oracle Portugal and APO. Main focus on oracle technology (Database Administration, PL/Sql, Forms and Reports.