Fernando Leonel Mendes

Experience

• 

  Compsis

  Mar 1999 - Feb 2007

  Sr. Oracle Database

  Installation and administration • Installation and configuration of Oracle database 7.3, 8.0, 8i and 9i• Installation and configuration of SCO UNIX, LINUX and WINDOWS• Creating and implementing poly backup and recover • Creating and implementing poly to collation statistics • Migration Informix to Oracle 9i • Troubleshoot Oracle 7.3, 8.0, 8i and 9i• Upgrading database • Creating and maintenance of shell scripts• Oracle data guardDatabase Replication • Creating materialize view with refresh fast and completelyUpdating data model• Upgrade data model logically and fiscally • Creating script • Test QADocumentations • Creating procedure installation and configuration oracle 7.3, 8.0, 8i and 9i• ISO 900• Elaboration of training• Maintenance of data model Show less

• 

  UOL

  Feb 2007 - Jul 2008

  Sr. Oracle Database Project

  • AD project, creating, test scripts to update database schemas Project for unification account manager• Developed procedure PL/SQL to unify and consolidate all products in one account manager system with data track and SAP interface. • Performance Assurance• Risk analyses • Low down time Updating data model• Upgrade logical and fiscal data model• Creating script • Test QADatabase distributed• Controlling transaction distributed• Controlling grants• DB LINKS Database Replication • Creating materialize view refresh fast and complete• Oracle StreamsDatabase administration • Installation of Oracle database 9i, 10g and 11g on Linux and AIX• Backup and recovery - RMAN• Installation of MYSQL on Linux Optimization SQL Maintenance Shell Script Show less

• 

  Inmetrics S/A

  Jun 2008 - Oct 2018

  Sr. Oracle Database Consultant

  Project for HSBC Bank– Migration of database 9i Solaris server to another, larger one•Plan, Develop and Implement migration of database 9i platform Solaris SPARC 9 local disks to Solaris SPARC 10 new server, with low downtime and a critical database using Standby Database for Call Center•Creating Migration and Fallback plans with Performance Assurance•Risk analyses •Configure SolarisProject for HP / Nextel – Migration with Performance Assurance•Migration of core database company Oracle 9i to Oracle 11g with performance assurance•Optimization and Tuning of SQL and PL/SQL code•Risk and Impact analyses to migrate Oracle 9i for Oracle 11g•Optimization of batch process•Interpreting Wait Events and providing solutions•Advising Application Developer to implement change Project for CBSS / VISA VALE – Stress Test•Oracle RAC 11GProject for Bank Santander Insurance – Optimization of online process and batch process•Reduction of execution time for processes batch and online processes•Optimization and Tuning of SQL and PL/SQL•Partition table and index•Reporting result to clientsProject for TECBAN ATM Network – Reduction of CPU usage•Reduction of CPU usage from database server to support increase of businesses•Optimization of batch process and online process•Analysis of operating system UNIX AIX (SAR, NMOM)•Optimization and Tuning of SQL and PL/SQL•Tuning SGA, PGA and other parametersProject for VIVO Cellular – Telecom Corporation whit 76.1 million clients – Performance Team•Database performance assurance •Optimization and Tuning of SQL and PL/SQL•Troubleshoot Oracle RAC 10G and 11G•Crisis Room - I worked with other teams such as developers, network, storage and operating systems to solve critical problems for the company•Partition table Other Projects •Optimization of DW using partition table, index bitmap and materialize view •Optimization of ETL process•Troubleshoot Oracle RAC 10g and 11g•Troubleshoot Oracle 9i, 10g and 11g Show less

• 

  Rede

  Oct 2018 - Oct 2019

  DBA
• 

  Vivo (Telefônica Brasil)

  Oct 2019 - Jun 2021

  Analista de capacidade
• 

  Darede

  Jun 2021 - Apr 2025

  Especialista em banco de dados