Leandro Dias

Senior DBA/APPS DBA and Technical Team Lead

Hicksville, NY 11801-6143 - Phone: 516-***-**** (mobile)

Email: accj6n@r.postjobfree.com

Immigration status: Permanent Resident (Green Card holder)

Career Overview

24+ YEARS OF EXPERIENCE IN THE COMPUTER INDUSTRY WORKING FOR LARGE

CORPORATIONS WITH 18 YEARS OF EXTENSIVE EXPERIENCE WITH ORACLE

TECHNOLOGIES, INCLUDING 16 YEARS WORKING WITH ORACLE APPLICATIONS

(10X/11X/12X) AND MORE THAN 15 YEARS WORKING AS AN ORACLE DBA/APPS DBA:

INSTALLING, UPGRADING, CLONING, DESIGNING, GIVING MAINTENANCE, MONITORING,

TUNING IN DISTRIBUTED DATABASE, PATCHING AND ADMINISTRATION OF MULTIPLE

ORACLE FINANCIAL DATABASES, SUPPORTING AND DESIGNING DATA, SECURITY,

DISASTER RECOVERY, ACCESS CONTROL AND BACKUP/RECOVERY PROCEDURES.

Proven track record leading installations, configuring, troubleshooting,

cloning, tuning and maintaining multiple Oracle Applications environments

in a critical production environment; Able to oversee and participate in

the application of all necessary patches to upgrade Oracle Applications to

its latest version (12.1.x); Able to lead planning of production rollout

for the Oracle Applications 11i environments, supervise and transfer

knowledge to a team of Oracle DBA's and able to assist in the recruitment

and retention of Oracle DBA's as well.

Solid Oracle 10g/11g RAC experience on Linux and/or HP-UX including

installation, administration, troubleshooting and performance tuning.

Experienced in Oracle Clusterware (GRID Infrastructure) - CRS management

and configuration. Skilled in Oracle ASM administration.

2 years and 4 months of experience managing a team of 4 senior level

Database Administrators.

Good knowledge in UNIX systems (Solaris/HP-UX/AIX/OEL); designing and

implementing EMC backup/recover procedures using BCV's and

failover/failback strategies using SRDF; users and security implementation

and administration; Database block corruption, Oracle Enterprise Manager

(OEM) and Mercury IT Governance Center (a.k.a Kintana).

Configuring and implementing Security Socket Layer (SSL) with Oracle

Applications 11i.

Configuring Punchout from Oracle iProcurement to Supplier via Oracle

Exchange: cXML.

Oracle Applications 11i Upgrade (11.x.x to 11.5.8 / 11.5.9 / 11.5.10 / 12).

Summary of Experience

ORACLE APPLICATION DATABASE ADMINISTRATOR, LEAD

at Arrow Electronics, Inc. - October 2012 - January 2014

1. RESPONSIBLE FOR USING ORACLE 11.2.0.3 IN AN ORACLE E-BUSINESS SUITE

(11.5.10 / 12.1.3) PROJECT AT THE AIX 6.1 / OEL 5.7 / LINUX RH 5 / EMC

SYMMETRIX SRDF PLATFORM.

2. Responsible for configuring Oracle RMAN backup with Netbackup 7.1.

3. Oracle E-Business Suite Upgrade (from 11.5.10 to 12.1.3)

4. Oracle database upgrade 9.2.0.8 to 10.2.0.4 to 11.2.0.3.

5. Oracle GRID installation / configuration / maintenance.

6. Oracle Real Application Custer (RAC) implementation.

7. Responsible for supporting hundreds of core databases (RAC and non-

RAC).

Oracle APPS Database Administrator, Senior - Consultant

at Canon U.S.A Inc. - July 2004 - October 2012

8. RESPONSIBLE FOR USING ORACLE 11.2.0.3 IN AN ORACLE APPLICATIONS 11I

(11.5.8/11.5.9) / RELEASE 12 (12.1.4) PROJECT AT THE HP-UX

11.11/11.23/ OEL 5.7 / LINUX RH 5 / 9IAS / 10G / ORACLE PORTAL / EMC

SYMMETRIX SRDF PLATFORM.

9. Responsible for configuring Oracle RMAN backup with EMC Legato

Networker 7.4 SP4.

10. Oracle Applications 11i Upgrade (11.5.6 to 11.5.9 / 11.5.8 to 12.1.4)

/ Oracle database upgrade from 8.1.7.4 to 9.2.0.8/10.2.0.4 as well

from 10.2.0.4 to 11.1.0.7/11.2.0.3.

11. Oracle GRID installation / configuration / maintenance.

12. Oracle Real Application Custer (RAC) implementation.

13. Oracle Application 11i Linux Migration (Middle Tiers).

14. Technical Team Lead / DBA for Installation/Upgrade, configuration,

load balance setups and patching of Mercury IT Governance

5.5/6.0/7.1/7.5/9.14 (a.k.a. Kintana / ITG / PPM) / Kintana

Object*Migrator / Kintana GL*Migrator with the following extensions:

eCommerce Extension / OracleTech Extension / Oracle Apps Extension and

Mercury ITG Best Practices.

15. Technical Team Lead / DBA for Installation/Upgrade, configuration and

patching of Plateau Learning Management System (LMS).

16. Oracle Streams Replication configuration.

17. Installing, designing, cloning, patching, maintaining, monitoring,

tuning Oracle databases, supporting designing data, security and

access control.

Oracle APPS Database Administrator for Team Information Services -

at ADP Inc. -

February 2004 - July 2004

18. RESPONSIBLE FOR USING ORACLE 9.2.0.4 IN AN ORACLE APPLICATIONS 11I

(11.5.9) PROJECT AT THE AIX 5.2L / 9IAS / ORACLE PORTAL / EMC

SYMMETRIX SRDF PLATFORM.

19. Oracle Applications 11i Upgrade (11.5.8 to 11.5.9) / Oracle database

upgrade from 8.1.7.4 to 9.2.0.4.

20. Installing, designing, cloning, patching, maintaining, monitoring,

tuning Oracle databases, supporting designing data, security and

access control.

.at Citigroup -

February 2003 - January 2004

21. Responsible for using Oracle 9.2.0.3 in an Oracle Applications 11i

(11.5.9) project at the Sun SPARC Solaris / 9iAS / Oracle Portal /

EMC Symmetrix SRDF platform.

22. Lead planning of production rollout for the Oracle Applications 11i

environments as well as HP Project and Portfolio Management (PPM),

a.k.a Kintana; supervised and transferred knowledge to a team of

Oracle DBA's.

23. Oracle Applications 11i Upgrade (11.5.4 to 11.5.9) / Oracle database

upgrade from 8.1.7.4 to 9.2.0.3.

24. Installing, designing, cloning, patching, maintaining, monitoring and

tuning Oracle databases.

25. Tuning Oracle Databases using Oracle Enterprise Manager (Tuning Pack)

and Statspack.

26. Configuring and implementing Security Socket Layer (SSL) with Oracle

Applications 11i.

27. Configuring and Patching Oracle Financial Databases using Kintana

Accelerator.

28. Configuring Punchout from Oracle iProcurement to Supplier via Oracle

Exchange: cXML.

29. Configuring Oracle Enterprise Manager (OEM) / TOAD / SQL Navigator /

SQLBacktrack.

Oracle Database Administrator for Oracle Corporation

March 2001 - December 2002

30. Responsible for using Oracle 8.1.7.4 / 9.2 in an Oracle Applications

11i (11.5.7) project at the Sun SPARC Solaris / 9iAS / Oracle Portal

/ EMC Symmetrix SRDF platform.

31. Installing, designing, cloning, patching, maintaining, monitoring and

tuning Oracle Financial databases.

32. Configuring Oracle Enterprise Manager (OEM).

33. Tuning Oracle Databases using Oracle Enterprise Manager (Tuning Pack)

and Statspack.

34. Configuring and implementing Security Socket Layer (SSL) with Oracle

Applications 11i.

35. Created backup/recovery procedures using RMAN interacting with EMC

Symmetric SRDF.

36. Configuring Punchout from Oracle iProcurement to Supplier via Oracle

Exchange: cXML.

37. Configuring and Patching Oracle Financial Databases using Kintana

Accelerator.

38. Configuring Punchout from Oracle iProcurement to Supplier via Oracle

Exchange: cXML.

39. Oracle Applications 11i Upgrade (11.5.5 to 11.5.7).

Oracle Database Administrator for Cablevision Systems

July 2000 - March 2001

40. Working in a DBA team (11 members), responsible for using Oracle 8.x

in an Oracle Applications 10.7NCA project at the HP-UX 11.0 / Sun

SPARC Solaris / EMC Symmetrix SRDF platform.

41. Installing, designing, maintaining, cloning, monitoring and tuning

distributed databases.

42. Configuring Oracle Enterprise Manager (OEM) / TOAD / SQL Navigator /

BMC Patrol.

43. Configuring and Patching Oracle Financial Databases using Kintana

Accelerator.

44. Tuning Oracle Databases using Oracle Enterprise Manager (Tuning Pack)

and Statspack.

45. Created backup/recovery procedures using RMAN interacting with EMC

Symmetric SRDF.

46. Created physical and logical standards for Oracle Database

installations.

TAM Airlines - Manager, Database Administration

February 1998 - July 2000

47. MANAGED A TEAM OF 4 SENIOR LEVEL DATABASE ADMINISTRATORS.

48. Set overall direction, coordination, and evaluation of the team.

49. Responsible for determining project schedules and effectively managed

the allocation of resources to achieve objectives.

50. Served as member of multiple management teams and Steering Committees

responsible for setting the strategic direction of IT.

51. Coordinated/interacted with *customers* to analyze situations, review

business problems, propose solutions, scope and estimate level or

resources/ effort required, leading the development of projects in a

timely manner.

52. Oversaw the design, build out and implementation of new and existing

systems.

53. Responsible for the development, review and certification of disaster

recovery (business continuity) procedures and plans for Oracle

Applications and all RDBMS platforms

54. Managed the purchasing and procurement processes of DBA infrastructure

and vendor costs to achieve the lowest cost, highest quality

55. Established and implemented short and long range goals, objectives,

and polices\procedures for the department.

56. Supported team members at all levels within the organization,

including soliciting of information, addressing complaints, and

resolving issues.

57. Ensured compliance management was maintained, including monitoring and

reporting.

58. Interview, hired, and trained employees

59. Installing, designing, cloning, patching, maintaining, monitoring and

tuning Oracle Financial databases.

60. Responsible for overseeing several projects such as Oracle

Applications 11i upgrade, Airline Online Check-in, Data Warehouse and

HR at the HP-UX 11.0 / Sun SPARC Solaris / EMC / Oracle 8.0.4 /

Windows NT platforms.

Oracle Brazil - Oracle Database Administrator

December 1992 - January 1998

61. Responsible for Data Warehouse projects using Oracle 8.0.x at the HP-

UX 11 / SUN Solaris platform.

62. Responsible for using Oracle 8.x in an Oracle Applications 11i project

at the Sun SPARC Solaris / EMC platform.

63. Responsible for the development, review and certification of disaster

recovery (business continuity) procedures and plans for Oracle

Applications and all RDBMS platforms.

64. Coordinated/interacted with *customers* to analyze situations, review

business problems, propose solutions, scope and estimate level or

resources/ effort required, leading the development of projects in a

timely manner.

65. Develop database platform support structure that is required to insure

uninterrupted IT services, which may include a combination of in-house

and consulting services.

66. Oversaw the design, build out and implementation of new and existing

systems.

67. Tuning Oracle Databases using utlbstat/utlestat utilities.

68. Communication between database SQL/DS (mainframe) and Oracle 7.3

through Oracle Transparent Gateway for DRDA, 4.0.0.1. Version.

69. Created backup procedures for Oracle Database.

Oracle Brazil - Oracle Database Administrator, Cargill Agr cola

70. RESPONSIBLE FOR ORACLE 7.X / 8.X DATABASE AT THE HP-UX 10.20 / AIX 4

PLATFORM.

71. Installing, designing, maintaining, monitoring and tuning distributed

database.

72. Supporting and designing data, security and access control.

73. Created backup/recovery procedures for Oracle Database.

Oracle Brazil - Oracle Database Administrator, Ford Motors Brazil

74. Responsible for Oracle 7.x Database at the HP-UX 10.20 / SUN Solaris

platform.

75. Monitoring and tuning distributed database; supporting and designing

data.

76. Created backup/recovery procedures for Oracle Database.

Oracle Brazil - Oracle Database Administrator, Paulista de Seguros

(Insurance Company)

77. RESPONSIBLE FOR ORACLE 7.X DATABASE AT THE SCO UNIX / WINDOWS NT

PLATFORM.

78. Monitoring and tuning distributed database; supporting and designing

data.

79. Configuring Oracle Enterprise Manager (OEM).

80. Created backup/recovery procedures for Oracle Database.

Oracle Brazil - Oracle Database Administrator, Pereira Dias Trading Ind.

Com. Imp. Exp. Ltda (Import/Export Company)

81. DATABASE AREA COORDINATION.

82. Responsible for installing the Oracle Applications 10.4.1 at the HP-UX

platform / Oracle 7.x / Novell 3.12.

83. Systems Development through Oracle Forms 4.5 and Oracle Reports 2.5.

Cotia Trading BR - Oracle Database Administrator

May 1989 - October 1992

84. RESPONSIBLE FOR INSTALLING THE ORACLE APPLICATIONS 10.4.1 AT THE HP-UX

PLATFORM / ORACLE 7.X / NOVELL 3.12.

85. Systems Development through Oracle Forms 4.5 and Oracle Reports 2.5.

CIA de Seguros America do Sul Yasuda - Senior Systems analyst

May 1986 - April 1989

86. Responsible for the development, implementation, training and support

of the Insurance and Reinsurance system, using platform OS4 / F4 /

RDBII / SQL / TSS / JCL.

87. Coordination of the physical and logical system implementation under

platform SCO UNIX / Oracle 6.0 / Micro-Focus COBOL / Shell.

TRAINING

88. PROJECT MANAGEMENT METHODOLOGY TRAINING - KPMG

89. System Lifecycle Implementation Methodology Training - KPMG

90. The Seven Habits - Covey

91. Oracle Financial (Payable/Receivable/General Ledger)

92. MDF - Model of Data and Functions

93. WAA - Oracle Web Application Server - Administration

94. A80 - Database Administration Oracle 8

95. BR8 - Backup & Recovery

Database Character Set Migration

Oracle Applications AD Utilities, Release 11.5.2 - Module 1: Database

Administration Tasks

Business Components for Java: Introduction

96. Administrating Oracle9i Application Server (9iAS)

97. Oracle9i New Features for Administrators.

11i Installing Oracle Applications

Simplifying 11i Migrations

Oracle Applications Release 11i: System Administration

R11, Applications System Administration Diagnostics and Troubleshooting

Installing Oracle9i Application Server 1.0.2.2.2 with Oracle Applications

11i

Oracle8i/9i - Dumps, Crashes, and Corruptions

Oracle9i Installation, Configuration, Migration

Oracle9iAS V1.0.2.2: Installation

Oracle9i Performance Tuning

Oracle9i Multiple Block Size Support

Oracle9i Real Application Clusters Features

Oracle9i Backup and Recovery

Enterprise Manager for Oracle9i

Oracle9i Security

Latches and Tuning

Supporting Oracle Names and LDAP

Oracle9i Advanced Replication New Features

Extend Oracle Applications Cost-Based Optimization Tuning - Module 1: CBO

Operation and Setup

Oracle Database 11G: New Features for Administrators.

Education

98. FASP - FACULDADES ASSOCIADAS DE SAO PAULO - POS-GRADUATION IN

INFORMATION ENGINEER (INCOMPLETE)

99. IESA - Instituto de Ensino Superior Santo Andre - Bacharel degree in

Information Technology

100. University of Cambridge - CCSE certificate - level one

Contact this candidate