Profileimage by MARCELOTAVARES SANTOS SYSTEM ANALYST, DATA ANALYST, PROGRAMMER PYTHON PLSQL, or DBA from

MARCELO TAVARES SANTOS

available
Contact

Last update: 06.09.2022

SYSTEM ANALYST, DATA ANALYST, PROGRAMMER PYTHON PLSQL, or DBA

Graduation: BSc Computer Science
Hourly-/Daily rates: show
Negotiable for remote projects
Languages: English (Limited professional) | Portuguese (Native or Bilingual) | Spanish (Limited professional)

Attachments

CV_Marcelo_English.docx

Skills

Oracle, critical environments, RAC, Exadata, resources, Memory, HCC, Grid Control, database SQL Server, Operating System Unix, Linux, Languages Shell Scripts, SQL, PL/SQL, ErWin, ERStudio, OBIEE/ODI, Oracle NoSQL, MongoDB, SQL Server Integration, Oracle Enterprise, Cloud Control, Zabbix Enterprise, IBM-AIX, HP, Oracle 12c, Dell servers, Linux platform, SQL Server 2008, database, Backup, RMAN, operating system, IBM, script, PLSQL, data access, OLAP, DW, Datamart, Data Modeling, Java, ODI, OBIEE, Oracle Database 11g, Oracle 10g Base Server, Linux Server / Oracle 9i Server Windows 2003 Server, SQL Server 2000, Sybase, databases, Oracle 9i, PL / SQL, Source Safe (Version Control, DBF, SQL/Server 2000, Visual, UML, Publisher, CRM, Unix, Shell Scripts, Visual version Source Safe, SQLServer 2003, V.Fox Pro, Tunning, Visual Paradigm, Delphi, VBA, Excel, MS Word, MS Visio, Development PL/SQL, MySQL, Crystal Reports, COMPUTER SCIENCE, Windows, Pacote Office, programming, Shell Script, Visual Basic, Oracle (RAC/Exadata), SQL Server, Access, 12c, data security, Cloud Control 12c, HP Operations Manager, Data, Jira, Document Management, V.Source Safe, PVCS, Subversion, Confluence(Atlassian), Project, Domain, Unix / Linux (Shell Script), ETL, Microsoft SSIS, SSRS

Project history

07/2009 - 02/2019
DBA Analyst
BRQ (250-500 employees)
Energy, water and environment

- CCEE for Consulting: BRQ - (09/JUL – 02/FEB).

Currently working as a DBA Oracle 12c, with Dell servers, Linux platform, the Chamber of Electric Energy Commercialization. Participation in projects such as: Accounting and Settlement System, Data Collection System for Energy, Migration Databases Eletrobras SQL Server 2008 to 2012, and others.

Specifics activities like: Installing, configuring database, tuning of queries and database. Studies, tests and POCs with Oracle NoSQL and MongoDB.

Process Backup: Import and Export (Data Pump), RMAN, operating system backup with IBM TSM (Tivoli) and Storage DR4100 Dell. Create script / backup system in Shell Script with PLSQL, using either Data Pump or RMAN.

Security control for data access, developed using user-level VPD feature on Oracle 12c, OLAP layer: DW and Datamart.

ERWin Data Modeling and ER Studio Relational and Dimensional and deployment and Oracle Exadata administration. Development teams support Java, PLSQL, ODI and OBIEE.


07/2007 - 07/2009
DBA Analyst (Developer)
BRQ (1000-5000 employees)
Internet and Information Technology

- Projects - Consulting / Factory: BRQ - (07/JUL - 09/JUL).

Acted as AD / DBA in Consulting (Factory) in view of the demands of projects across the enterprise. Activities developed and underdevelopment: import and export Data Pump Oracle Database 11g, Oracle 10g Base Server Maintenance, Migration DW, Build Linux Server / Oracle 9i Server Windows 2003 Server to SQL Server 2000, working with the various Tuning Projects migration data Bases equal and distinct (Sybase / Oracle), data modeling (ERWin), support to projects RL, SIC ALPS, C9 among others, and these projects are responsible for the areas of Accounting, Customer Master, Reports Income and other related areas. Servicing customers of the financial and insurance

05/2007 - 07/2007
Analyst Developer
BRQ (1000-5000 employees)
Banks and financial services

- Integration Project Merlin - the Tecban Consulting: BRQ - (07/MAY - 07/JUL).

            Participated in this project Integration, Oracle Analyst, the goal was to integrate databases into one of Tecban Base DW that will be used later by a system of third generation process for BI The tools used are: Oracle 9i, PL / SQL, Source Safe (Version Control) and ErWin for Data Modeling

09/2006 - 04/2007
Consultant
DBK Technology (250-500 employees)
Insurance

- I project Notre Dame for the Consultancy: DBK Tecnologia–(06/SEP–07/APR).

Coordinated and I developed the Project Official Registrations to automate the generation of files in format DBF and TXT, being used of the tools Oracle 9i, SQL/Server 2000, Java, Visual Paradigm (UML), ErWin (Modelling Given) and activities as: Analysis, Adm.Banco and Development

01/2006 - 09/2006
Consultant
TQI (Accenture) (500-1000 employees)
Internet and Information Technology

- I project Publisher Abril for the Consultorias TQI and Accenture–(01/06–09/06).

I Participated in the development of the Sistema CRM, that was a migration system. Adapt in Unix (operational), Shell Scripts, Oracle 9i, control of Visual version Source Safe (Analysis / PL-SQL / DBA).

09/2005 - 01/2006
Consultant
LinkSystems (50-250 employees)
Internet and Information Technology

- I support Santander for the Consultoria LinkSystems (09/05–01/06).

I Worked with the platforms of B. of data Oracle 9i, SQLServer 2003 and V.Fox Pro. Developing scripts for integration of the data of the mentioned platforms, to assist the demands requested by the section Marketing. Activities as: development PL/SQL, Tunning, Extraction of Data, generation of new bases of data and analysis

01/2004 - 09/2005
System Analyst
Universidade Santa Cecília (500-1000 employees)
Other
I worked with tools for modelling ErWin, Visual Paradigm and Poseidon for UML, database Oracle (Administration and Development) in server IBM AIX Unix, SQL/Server 2000 (Administration) and development in Delphi. I developed the system of Poliesportivo, System for Control of optical Presence (reader) and Emission of Certificates, System of Order of Service for Maintenance of Computer science and System of Control of Registrations in VBA - Excel

01/2002 - 12/2003
System Analyst
Cosipa (5000-10.000 employees)
Other
I accomplished the course of Oracle, SQL, PL/SQL, Tunning of consultations and language Centura. I participated and I developed the System of Microfilmagem for control of receipts.  I also participated of the system of Control of Requests developed in Access (VBA) with Oracle. Responsibility in the activities of Analysis (structured and essential) using the tools MS Word and MS Visio and Development PL/SQL

Time and spatial flexibility

  • Availability Change Country / State / City

Contact form

Contact details

Register