Database Administrator Information Technology

Location:

Sao Paulo, Brazil

Posted:

May 23, 2024

Contact this candidate

Resume:

FLAVIO GERMANO

Phone : 55-11-379*-**** Mobile : 55-11-979**-**** e-mail : ad5wjs@r.postjobfree.com

OBJECTIVE: Database Administrator (DBA).

Qualifications

My professional experience is aimed at the information technology area, with broad knowledge in MSSqlServer, Sybase, DB2, Oracle, and MySQL databases (MCP SQLServer certification, DB2 Associate database administrator) and network administration, structured analysis, and essential analysis. Apt in training and user support, skillful at systems development. Working group coordination. Availability for traveling.

Educational Background

. POSTGRADUATE LATO SENSU IN DATA SCIENCE – MACKENZIE PRESBYTERIAN UNIVERSITY

. POSTGRADUATE LATO SENSU IN SYSTEMS ANALYSIS - F.A.A.P.

. TECHNOLOGY IN DATA PROCESSING - FAC. HEBRAICO BRAS. RENASCENÇA . Technical Environment

HARDWARE: AS-400, Prosigna 200, Proliant 7000, Alpha Server 2100, HP 9000, IBM 6000. OPERATING SYSTEM: DOS, Windows 7 / 10 / 11 / workstation, Lan-Manager 2.2, NETWARE 3.12 / 4.10 / 4.11, WINDOWS Server 2008 / 2012 / 2019, SCO UNIX 3.53, HP-UX, OS-400, Linux red hat, Cent OS 7.

SOFTWARE: Sybase / Adaptive Server 11.0.2/11.5.0/11.5.1/11.9.2/12/12.5.2, Sybase Replication Server 11.5.1, MS-SQL Server 2008 to 2019 Oracle 9G to 19c, DB2 V9.7 to V11.1, MySQL 5.5 to 8.0, SQL-Base 6.0, Foxpro 2.5, Visual Foxpro 3.0, Quest, Power Design, SQL-Modeler, SQL-Advantage, Sybase Central, Transact-SQL, PL-SQL.

LANGUAGE: R, Visual Basic, Cobol, Clipper.

APPLICATIONS: Financial Accounting, Loan Control, Insurance, ERP, CRM, Industrial Maintenance, Logistics and Transport.

Professional Experience

Mackenzie Institute

DBA DEC / 2020 to date

The Mackenzie Presbyterian Institute is responsible for the operational support of all areas of Mackenzie Presbyterian University.

I m working in the IT department of the institute. My main contributions are : Low platform performance (Windows, Linux, and Unix), for MSSqlServer, MySQL, Oracle, and DB2 databases with Sqlserver versions 2008 to 2019, Oracle 12c to 19c, MySQL 5.5 to 8 and DB2 11.1. Support as development teams, in ensuring and using the development standard practices. Execution of changes in test, approval, and production environments. Performing backup and restore. Execution of data import/export.

Installation, configuration, and monitoring of database environments. Operational Environment: Windows, Linux, and Aix operating systems, running under VMWARE/VSAN.

Main Results:

Migration of databases from Oracle 19c, DB2 11.1, and MySQL 8 to MS SQLServer 2019. Migration of MySQL databases from local site to Aurora RDS database on AWS. Activities performed :

Oracle: Instances management using SQLPlus, Enterprise Manager, and SQL developer. Maintenance of database objects and users. Support to development and production environments and teams.

SQL Server: Instances management using Management Studio. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Monitoring and troubleshooting of data replication. Backup and restore. ETL process.

MySQL: Instances management using Workbench. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Backup and restore. ETL process. DB2 : Instances management using using db2cc, db2 command, db2 explain, db2advis, etc. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Backup and restore. ETL process.

PrimeIT

DBA Feb / 2015 to Jun 2020

Allocated at the Bradesco client, supporting the development teams. Acting on low platform

(Windows, Linux, and Unix), for MS SqlServer, Sybase, Oracle, and DB2 databases. Acting with the 2008 to 2019 versions of Sqlserver, 10g, 11g, and 12c versions of Oracle, 11.9.2 and 12.5.4 versions of Sybase, versions 8 to 11.1 of DB2. Acting at the software development quality control sector, in the criticism and correction of queries, stored procedures, and triggers created by the developers. Support the development teams, aiming to guarantee the use of the best development practices and, guarantee the use of the development standard used by the client. Execution of changes in the unit test, joint test, and homologation environments. Performing backup and restore. Execution of data import.

Operational Environment: Windows, Linux, Aix, and Solaris operating systems, running under VMWARE/VSAN.

Activities performed :

Oracle: Instances management using SQLPlus, Enterprise Manager, and SQL developer. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. SQL Server: Instances management using Management Studio. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Monitoring and troubleshooting of data replication. Backup and restore. ETL process.

Sybase: Instances management using isql and Sybase Central. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Backup and restore. ETL process. DB2 : Instances management using using db2cc, db2 command, db2 explain, db2advis, etc. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Backup and restore. ETL process.

Capitani Solutions

DBA Sep / 2014 to Jan / 2015

Allocated at BOVESPA (São Paulo Stock Exchange) client. Acting in the management of Oracle database instances (versions 9, 10, 11, and 12) and MSSqlServer (versions 2000, 2005, 2008 / 2008R2 and 2012). I supported development teams, worked on multiple projects, and acted in incident resolution. I also acted with the Update and maintenance of data models. Operational Environment: Linux operating systems, running under VMWARE/VSAN, and Windows running on Microsoft Hyper-V.

Activities performed :

IBM

DBA September/2012 to August/2014

I acted as db2 dba in an implementation project of Websphere commerce, managing development, QA, performance, and production instances of DB2 V9.7. I also gave database support to the development team. I managed Oracle 11g and MSSqlServer 2008 R2 instances too. Operational Environment: AIX and Linux operating systems, running under IBM-VM and Windows running on VMWARE.

Activities performed :

DB2 : Instances management using using db2cc, db2 command, db2 explain, db2advis, etc. Maintenance of database objects and users. Support to development and production environments and teams. Performance tuning of queries and stored procedures. Data modeling. Backup and restore. ETL process.

- Tivit

DBA September/2011 to August/2012

Administration of database instances of the customers. I managed MSSqlServer2000 and MSSqlServer2008 instances on Windows2000 and Windows2003, in clusters and high availability environments. I also administered Sybase 12.5, Oracle 11g and 12c, and DB2 V9.7 instances on Unix

( Solaris, AIX ).

Operational Environment: Windows, Linux, Aix, Solaris operating systems, running under VMWARE/VSAN.

Activities performed :

- SqlTech Consulting

DBA October/2008 to Aug/2011

Work on administration database instances for the bank Itaú Unibanco client, in Production, homologation, and development environments. Managed MSSqlServer2000, MSSqlServer2005, and MSSqlServer2008 in Windows2000, and Windows2003 environments in Cluster and replicated environments. Use of Performance Analysis tools (Quest). Activities performed :

Microsiga Software SA

DBA Jul. / 2000 to Oct / 2008

I have worked in planning, implementation, customization, tuning, replication, migration, and support to Sybase Adaptive Server data, MS-SQLServer, Oracle, and DB2 databases. Development of triggers and stored procedures, for customers of the applications developed by Microsiga. Activities performed :

Other Courses

Administering Windows NT 4.0, Windows NT 4.0 Core Technologies, Supporting Windows NT 4.0 Enterprise.

System and database administration for Sybase adaptive server. Logical and physical database design with power designer. Introduction to Sybase Transact SQL. Writing effective stored procedures. Administering CIS for Sybase Adaptive Server Enterprise 11.9.2. Administering Sybase Replication Server.

Administering Oracle 8i.

Administering IBM DB2 9.7

MS SqlServer 2000 Administration, MS SqlServer 2000 Implementation. Administering Oracle 11G, Programing Oracle 11G.

Language Spoken

. Portuguese, English. Spanish for Technical utilization and basic conversation.

Contact this candidate