Leao, Luiz - Resumé

LUIZ CLAUDIO LEAO

250 Kensington Ave, Apt. 114

H3Z 2G8 – Montréal, Québec, Canada

Phone: +1 (514) 678-6888

OBJECTIVE

· To obtain a position as Senior Database Administrator to provide services for administration, installation, configuration, and maintenance of Oracle and Informix databases.

QUALIFICATIONS AND SKILLS

· 18 years of experience in the Information Technology Industry as a whole.

· 10 years of experience as Oracle DBA, since version 7.3 until 10g, and familiar with core technologies like Data Guard, ASM and RAC.

· Oracle Certified Professional (OCP) as Oracle DBA in version 7.3, 8i, 9i and 10g.

· Informix Certified Professional as Informix DBA in version 7.3.

· 4 years of experience as DBA for Oracle Applications version 11.0.3, 11.5.4 and 11.5.10.

· Experience with HP-UX, Sun Solaris, AIX and Linux Servers.

· Experience with PL/SQL, SQL and Shell UNIX scripts.

· 5 years of experience administering Informix 7.3 and SQLServer 2000 databases.

· Experience in data modeling, reverse engineering and capacity planning.

· Able to work independently and creatively to solve complex technical problems.

· Able to communicate in English, French, Spanish and Portuguese (native).

· Able to work as a team player in a collaborative environment.

· Able to adapt and learn new technologies.

· Able to be accessible and available for on-call responsibilities, at night and on Sundays, on a rotation basis.

PROFESSIONAL EXPERIENCE

CGI, Montréal, Québec – www.cgi.com

Period : May/2006 –

Function: Senior Database Administrator / Team Leader

· Administer and manage several Oracle and Informix Databases on multiples environments of production, testing, training and development.

· Monitor Critical 24x7 Production Databases for acceptable/stable performance.

· Maintain acceptable security levels.

· Migrate Oracle Databases from version 8i/9i to 10g with ASM and RAC.

· Develop operational procedures and coordinate backup and recovery with RMAN, Veritas NetBackup and Tivoli Storage Manager (TSM).

· Install DBMS, configure ASM and RAC, create tables, implement integrity constraints, write store procedures and triggers, design and implement indexes, and assist developers with database related tasks.

· Install and Configure Oracle Data Guard for Standby Databases.

· Team Leader of 8 DBA’s in Montreal and 3 DBA’s in Toronto.

· Provide technical training on Oracle Administration for beginner and intermediate DBA’s.

· Elaborate Work Plan, Test Plan, Contingence Plan, and Rollback Plan for every Database implementation.

· Organize meeting and conference call with customers, vendors, project managers and dba’s.

· Elaborate Technical Documentations, such as: Build Book, Run Book and Database Change Record Book, Detail Design Documentation.

TELMEX LATIN AMERICA, São Paulo, Brazil – www.telmexla.com

Period : January/2004 – April/2006 (2 years and 4 months)

Function: Database Administrator

· Maintain Large Oracle Databases running 24/7 on HP-UX servers.

· Technical-leader of the DBA regional team, and responsible for the administration of the production database and Oracle Applications 11.5.4, running 24/7 in a SUN 10K server, sited in Mexico City.

· Implementation and monitoring of backup and recovery strategy with RMAN and VERITAS Netbackup.

· Install and Configuration of a web service to monitor all production databases, using Oracle 10g Grid Control.

· Generate reports of the weekly and monthly evolution of the database capacity.

· SQL and PL/SQL tuning and supervision of scripts execution in production environment.

· Protects database integrity by establishing and maintaining database security integrity controls and conducting periodic quality control audits to ensure proper usage of data.

· Migration of the billing system databases from Oracle 8i / 9i pour 10g.

· Migration of oracle datafiles from filesystems to ASM and configuration of two unix production servers in a RAC architecture.

· Data modeling of new objects / databases and to approve requested changes on the existing data models.

· Analyzes database performance metrics by identifying significant measures of database performance and developing standard trend reports.

· Contact developers, system analysts and system administrators to clarify or revise system needs.

· Stay current with latest technologies, share technical expertise with colleagues and act as a reference for junior employees.

· Participation in the Oracle Application support team throughout the migration of Oracle Applications from v.11.5.4 to 11.5.10.

AT&T LATIN AMERICA, São Paulo, Brazil – www.attla.com

(AT&T LA was acquired by TELMEX on January 2004)

Period : November/2000 – January/2004 (3 years and 2 months)

Function: Database Administrator

· Responsible for the install, upgrade, performance, backup/recovery strategy, as well as the security of the oracle 8i and 9i of the billing system for telecommunication (CBP), running in 24/7 mode.

· Administration of the Informix databases 7.3 of the billing system (SIC).

· Support on development of business’ rules in procedures PL/SQL, and to work with the development team to create safe modules to access the databases.

· Migration of the billing system from Informix 7.3 to Oracle 8i.

· Migration of the Oracle Applications from 11.0.3 to 1.5.4.

· Tuning overall performance of the Oracle Financials production database.

· Implementation of the backup and recovery policy with RMAN and VERITAS Netbackup

· Implementation of a DataMart with Discoverer 3.0, designed to help sales managers make strategic decisions about theirs business.

· Implementation of a remote monitoring service with Oracle Enterprise Manager (OEM) to watch over 30 production databases.

· Researches database utilities, tools, and new database technologies by reviewing white-papers, attending conferences, coordinating project demonstrations, and preparing recommendations for business solutions

INTEGRIS S/A – BULL Group, São Paulo, Brazil – www.integris.com.br

Period : March/1999 – Novembre/2000 (1 year and 9 months)

Function: Database Administrator

Main Responsibilities and Activities:

· Responsible for the installation, configuration and administration of large Oracle databases 7.3.4 and 8.0 of the billing system BSCS in the company Amazônia Celular S/A, TIW Canada Group.

· Lead the DBA team during the process of database specification, deployment, testing and documentation.

· Implementation of a 1Tbyte Data Warehouse with an automatic data replication process to provide more reliable DSS environment to the end users.

· Tune performance and I/O contention of the BSCS database with 800 active sessions running on Sun 6K server.

· Plan and implement backup and recovery scripts through Sun Solstice Backup Utility.

NETSTREAM TELECOM, São Paulo / SP, Brazil

Period : September/1998 – February/1999 (6 months)

Function: Database Administrator

· Responsible for the installation, configuration and administration of Oracle databases 8.0.5 of the billing system CBP, property of ADC Systems, in production and test environments.

· Implementation of backup and recovery policy with Unix Shell and database scripts.

· Generate database capacity planning reports.

· Write PL/SQL, SQL, and shell scripts to support DBA tasks.

BANCO BANESPA S/A, São Paulo, Brazil

Period : February/1997 – September/1998 (1 year and 8 months)

Function: Database Administrator

· Responsible for the administration of oracle databases 7.3 of a private social security system.

FUNDAÇÃO GETULIO VARGAS, São Paulo, Brazil

Period : September/1995 – January/1997 (1 year and 5 months)

Function: System Analyst

· Analyze and development of procedures PL/SQL, Forms 4.5 and Reports 3.5 for the educational system of the University.

· Analyze and development of Delphi programs for the educational system of the University.

TECNOSIS SISTEMAS, São Paulo, Brazil

Period : Octuber/1993 – September/1995 (2 years)

Function: System Analyst

· Analyze and development of procedures PL/SQL, Forms 4.5 and Reports 3.5 for financial systems.

ALUNORTE S/A, Rio de Janeiro, Brazil

Period : June/1992 – Octuber/1993 (1 year and 5 months)

Function: System Analyst

· Experience with languages BASIC, COBOL and FORTRAN for Mainframe.

ALBRAS S/A, Belém, Brazil

Period : April/1988 – May/1992 (4 years and 2 months)

Function: System Analyst

· Experience with languages BASIC, COBOL and FORTRAN for Mainframe.

EDUCATION

· « Faculdade de Tecnologia Hebraico Renascença » – São Paulo, Brazil: University Degree in « Information Technology » – from 2001 to 2003.

· « Universidade Federal do Pará (UFPa) » – Belém, Brazil: University Degree in « Data Processing Technology » – from 1985 to 1987.

IDIOMS

· English advanced (written and speaking), French pos-intermediate (writing and speaking), Spanish pre-intermediate (speaking and writing), and Portuguese native.

COURSES AND CERTIFICATIONS

· Certification OCP as DBA Oracle 10g – April 2006

· Certification OCP as DBA Oracle 9i – September 2005

· « Performance and Tuning Informix Dynamic Server (Unix) », Informix, November 2001, 40 hours.

· « Managing and Optimizing Informix Dynamic Server Databases », Informix, September 2001, 40 hours.

· « Administering a MS SQL Server 2000 Database », Microsoft, May 2001, 40 hours.

· « Oracle 8i: New Features for Administrators », Oracle, November 2000, 40 hours.

· Certification OCP as DBA Oracle 7.3 – April 2000.

Last update on July 20, 2007