Raul Pessoa, Mba Email & Phone Number

Orlando, FL, US

Amherst, Massachusetts, US

• Assessed, documented and implemented Data Guard solution for University of Massachusetts (UMass Amherst), creating an environment with 1 primary and 3 standby databases, including features like Snapshot Standby and.
• Configured Oracle Enterprise Manager (OEM) to monitor and alert about the new structure.
• Planned and implemented backup strategies using RMAN with Commvault to achieve high recoverability of the Data Guard infrastructure, staying in accordance with the retention policies of the organization.
• Created RMAN scripts to keep in Commvault and scheduled the backups to be triggered from the tool, including alerts for unsuccessful executions.

Portlaoise, Co Laois, IE

• Working as a Database Consultant since arrived to United States.
• Evaluated the environment of a government department in order to suggest, and implement, partitioning of tables and indexes in order to improve the performance of queries in data warehouses, achieving a 30% improvement.
• Highlighted the benefits of implementing robust security measures (TDE in this case) to prevent unauthorized access to the data, still keeping seamless and secure data access for applications.
• Executed seamless migration of cluster nodes among the Irish Revenue data centres utilizing Real Application Cluster (RAC) and Automatic Storage Management (ASM) technologies, ensuring uninterrupted operations and.
• Performed database version updates, applied patches, and conducted comprehensive security assessments for Oracle and SQL Server environments, ensuring systems were up-to-date, secure, and resilient.
• Initiated cost-efficient transitions, including the move to cloud storage (Azure BLOB) for MS SQL Server backups and Oracle RAC consolidation (Multitenant) for reduced expenses.

Dublin, IE

• Trained DBA team on daily tasks, reducing external service costs by 50%, and initiated advanced training.
• Implemented Agile Methodology, reducing daily meetings from hours to 20 productive minutes.
• Improved daily tasks methodology, reducing the spent time in 99%.
• Assisted in SharePoint implementation to centralize documentation and created guides, resulting in a 50% reduction in time spent on critical tasks.
• Served as Database Team Leader, overseeing DBA training and infrastructure maintenance.
• Reviewed licenses, identified cost-saving opportunities, and recommended hiring LicenseFortress for legal checks.

Madison, AL, US

• Supported Oracle and MS SQL Server databases in cloud environments (Azure and AWS) using best practices and automation scripting (PowerShell and Shell).
• Analyzed database performance, proposed design improvements, and suggested databases for DBaaS (Azure SQL).
• Optimized backup strategies by relocating backups (Hot<->Archive) to Azure BLOB, reducing costs by 20%.
• Lowered license costs by recommending the migration of certain databases from MS SQL Server on a VM to Azure SQL based on workload and size.
• Facilitated the transition to DBaaS, allowing infrastructure teams to focus on improvements, indirectly contributing to colleague promotions.
• Implemented Always-On solution for high availability in Azure.

São Paulo, BR

• Successfully promoted from Senior Oracle DBA to Project DBA and Project Manager Assistant while supporting Cielo for TIVIT.
• Recognized by Cielo for seamlessly migrating a 20TB database in one weekend without service interruption or network overload, utilizing Data Guard.
• Facilitated clear communication between the previous service provider (IBM) and the new datacenter team based on prior experience with the former.
• Conducted performance analysis, provided infrastructure support, and effectively troubleshooted errors.
• Played a key role as the assistant project manager during the migration, organizing tasks among all involved teams for project success.

Barueri, SP, BR

• Database performance analysis. Monitor the database performance using Oracle Enterprise Manager and send metrics to Data Developer to tune queries.
• Using OEM, find queries with bad performance and reply back to development team.

Campinas, São Paulo, BR

• Led a 9-month project as an independent Senior Database Consultant, coordinating the transition from tape-based backups to cloud solutions.
• Mapped internal processes, initiated new backup methods, and validated Veritas NetBackup licenses for efficiency reducing costs in 10% with cloud backups and reducing licenses.
• Aligned stakeholder expectations for Azure and AWS cloud providers, assessing team knowledge and planning training needs.
• Communicated technical options to the customer using non-technical language, emphasizing differences in AWS S3 (Hot-Cold-Glacier) and Azure BLOB (Hot-Cool-Archive).
• Prioritized areas, planned tests, and implemented Oracle 11g and 12c solutions, utilizing Bash Scripting for file transfers to Cloud Storage.

Jaguariuna, SP, BR

• Led the creation of a new support center for Stefanini, serving diverse sectors such as automotive, textile, banking, and utilities.
• Headed the Database team, engaging closely with clients to identify and structure their database technologies and backup strategies, utilizing RMAN with Veritas NetBackup and/or NFS.
• Managed a multidisciplinary team covering Oracle, SQL Server, MySQL, MongoDB, Sybase, Cisco, FortiGate, and Windows expertise.
• Conducted interviews, presented results to HR, controlled team schedules, and evaluated customer needs for contract scope and shared support.
• Developed technical documentation for contract negotiations, researched and implemented monitoring (Zabbix) and ticket tools (OTRS), and standardized service documentation.
• Supported clients including Valeo, Alpargatas, Banco Fibra, and CPFL, synchronizing internal requests with the Stefanini ticketing system (OTRS integration).

Issy-les-Moulineaux, Ile-de-France, FR

• Contributed to Edenred's database support team, managing both Oracle and MS SQL Server environments.
• Specialized in data replication technologies, specifically Oracle Golden-Gate and Data-Guard.
• Administered Oracle database infrastructure on Oracle Linux, including RAC Single Instance and ASM.
• Engaged in Oracle Linux upgrade projects (6 to 7) and strategically implemented structural changes, recommending a cost-effective shift from Oracle RAC 3 nodes to RAC Single Instance, emphasizing the significant cost.
• Verified and validated change implementation procedures, monitored backup routines (RMAN and SQL Agent), and managed space for MS SQL Server on Windows OS, shrinking static databases reducing costs in 5% with storage.
• Addressed failures and errors (troubleshooting) for Oracle 10g and 11g, as well as SQL Server 2012 and 2014.

Campinas, São Paulo, BR

• Implemented strategic measures to enhance backup efficiency, validating schedules, and routines for tape backups via Veritas NetBackup, reducing the errors with backup and recovery to zero after completing the project.
• Conducted error verification, synchronized retention with the backup team, and documented comprehensive backup policies.
• Demonstrated expertise in Oracle 11g and 12c, utilizing Oracle Recovery Manager (RMAN) for effective database management.

Houston, Texas, US

• Progressed from Junior DBA to accomplished Oracle DBA at Hewlett & Packard, thriving in a fully remote, multinational, and procedural environment.
• Proficient in parameter configuration, privileges, and debugging tasks.
• Demonstrated expertise in backup and restore operations using RMAN and Data Guard.
• Developed Shell Script, SQL, and PL-SQL scripts for instances management and data extraction.
• Contributed to the management of extensive databases across Oracle versions, from archaic 7i to 11g.

Armonk, New York, NY, US

• Orchestrated database administration for Oracle 9i, 10g, and 11g on Unix and Linux systems at IBM.
• Collaborated in a multicultural team, supporting prominent clients in the United States, including Nike and Sprint.
• Proficient in parameter setting, privileges management, and debugging, ensuring optimal database performance.
• Updated backup and restore procedures with RMAN and Data Guard, maintaining data integrity.
• Analyzed and optimized SQL code for enhanced performance, incorporating updates and patches.
• Played a pivotal role in migration projects, displaying adaptability and expertise.

Armonk, New York, NY, US

• Worked as an Oracle DBA trainee, demonstrating passion for database administration by extending my work hours as a volunteer at the Database Team.
• Contributed to essential tasks such as tablespace management, datafile creation, and database installations.
• Conducted structural analysis of databases and validated backup procedures.

Armonk, New York, NY, US

AS400 Support

Armonk, New York, NY, US

• Monitoring of IBM customer environments, such as network performance and availability of resources.
• Availability of applications (Notes, SAP, Oracle, DB2, SQL, Exchange).
• First-level support for operating systems (Linux, AIX, HP-UX, Solaris and Windows)
• Accompanying transactions, compensations, movements and Daily Operations.
• Working with tools: Patrol, NetView for Networks, SNA NetView, GetService, Tivoli Enterprises Console (TEC), and PCAnywhere.

Master'S | Nfq Level 9, Information Technology

Associate | Nfq Level 6, Management Information Systems, General

Career Diploma | Nfq Level 5, Computer Programming

High School Diploma - Nfq Level 4, High School/Secondary Diplomas And Certificates