SUMMARY

• 12+ years of experience on analysis, design, installation, management, tuning, maintenance, and support of Oracle Databases from version 7.3 up to llg, including 8, 8i,9i, and lOg on platforms (AIX, HP - UX, Solaris, Windows, Linux).
• Oracle Database Administrator Certified Professional (OCP), from version 7.3 to llg, including 8,8i, 9i, and lOg.
• Definition and implementation of backup and recovery of databases using Recovery Manager (RMAN) interfacing with Tivoli Data Protection (TSM).
• Implementation of Oracle database with Real Application Cluster(RAC), Automatic Storage Management (ASM) and Data Guard.
• Installation and management of oracle databases under Real Application Clusters (RAC), Automatic Storage Management (ASM), and Data Guard.
• Installation and management of Oracle Application Server.
• Installation and management of Manugistics applications, such as SCPO/DPEE.
• Installation and configuration of management version such as control versions systems ( Confidential ) and Sub Version (SVN).
• Installation and configuration of Application Server with Open Source technology such as Apache, Tomcat, and JBoss.
• Hands on experience on database design and modeling of a custom ERP implementation (1500 tables).
• Project leader involved on all phases of projects. A remarkable project delivered consisted of an EDI decoding system a massive amount of information to be later stored in a database, achieving optimized processing including control points for validation as well as data cleansing.
• Elaborate Technical and Financial proposals for Oracle databases management services, including feasibility analysis as well as effort and complexity estimations.
• Technical leader interacting with other team leaders as well as upper management.
• System Architect, defining applications and interfaces architecture.

TECHNICAL SKILLS

Databases: Oracle 7.3,Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g,PostgresSQL Application Server Oracle 10g, Apache, Tomcat, Jboss.

Hardware: IBM P630, HP 9000 V2250, HP 9000 N, SUN Blade 1000

Operating Systems: AIX 5, HP-UX 11.0, SUN Solaris 8, Windows NT, Windows 2000, Linux (Mandrake, Red-Hat)

Programming Languages / Tools: SQL1Plus, SQL*Loader, Export/ Import, Data Pump, RMAN, ASM, RAC, Data Guard, PL/Sql, TOAD, Unix Shell Scripts, sed, awk, vi, C. C++, Pascal, Assembler, Prolog, Lisp, Java, MS Project, ErWin.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA, Database Team Leader

Responsibilities:

• Define database design and implementation guidelines.
• Install and configure databases for development, test, and production application instances.
• Define backup and recovery strategy for the system.
• Manage databases (security, objects, space allocations, backup, and recovery).
• Plan activities related to database management, and monitor plan execution.
• Prepare status reports, and present them to the project manager and team leaders.
• Define and prepare project deliverables related to database activities.

Tools: Oracle 10g (10.2.0.5), Oracle 11g (11.2.0.1), Oracle VM x86-64, Oracle Enterprise Linux Server 5.5, 64 bits. 1 • tablespaces management, monitoring, and troubleshooting., Report of project status on a weekly basis to upper management., Oracle 10g (10.2.0.1), Oracle Application Server 10g (10.1.3.1.0 ), Apache 2.2.10 (Open Source), IBM P5, AIX 5L Ver 5.3

Confidential

Senior Oracle DBA

Responsibilities:

• Setup the database in force logging.
• Creation of password file.
• Creation of Standby redo log files.
• Setup parameters of instances.
• Verification the archive mode on primary database.
• Creation of the physical standby database with anything backup of primary database.
• Creation of standby control file.
• Creation of the Standby parameter file.
• Configuration the primary and standby listener files.
• Creation of Oracle net Service Names.
• Creation of standby spfile.
• Creation of standby logfiles
• Startup standby database.
• Functional test.
• Manually application of archived redo log files to standby database.

Tools: Oracle 10g (10.2), HP-UX

Confidential

Technical Leader

Responsibilities:

• Verify the correct setup of the architecture for database installation, and creation on Oracle RAC 10G and iAS.
• Define and implement database backup and recovery strategy using RMAN interfacing with Tivoli Storage Management.
• Validate migration procedures for database instances to new production environments.
• Validation of migration procedures of applications to upgraded application servers.

Tools: Oracle 10g - RAC, Oracle Application Server 10g, RMAN 10g, AIX Ver. 5.3, MS Windows 2003

Confidential

Senior Oracle DBA

Responsibilities:

• Technical Support to recover and restore Oracle database from RMAN-TSM backups.
• Mechanism to validate restored Oracle database.
• Advise to correct Oracle database installation.

Tools: Oracle 10g - RAC, Oracle Application Server 10g, RMAN 10g, AIX Ver. 5.3, MS Windows 2003 1 2, Training and support during exercises., Application of evaluations., Oracle 10g - RAC, Oracle Application Server 10g, RMAN 10g, Linux Red Hat, MS Windows 2003

Confidential

Oracle Instructor

Responsibilities:

• Planning and preparation training for DBA’s and Application Server Administrators.
• Training Juniors DBA.
• Support to Oracle Database Administrators and Oracle Application Server Administrators.

Tools: Oracle 10g - RAC, Oracle Application Server 10g, RMAN 10g, AIX Ver. 5.2, MS Windows 2003 1, TSM Client Ver. 5.2.1 for AIX, TDPO (Tivoli Data Protection for Oracle) Ver. 5.2.1 to AIX, RMAN 10g, AIX Ver. 5.2, MS Windows 2003

Confidential

Senior Oracle DBA

Responsibilities:

• Monitoring logical and physical RMAN backups.
• Backup restoring on development environments.
• Logical database backups to request of users.
• Database and application Server administration on production and non-production environment.
• Database and application Server performance statistics monitoring on production and non-production environments.

Tools: Oracle 10g -RAC, Oracle 10g, Oracle Application Server 10g, Tivoli Storage Manager Server Ver. 5.2, TSM Client Ver. 5.2.1 for AIX, TDPO (Tivoli Data Protection for Oracle) Ver. 5.2.1 to AIX, RMAN 10g, AIX Ver. 5.2, MS Windows 2003 1, Oracle 10g -RAC, Oracle 10g, Oracle Application Server 10g, Tivoli Storage Manager Server Ver. 5.2, TSM Client Ver. 5.2.1 for AIX, TDPO (Tivoli Data Protection for Oracle) Ver. 5.2.1 to AIX, RMAN 10g, AIX Ver. 5.2, MS Windows 2003

Confidential

Senior Oracle DBA

Responsibilities:

• Install TSM 5.2.1 client on AIX 5.2
• Install and setup TDPO 5.2.1 on AIX 5.2
• Enable archiving and flash recovery on 10g clustered and standalone databases
• Tuning of TSM 5.2.1 Server.
• Create scripts for inconsistent backup of complete database using RMAN and TDPO
• Create scripts for consistent backup of complete database
• Recovery test on data files, tablespaces, control files and complete databases
• Definition of applications architecture, including interfaces with other applications
• Coordinate installation and setup of Vitria, Manugistics One View, and Oracle 10g on RAC.
• Install and setup of 10gAS (Business Intelligence and Forms).
• RAC configuration tuning.
• Install and setup Confidential Server on AIX.
• Define version control procedures.
• Install and setup of Confidential client on Windows.

Tools: Oracle 10g -RAC, Oracle Application Server 10g, Confidential, AIX Ver. 5.2 1 2

Confidential .

Senior Oracle DBA

Responsibilities:

• Install and Setup Oracle 9iAS including Business Intelligence and Forms components.
• Setup reports server.
• Applications deployment.
• Install and setup Manugistics (SCPO/DPEE).
• Security application implementation for SCPO y DPEE.
• Database sizing, setup, management, tuning, backup and recovery.
• Automate oracle reports execution from Oracle forms.
• Project management.
• Analysis, design, modeling, and creation of database for referral system.

Tools: Sybase, Power Designer

Confidential

Senior Oracle Database

Responsibilities:

• Oracle 8 Install and setup for internal use.
• Oracle iAS install and setup.
• Define procedures for assignment, use of database, and application server for in­house projects.
• Analysis of new business rules for sales compensation in order to adequately model, and design database.
• Sizing and setup of product database.
• Definition of backup and recovery strategy.
• Analysis and design of data load processes.
• System rollup.
• Project management activities.

Tools: Oracle 8.1.7, Sqlplus, Export / Import, Unix, HP UX -11., Windows 98

Confidential

Technical Leader

Responsibilities:

• Invoice information structure analysis.
• Target database design and sizing. Use of partitioning feature.
• Design process contingency strategic plan.
• Design intensive data load processes.
• Project management providing weekly status reports.
• OPS Database tuning.
• Stored procedures and batch processes monitoring and tuning.
• Create scripts to automate common tasks.
• Databases administration.

Tools: Oracle 8.1.7, Sqlplus, Sql/Loader, Export / Import, Unix, Utlbstat / Utlestat., HP UX -11., Windows 98

Confidential

Oracle DBA

Responsibilities:

• Database sizing, install, set up, administration, maintenance, and support.
• OAS Install, set up, administration, maintenance, and support.
• Data modeling for prototype system.
• Develop stored procedures using Oracle PL/SQL Web Toolkit.
• Database parameter analysis and tuning.
• Multithread Server (MTS) set up and configuration.
• Database maintenance, advising client's DBA on better practices, and automation of common tasks.

Tools: RDBMS Oracle 7.3.4.5.0, Oracle Enterprise Manager, SQL*Loader and Export/Import.

Confidential

Oracle DBA

Responsibilities:

• Database capacity planning, install, set up, administration, maintenance, and support with sizes ranging from 50GB to 900 GB.
• Enterprise Manager install, set up, administration, maintenance and support.
• Definition of backup and recovery strategies, both physical and logical.
• Database tuning, user advise on process parallelism.
• Migration from SQL Server databases.
• Database install, setup, maintenance, and support.
• User and database management.
• Data conversion procedures.
• Define backup procedures, both cold and hot as needed according to business requirements.
• Analysis of Oracle Database and Application Server existing state.
• Generate reorganization and restructuration proposals of all Oracle Database and Application Server installations.
• Installation of Oracle 10g in all environments database (Production, QA and Test, Development).
• Installation and setup of Oracle Application Server 10g in all environments (Production, QA, Test, and Development).
• Installation and configuration of Apache-Proxy.
• Create of Databases for SMNG, SiGEFI, PEF, and SAPM system for all environments.

Confidential

Senior Oracle DBA

Responsibilities:

• Monitoring logical and physical RMAN backups.
• Backup restoring on development environments.
• Database and application Server administration on production and non-production environment.
• Application and interfaces architecture definition.
• Coordinate install and setup of Vitria, Manugistics One View, and Oracle 10G on RAC.
• Installation and setup of Oracle AS 10G (BI and Forms).
• Setup and tuning of RAC. installation and setup of Confidential server on AIX.
• Install and setup of Confidential client on desktop machines.

Confidential

Senior DBA

Responsibilities:

• Research and self-study on open source technology tools to implement database, server applications, and version control system.
• Database Modeling.
• Install, and setup enterprise manager and required repository.
• Assist on security setup for oracle forms menus, using role based security.