Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Senior Database Architect
MarsSenior Database Architect
Jun. 2021 - Feb. 2023Slough, Inglaterra, Reino UnidoWorking as an outsourced (K2 Partnering) Database architect and being part of the Database Expertise Center team (DBEC) responsible for designing database solutions on Azure Cloud, planning migration projects from on-premises corporate services to Azure Cloud, executing daily tasks to sustain over 2500+ environments of production, DEV, and QA Key Responsibilities: • Create, Update, and Maintain the Standards for database setup and operations on Mars, • Setup of high availability for Database systems (Clustering, Oracle Data Guard FSFO, SQL Server Always On), • Contribute to the Operations team and architecture team to evaluate pain points for running systems, • Collaborate with the architecture and security community to design database systems following the Mars Standards and Applications SLAs • Design database systems following the customer requirements and Mars standards, • Define infrastructure requirements for the database system setup, • Maintain a close relationship with database vendors to have an awareness of new features and capabilities and be conversant regarding database license options, • Work in automation initiatives with Terraform to reduce manual effort in deployment and operations, • Perform capacity planning and performance analysis. • Run proof of concepts of database new capabilities and features and create standards for implementation.
Senior Database Architect
Universidade Estácio de SáSenior Database Architect
Nov. 2020 - Jun. 2021Rio de Janeiro, BrasilWorking as an outsourced Database architect and responsible for database support over Exadata; As part of the database DevOps team, I've integrated Liquibase and Jenkins to manage the development lifecycle of database objects. Daily Tasks • Full support to Oracle Exadata with 256 databases (PDBs), totaling 93 TB of data. • Full support to Oracle RAC 19c databases. • Used technologies: on-premises Oracle 11g (RAC and single instance), Oracle Multitenant (Hot Clone, snapshot for CI/CD pipelines), Liquibase, GIT, Jenkins, scripting (Shell Unix, pearl and phyton), Oracle Encryption (TDE), Data Guard.
Senior Database Architect
BNY MellonSenior Database Architect
Feb. 2019 - Nov. 2020Rio de Janeiro, BrasilWorking as outsourced Database architect and responsible for: designing solutions using Azure Cloud; To plan migration projects from on-premises corporate services to Azure cloud; Execute daily tasks to sustain environments of production, DEV and QA Ongoing projects: • Loan credit risk analyzer and default modeling. In conjunction with credit risk team, I've designed and now I’m building this solution based on SQL Server 2016 with R Services, which uses a machine learning model to provide predictive analytics and Power BI dashboard to display their results. Daily Tasks • Full support to SQL Server databases distributed at 73 instances, 622 databases, totaling 53 Tb of data; • Full support to Oracle RAC 11g databases with 3 Tb total size; • Used technologies: on premises SQL Server 2005/2008/2012/2016, Azure (SQL Server, Virtual Machines), Azure HDInsight, Oracle 11g (RAC and single instance), scripting (Shell Unix, pearl and phyton), Matera, Totvs (Tools), SPB, Windows server 2003/2008/2012/2016
Database and infrastructure Architect
Banco Cruzeiro do SulDatabase and infrastructure Architect
Jan. 2017 - Jan. 2019Rio de Janeiro, Brasil(outsourced contractor by self-company DinamoTech) Working as a remote specialist professional in on-demand services of: • Full support to VLDB Oracle RAC 10g / 11g, SQL Server, MySQL, PostgreSQL databases totaling 90TB of data; • Monitoring database performance and optimizing processes and best practices in SQL; • Vmware cluster environment management support consisting of 6 Dell blades and 275 virtual machines; • Other used Technologies: Matera, Totvs (Tools), SPB, Oracle 10g / 11g (RAC and single instance), Linux Red Hat, Oracle Enterprise Linux, Windows Server 2003/2008/2012. SQL Server 2005/2008, MySQL 5.5, PostgreSQL 9, Oracle Grid Control 11g, Netbackup, Netapp Snapshot and Netapp SnapRestore, Unix shell script, pearl, python.
Senior Infrastructure and Middleware Specialist
Rio 2016 - Comitê Organizador dos Jogos Olímpicos e ParalímpicosSenior Infrastructure and Middleware Specialist
May. 2015 - Dec. 2016Rio de Janeiro• Reporting to the general IT manager; • Designed and deployed middleware infrastructure solutions for service-oriented architecture (SOA) using Oracle SOA Suite; • I've worked as an Oracle SOA Suite administrator into PROD/QA/ DEV environments, performing tasks like: Configuring Weblogic (JMS Queues, Clusters, Heaps sizes, FileAdapter, FTPAdapter, JMSAdapter, DBAdapter, etc.), environment patching and updating, tuning, load tests and analysis, troubleshooting, WLST scripting and etc.; • Mapping and design of systemic integrations using bpel and mediator; • Management of integration tests; • I was responsible for the design and construction of the multi-tier production environment, in high availability, Oracle SOA Suite 12c. Composed of: · Database Tier: SOA Metadata Repository in Oracle RAC 12c; · Application Tier: Cluster Oracle Weblogic with 6 nodes for BPEL, OSB, BAM; · Web Tier: Cluster Oracle OHS (mod_wl_ohs) with 4 nodes; · Load Balancer Tier: HAProxy Cold Failover Cluster; Note: The Akamai (CDN) Cloud is also used as an external access port for content filtering and attack prevention against SOA Infrastructure.
Database and infrastructure Architect
Banco Cruzeiro do SulDatabase and infrastructure Architect
May. 2015 - Dec. 2016Rio de Janeiro, BrasilWorking as a remote specialist professional in on-demand services
Database and infrastructure Architect
Banco Cruzeiro do SulDatabase and infrastructure Architect
Jan. 2014 - Apr. 2015Rio de Janeiro Area, BrazilWorking as outsourced cloud solutions architect at Banco Cruzeiro do Sul S/A and responsible for designing the phases of the migration project from on-premises corporate services to AWS cloud. Finished or ongoing project activities: • I’ve created a new backup process with integration between Netbackup, AWS Storage Gateway, and AWS Glacier. With this new method there was an 80% cost reduction from old backup method; • Virtual private cloud (VPC) provisioning and connection to physical data center through VPN; • Migration of the development environments to AWS using services: EC2, S3, EBS, RDS, CloudFormation; • Consolidation of corporate databases for future migration to the AWS RDS service; Daily Tasks • Full support for VLDB Oracle RAC 10g / 11g and SQL Server databases totaling 90TB of data; • VMware cluster environment administration and support consisting of 6 Dell blades and 275 virtual machines; • Other used technologies: Matera, Totvs (Tools), SPB, Oracle 10g / 11g (RAC and single instance), Linux Red Hat, Oracle Enterprise Linux, Windows server 2003/2008/2012. SQL Server 2005/2008. Oracle Grid Control 11g, Netbackup, Netapp Snapshot and Netapp SnapRestore, UNIX shell script, pearl, phyton.
IT Consultant - infrastructure and cloud solutions
BSI TecnologiaIT Consultant - infrastructure and cloud solutions
Nov. 2012 - Jan. 2014Rio de Janeiro Area, BrazilAs a cloud solutions architect with MS Azure technology, I planned and executed migration and integration projects between on-premises environments and the Azure cloud. • Relevant Project - AHK Brazil-Germany Chamber of Commerce and Industry I was responsible for designing the solution and coordinating the migration of local services (MS Exchange, Active Directory, SQLServer, Totvs Protheus, IIS Web apps) to Azure. Also working as, a team member in the execution phase of the project. In addition to office365 as an e-mail solution, the following Azure products were used: Windows Virtual Machines for Totvs Protheus applications; Azure Active Directory; Azure Active Directory Domain Services; SQLServer DaaS; Visual Studio Team Services; VPN Gateway; Application Gateway.
Database Coordinator
Banco Cruzeiro do SulDatabase Coordinator
Feb. 2011 - Oct. 2012Rio de Janeiro Area, Brazil• Responsible by a team with 2 Senior Dba's and 5 outsourced workers, I've planned and researched infrastructure needs according projected business growth; • I've performed interface with the other business areas, enabling less conflicting and costly alternatives; • I propose solutions to ensure the continuity of the corporate environment (PCN), through clear definition of processes and structuring of services; • I Developed change processes, as well as participated in the change management committee; • Participated in Analysis, Standardization, and Documentation of operational procedures; • Sometimes, I played as a mentor for infrastructure teams; • Provided daily support to Oracle, SQL Server, MySQL, PostgreSQL databases; • Responsible for monitoring database performance and optimizing processes with best practices in SQL; • Worked technologies: Matera, Totvs (Tools), SPB, Oracle 10g / 11g (RAC and single instance), Linux Red Hat, Oracle Enterprise Linux, Windows server 2003/2008. SQL Server 2005/2008. Oracle Grid Control 11g Installation, Configuration and Maintenance. Restoration and recovery of VLDB (Very Large Databases) using: Netbackup, Netapp Snapshot and Netapp SnapRestore, Unix shell script, pearl, python, VMware administration. Achieved results - Technological Renewal Project of Banco Cruzeiro do Sul • Deployment of the Private Cloud Database infrastructure (Oracle 11gR2) with 16 dell blades; • Migration of 33 Oracle databases on the windows 64bit platform to Oracle Enterprise Linux x86_64 totaling 90TB of data; • Decrease in the number of Oracle servers from 46 to 16, with increased CPU and Memory; • 80% reduction in licensing cost for operating system and 35% reduction in Oracle licenses; • Review of backup policies and techniques with the implementation of compressed and parallelized backups via multiple RAC Nodes; • Reduction in backup time between 20% to 40% per base, with a 40% reduction in volume generated.
Senior - SOA Architect / DBA Oracle
OWSE - Objects Web & Software EngineeringSenior - SOA Architect / DBA Oracle
Oct. 2009 - Jan. 2011Rio de Janeiro Area, BrazilWorking in conjunction with IT management aiming at implementing service support processes and service delivery, focusing on ITIL for the customer service of the company. Participated in the survey and analysis for choosing the SiT! (Support Incident Tracker) for Incident Management, Problem and Change tool. Subsequently participated in its implementation as project leader. Customer Login Intermodal Logistics - 10/2009 - / 01 2011 - Project: Oracle SOA Suite Responsible for architecture design and implementation of the infrastructure Oracle SOA Suite in the following configuration: 2 nodes to a repository on Oracle RAC 11gR2, 2 clustered nodes in middle layer sounds. To set up the cluster sounds were made installations and configurations, separate products: Red Hat Enterprise Server 4.7, BPEL, ESB, WSM in separate OC4J instances. To layer, the ESB was performed physical separation of esb runtime and design team. The latter was set up under the Active / Passive. Also part of this setup configuration Load Balancer F5 BIG IP. Also, highlights for the following activities in support of database and SO: • Administration, Backup, and Tuning of MySQL, Oracle 9i,10g single and rack environments. • Troubleshooting, environment patching, and updating, driving Oracle Support (former Metalink) service requests. • Shell Script (Unix) and pearl programming to perform administrative tasks; • Documentation of procedures for: Oracle product installation, security processes, norms and standards and etc.
Senior - Oracle DBA / Middleware Architect
Ministério Público do Estado do Rio de Janeiro (MPRJ)Senior - Oracle DBA / Middleware Architect
Mar. 2009 - Apr. 2010Rio de Janeiro Area, BrazilIn charge of administration for all Oracle Application Server 10g environments (production/development/Q.A) with the following tasks: Administration of: Oracle Portal 10.1.4, Oracle Internet Directory, Oracle Identity Management 10.1.4, Oracle SOA Suite, Tuning, Backup for whole environment; Troubleshooting, patchsets deployments, OneOff patches deployments, driving Metalink Service Requests; Unix Shell Scripting to perform administrative tasks; Besides daily environment activities, I was also responsible for the creation of environments for development and Q.A for the Oracle portal using cloning techniques to clone infrastructure layer and LDAP migration to copy portal users between environments.
Senior - Oracle DBA Architect / Technical Coordinator
ORION CONSULTORIASenior - Oracle DBA Architect / Technical Coordinator
Apr. 2008 - Mar. 2009Rio de Janeiro Area, BrazilActing as coordinator of a team of six dbas with the following activities: • Management of internal suppliers, services, and outsourcing contracts ; • Planning investments in projects for the area; • Support in the budget definition and control (CAPEX / OPEX) of the area by ensuring it accomplishment with IT management; • Control and prioritizing the routine tasks of the team; • Service Management (ITSM); • Mapping/definition and/or redefinition of internal processes; • Installation of Oracle products (Database, Clients, OracleAS, etc.). • Database Administration, Backup and Tuning for Mysql, PostgreSQL, Oracle 11g, Oracle 10g, Oracle RAC 10g and 11g; Other activities include works as Senior DBA, acting as a solution architect for database products, Oracle application servers (9iAS/10gAS), etc., or as an analyst for Level 3 and if necessary working directly with the client in order to minimize impacts and conflicts. As recent technical work, I quote the drawings of the architectures for two Oracle RAC projects for the customers: Active Trade CTCV S/A and Supermarkets Intercontinental. In the first, exerting direct action in its implementation and in the second, coordinating the activities of the analyst responsible for implementation.
Senior DBA / Oracle Specialist
Micro Mídia InformáticaSenior DBA / Oracle Specialist
Jun. 2005 - Jun. 2008Rio de JaneiroIn charge of one or more project areas to quote: Architecture Design, Implementation, Administration, Migration and Tuning. In the biggest customers of Brazil: Industrial Company Cataguases, Navy of Brazil, Geoplan, Public Prosecutors of the Rio de Janeiro, DixAmico, Golden Cross, Bradesco Social Security, Supervia and etc. Exercising the following activities: • Project Technical Leader or Project Manager; • Troubleshooting, Administration, Backup and Tuning for MySQL, PostgreSQL, Oracle 9i/10g/RAC databases; • Troubleshooting, Administration, Backup and Tuning for OracleAS 10g and Oracle Collaboration Suite 10g; • Installation of: patchsets, OneOff patches • Conduction of Oracle's support (Metalink) service requests. • Programming at Shell Script (Unix) to perform administrative tasks; • Analysis, documentation, and standardization of customer environments; • Technical Pre-sales; • Documentation of procedures for installing Oracle products • Oracle Technologies worked: Application Server, Grid Control, Collaboration Suite, 10g RAC, Data Guard, Streams, Business Intelligence EE, Portal, WebCache, OC4J, VPD, RMAN.
Owner & Solutions Architect
DinamoTechOwner & Solutions Architect
May. 2005Rio de Janeiro e Região, BrasilAs a consultant contractor working with database and data analysis technologies. I've delivered projects in Brazil and abroad like: • Huge migrations from on-premises to cloud environments cross-platform or not, • Configuring high availability and disaster recovery environments with Oracle Data Guard (FSFO), MS SQL Server Always On, MySQL read replicas, AWS Aurora, and AWS RDS, • Definition of security requirements for the entire database perimeter (inside and outside), • Data cleaning and Data visualization. For more please see below my passage at BNY Mellon Bank, • Database automation (IaC) through Terraform and Ansible • Versioning and tracking database development lifecycle through Liquibase and integration with CI/CD pipelines. For more details on projects conducted, please see the sections below.
Professional Level - Database Administrator
UnimedProfessional Level - Database Administrator
Oct. 2003 - May. 2005Rio de Janeiro Area, BrazilA company focused on creating technological solutions to be deployed in all 19 Unimeds of the Rio de Janeiro state. In charge of production database administration for each one of the 19 Unimeds in the Rio de Janeiro. • Implementation of Security Policies using Oracle Virtual Private Database, Oracle Advanced Security, and Oracle Internet Directory; • Administration, Backup, and Tuning for Oracle 9i databases and Oracle Discovery Repository; • Programming in Shell Scripting (Unix) to deal with administrative tasks; • Creation of load routines (Bulk Load) for the data warehouse; • Development of applications for ETL processing and data consolidation between Oracle environments, Dataflex, and Informix; • Creating analytical reports (OLAP) using Oracle Discovery; • Installation of Oracle products (Database, Clients, Oracle 9iAS, etc.); • Analysis, Standardization, and documentation of existing systems; • Acting as a consultant in data migration and applications from DATAFLEX systems for the 19 Unimeds in Rio de Janeiro;
Trainee - System Analyst / DBA
BL Informatica LTDA. - PETROBRASTrainee - System Analyst / DBA
Jan. 2003 - Oct. 2003Rio de Janeiro Area, BrazilA company specialized in providing consultancy in Systems Development area, Help Desk, Infrastructure Support, IT Outsourcing and Information Security. Having clients like Petrobras (Accountancy, SEFIN, IT, CENPES), Banco Morada, Viabiliza Factoring and others Main activities: • Administration, Backup and Database Tuning (OLTP, Data warehouse); • Shell scripting for administrative tasks routines ; • Acted as DBA on DB2 v8 focusing preparation for IBM certification; • Installation of Oracle products (database, client, 9ids, designer, OEM / OMS, Oracle 9iAS, etc.); • Analysis, documentation, and standardization of application proceedings; • Migration of VB / SQLSERVER 7/2000, ORACLE ORACLE 7.3 for 8i/9i; • I conducted a pilot project of a Data Warehouse using DB2 OLAP Server as a multidimensional environment, Hyperion Analyzer for analytical reporting and Oracle ETL; • Operating environments (WINDOWS NT/2000, LINUX, SOLARIS); • Documentation of installation procedures and standardizing on Oracle and IBM environments;
Intern - Database Administration
BL Informatica LTDA. - PETROBRASIntern - Database Administration
Jan. 2002 - Dec. 2002Rio de Janeiro Area, Brazil
Intern - Database Administration
Prefeitura Municipal de PetrópolisIntern - Database Administration
Jan. 2001 - Dec. 2001Petrópolis Area, Brazil
IT Intern
Dentsply BrasilIT Intern
May. 1999 - May. 2000Petrópolis Area, Brazil

Requests

Touchpoint image
3
Looking for a Job
DBA or DBRE Opportunities in Oracle, MySQL, PostgreSQL
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like PIERRE on Intch
IT
451129 people
17
IT Project Manager @ Freelancer
26
Mobile Engineer @ Raiô Benefícios
15
.Net Fullstack Developer/Angular Developer @ Webfis Processamento de Dados Ltda
ITBI Analyst
39746 people
16
Data Analyst / Engineer @ SoliDeo Glória Data Analytics
15
CEO @ Damch
15
Socio @ Domti