Alvaro G.

Oracle Consultant, DBA, OCP, ITIL

Average 0 of 5

Hourly rate: USD 40.00

Freelancer activity: IT & Programming


Skills (Maximum: 3)
About me
Extensive experience with planning, development, project management in Oracle Database 9i, 10g and 11g with a focus on performance improvement projects and high availability with Oracle RAC.

Focus on:
- Oracle Database Server Architecture.
- Installation and Setup Environments.
- Managing Users.
- Database Backup using Datapump & RMAN and Backup Policy.
- Work in both environments Windows and UNIX (RHEL,OEL,CentOS).
- Clone Database using Cold, Hot Backup & DBCA.
- Oracle Replication.
- Duplicate Database using RMAN Duplicate Command on Same Server & Remote Server and ASM and other file systems.
- Refresh Database.
- Disaster Recovery ( Same Server / Remote Server ).
- Dataguard Administration.
- Monitoring of network services.

Official certifications:

OCA - Oracle 11g Administrator Certified Associate;
OCA - Oracle PL/SQL Developer Certified Associate;
IBM Certified Solution Designer - Object Oriented Analysis and Design, vUML 2;
IBM Certified Solution Designer - IBM Rational Unified Process V7.0;
IBM Certified Specialist for Rational Requirements Management w/Use Cases
Work history
* Teraquest Suporte e Tecnologia (Information Technology and Services): Support on demand of second and third level specialist care for remote monitoring or face mission-critical services, periodic visits and preventive maintenance.

>> Availability and Contingency
Cluster database
Implementation of Disaster & Recovery
Data replication

>> Increased performance
Tuning database
Analysis of queries
Health Check

>> Management and control
Best practices with ITIL

>> Security
Audit granular and centralized
Security for Users

>> Training database for IT professionals

* UOL (Internet)

* Manaus Ambiental S.A. (Information Technology and Services) [desde 1/2013]: Key responsibilities:

Responsible for maintaining and supporting database and integrated management of sanitation services.

>> Support for application deployment
Update database documentation and support for configuration management and deployment;

Troubleshooting infrastructure applications both in the database as part of the application servers;

>> Real-time monitoring
Monitoring Oracle database with more than 420,000 active customers;

>> Business Intelligence
Planning data warehouse to store information about the activities of an organization in databases, on a consolidated basis.

Use tools like QlikView for Business to delivers true self-service BI that empowers business users by driving innovative decision-making.

>> Oracle 11g Migration
Migration from old version Oracle 9i to Oracle 11g and adequacy of facilities for the new environment database

>> Suitability of Oracle licenses (LSM)

>> Configuration and Deployment Tool "Foglight NMS" for monitoring the assets of the corporate network to assist the technical team of infrastructure.

* FUCAPI (Information Technology and Services) [desde 1/2012]: Key responsibilities:

>> PL/SQL Programming
Development using Oracle tools like SQL Developer and Data Modeler;

>> Data Modeling
Use of Oracle SQL Data Modeler tool to import the data model through reverse engineering;

>> Database Documentation
Implementation of version control database objects through SVN;

>> Query Optimization (Tuning)
Tune and boost SQLs in real-time and improve database performance;

>> Training PL / SQL for IT staff
Providing training to development, architecture and configuration management teams;

>> Support for application deployment
Update database documentation and support for configuration management and architecture;

>> Support in the database on the National Commodity Project Suframa;

Other activities:

>> Professor monitor the course of post-graduate residency in Software Engineering.

* Logos Bolsa de Veículos Ltda (Automotive) [desde 12/2008]: Key responsibilities:

- Database Administration and SQL Server T-SQL programming
- Data Modeling
- Query Optimization (Tuning)
- Support for application deployment
- Support in the database in the internal system (ERP) modules in purchasing, sales and human resources

* Secretaria Municipal de Maceió (Information Technology and Services) [desde 10/2003]: Key responsibilities:

Website Development Health Maceio by using PHP and Javascript.

* IFAM (Higher Education) [desde 12/2002]: Key responsibilities:

Training for staff in the ASP programming language and database SQL Server 2000.

* Megatech Informática Ltda (Professional Training & Coaching) [desde 12/2002]: Key responsibilities:

Taught basic and advanced courses in information technology and website development.
Activity and ratings

Last login: 3 years ago

Joined: 3 years ago

Ranked: Not ranked

Profile level: Iron

What is profile
level iron?

Iron is the starter level for freelancers in Workana. The more objectives they fulfill, and the more projects they win, allows them to reach higher levels. Read more