Alvaro G. freelancer experto en SQL Server, Oracle MySQL, PHP

Alvaro G.

Oracle Consultant, DBA, OCP, ITIL

0 / 5

Valor hora:

USD 40,00

Programación y Tecnología

Habilidades (Máximo: 3)
Sobre mí
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
Historia laboral
* 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.

Rankeado: No está rankeado

Último login: Hace 5 años

Registrado: Hace 5 años