Oracle Database Administrator

RODRIGO LOPES LIMA

*******@*****.***

www.linkedin.com/in/rlolima

Rio de Janeiro, Brazil

+55-21-984**-**** (mobile) / +55-21-354*-**** (home / landline)

RESUME

IT worker since 1995

Oracle experience since 2001

Oracle 12c, 11g and 10g installation, configuration, maintenance and tuning

Experience with RAC and SAP databases

Golden Gate Knowledge

Triggers, procedures, packages and queries development and tuning

Network and hardware knowledge

I.T. KNOWLEDGE

Databases: Oracle 12c, 11g and 10g, MSSQL Server (basic skills)

Languages: PL/SQL, SQL ANSI, TSQL, Shell

OS: Windows (all flavors), Linux, UNIX (HP-UX and AIX)

PROFESSIONAL HISTORY

IBM - Supporting Lojas Americanas

Rio de Janeiro, October 2012 – Today

Oracle Account Focal (SME)

Main achievements

•Huge improvement on customer daily SAP operations due to migration from Oracle single instance to RAC. I was the lead DBA, responsible for the planning stage and technical implementation.

•The customer needed to reduce his primary database size due to storage costs and I suggested and implemented the database compress integrated with SAP system, using both Oracle and SAP tools. Achieved around 50% compress ratio, reducing the primary database from 30 terabytes to 15 terabytes.

Responsibilities

•Oracle Account Focal for a huge Brazilian retailer (Lojas Americanas);

•Oracle and Oracle for SAP database administrator;

•Oracle and Oracle for SAP installation, configuration, maintenance, tuning and backup in single instances and RAC;

•Migration from single instance to RAC with minimum downtime;

•Expertise on Oracle for SAP running on RAC;

•Expertise on SAP BRTools;

•Responsible for many databases being the primary larger than 30 terabytes with more than 70 terabytes allocated on ASM due to stretched cluster (redundancy with two storages located different sites);

•Oracle Stretched Cluster implementation for several critical instances, using multiple storages located on different sites;

•Golden Gate replication implementation for small instances;

•RMAN scripting, configuration and implementation.

Instituto Infnet (www.infnet.edu.br) Nov/Dec 2011

Oracle Instructor

Course O110 - Oracle Database 11g: Introduction to SQL.

Hewlett Packard – Supporting EMBRATEL

Rio de Janeiro, March 2010 – September 2012

Senior Database Administrator

Main achievements

Great customer improvement on his daily operations due to continuous search and tuning of bad performing queries.

Lead DBA on planning and technical aspects of a primary database migration from Sun Solaris to HP-UX.

Responsibilities

•Oracle 10g, 9i, 8i production and application DBA for several environments (production, stage, test and development) under several UNIX, Linux and Windows flavors;

•Oracle installation, configuration, maintenance and tuning;

•Improvement of queries performance through tuning;

•Migration from Solaris to HP-UX;

•Implementation of RMAN backups;

•RAC 11gR2 installation and configuration;

•Oracle Enterprise Manager Grid Control installation for Oracle TimesTen monitoring.

Hewlett Packard – Supporting American Airlines

Rio de Janeiro, January 2007 – Feb 2010

Senior Database Administrator

Oracle 10g and 9i application DBA for several environments (production, stage, test and development) under several UNIX, Linux and Windows flavors;

Improvement of queries performance through tuning;

On call support to developers and testers;

24x7 on call rotation.

ANCINE

Rio de Janeiro, July 2005 – Nov 2006

Senior Database Administrator

Oracle server installation, configuration and maintenance;

Improvement of queries performance through tuning;

Backup using RMAN;

Contingence using standby server.

DRIVE

Rio de Janeiro, April 2002 – Jun 2005

Database Administrator

Oracle 9i installation, configuration and maintenance;

MSSQL Server 2000 and Sybase installation, configuration and maintenance;

Script, queries, triggers, functions and stored procedures development using PL/SQL, T-SQL and SQL Ansi;

Backup routine implementation using scripts on Linux and Windows;

Experience as system and support analyst.

TECSO

Rio de Janeiro, April 2001 – Mar 2002

Database Administrator

Oracle installation, configuration and maintenance;

MS SQL Server installation, configuration and maintenance;

Data migration from Oracle to MS SQL Server and vice-versa;

Scripts, queries, triggers, functions and stored procedures development using PL/SQL, T-SQL and SQL Ansi;

System analyst, business analyst and network administrator knowledge.

EDUCATION

Fundação Getúlio Vargas, Rio de Janeiro, RJ

MBA Degree in Enterprise Management – Apr/2007 to Mar/2009

Universidade Estácio de Sá, Rio de Janeiro, RJ

Postgraduate Degree in Computer Networking Projects – 2000 - 2001

Associação Brasileira de Ensino Universitário, Nilópolis, RJ

Bachelor in Data Processing – 1997 - 1999

LANGUAGES

English (full professional proficiency)

Portuguese (native)

CERTIFICATIONS

Oracle Certified Professional 12c (OCP)

Oracle Certified Professional 11g (OCP)

Oracle RAC 10gR2 Certified Expert

Oracle Certified Professional 10g (OCP)

Oracle Certified Professional 9i (OCP)

ITIL Foundation Certified

Microsoft Certified Professional - Windows 2000 Server e Pro (MCP)

Contact this candidate