SUMMARY

• Oracle Certified Professional 11g/12c OCP, Oracle 11g Certified Master OCM, Oracle RAC Administrator Certified Expert OCE and Oracle 11g Managing Oracle on Linux Certified Expert OCE - DBA with more than 10 years of experience working with Oracle RDBMS 8i, 9i, 10g, 11g and 12c in Real Application Cluster (RAC) and standalone development, test and production environments under Unix and Linux.
• Extensive experience in Installation / Configuration of Oracle Database, Patching and Upgrading to New Releases, RAC configuration and administration, Migration, Exporting and Importing Data and Metadata (Oracle Data Pump), Backup and Recovery (RMAN), Performance Tuning, Table Partitioning, Maintenance Tasks and Support to Incidents.
• Proven experience in Financial, Government and Telecom industries. Team worker, autonomous, organized, proactive and dynamic professional with abilities to establish priorities of tasks and to delegate in an effective way.

TECHNICAL SKILLS

• Languages: SQL, PL/SQL, Transact SQL, HTML, PHP and JavaScript.
• Databases: Oracle RDBMS 8i/9i/10g/11g/12c, DB2, SQL*Server (2005 - 2008), PostgreSQL 9 and MySQL 4/5.
• Database Utilities: Export and Import utilities, Backup and Recovery (RMAN), Real Application cluster (RAC), Oracle Data Guard, Oracle Enterprise Manager 9i/10g/11g, Oracle Enterprise Express 12c and 13c, Automatic Storage Management (ASM), Audit Vault, Oracle Optimizer and Oracle Grid Cloud Control 10g and 11g, Oracle Grid Cloud Control 12c and 13c, SQL*Loader, Oracle Statspack, Oracle Application Server 10g and ADDM, Oracle Virtual Machine OVM 3.1 and 3.2, Oracle Solaris Super Cluster, AWR and ASH, PGAdmin, MySQL Workbench and MySQL Admin.
• O/S: UNIX- LINUX Solaris, AIX, HP-UX, Oracle Linux 5, 6 and 7, Mac OS X, Ubuntu, Fedora, Suse, Centos, Red Hat, Windows 95, 98, 2000 and Windows 10, Server 2003, and 2012, XP, Vista, Windows 7 y Windows 8.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• Management and experience with complex infrastructure and large database environments.
• Installation, configuration, upgrades/rollback, maintenance, backup, restore, monitoring and performance tuning experience with Oracle RDBMS versions 10g, 11g and 12c, MySQL 5.4, 5.5, 5.6 and 5.7 and PostgreSQL 9, and tools including: SQL Developer, TOAD, ASM, Tuning Pack, Cloud Control 13c, Oracle Grid, Database Cluster RAC 11g and 12c, PGAdmin, MySQL Workbench and MySQL Admin.
• Creation, maintenance and management of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures for Development, Testing and Production's environments.
• Impact analysis of any changes made to the database objects or structure and database's capacity planning..
• Monitor and support for local and remote Oracle databases.
• Configuration of thresholds, metrics and alarms for tablespaces, disks, memory and memory.
• Management and administration of Filesystem, Logs and traces.
• Troubleshooting issues related with Oracle databases, applications and development tools, and support for incidents, services required and troubleshooting for different fails of security.
• Creation, configuration and management of profiles and templates to control access to the databases and its objects; and creation and administration of users, roles, privileges and profiles to control access permissions and privileges of users and/or applications.
• Verification and implementation of executions plan on Oracle databases 11g and 12c; and tuning queries, DML statements, data loads, extractions and servers in production environments.
• Creation and configuration of RMAN shell scripts to recover datafiles, tablespaces, pfile and control files and implementation of back up policies to tape for production, and test environments.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and management of Grid Infrastructure and Automatic Storage Management (ASM) 10g, 11g and 12c, troubleshooting on different issues on datafile, tablespaces, and password file drop and add disks to diskgroups, rebalancing and lost disks.
• User, objects local and remote applications on cloud security administration through Active Directory/LDAP and Identity Manager on multiples Oracle databases 11g and 12c and servers as windows UNIX and Linux
• Solve data corruption issues on datafiles, tablespaces and database blocks.
• Installation and configuration and maintenance of Oracle RAC environments.
• Management of cluster services, HAS, CRS, ASM and SCAN.
• Design, implementation and management of Oracle Data warehouse for financial institutions.
• Experience with MySQL 5.7 components including MyISAM, InnoDB storage, Management Server, NDB and cluster Infrastructure.
• Use of Data Guard to synchronize standby databases, Data Guard broker administration and flash back recovery
• Resolve issues for lost archives or gaps on standby.
• Cloning of databases for storage or transportable tablespaces.
• Use of Data Pump, Export and Import (Oracle) and mysqldump and mysqlimport (MySQL) to export/import data and rebuild indexes after migrations.
• Provide technical support to application development teams.
• Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 10.2.0.5 to 11.2.0.4 from Solaris v.10 to Solaris v.11, Oracle RDBMS 11.2.0.4 to 12.2.0.1 from Solaris v.10 to Solaris v.11, Oracle RDBMS 10.2.0.5 to 11.2.0.4 from AIX v.6 to AIX v.7.1 and Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Oracle Linux v.6 to Centos v.6.

Tools/Environment: Oracle RDBMS versions 10g, 11g and 12c, MySQL 5.4, 5.5, 5.6 and 5.7, DB2 version 9.7, Linux Red Hat versions 5, 6 and 7, Oracle Linux Version 6 and 7, Solaris versions 10 and 11, AIX versions 6 and 7, Data Guard 11g and 12c, Data Guard Broker, ASM Automatics Storage Management 10g, 11g and 12c, SQL Developer, TOAD, Tuning Pack, Cloud Control 13, Grid Infrastructure and Cluster RAC 10g, 11g and 12c, PGAdmin, MySQL Workbench and MySQL Admin.

Senior Oracle DBA

Confidential

Responsibilities:

• Installation, configuration and upgrades (patches apply and rollback) experience with Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4, 12.1.0 and 12.2.0 and tools including: TOAD, ASM, Cloud Control 12, Oracle Grid, Database Cluster RAC 11g and 12c, PGAdmin.
• Creation and administration of users, roles, privileges and profiles to control access permissions and privileges of users and/or applications.
• Configuration and implementation of AUDIT security on oracle databases for each transaction.
• Implementation of backup, restore and recovery policies using RMAN scripts.
• Installation and configuration of Oracle RAC 11g and 12c.
• Addition of new nodes on 2 clusters 11g and 12c.
• Database migration from 10 to 11g and 12c using cloning for storage, tablespaces transportable and duplicate database using RMAN.
• Use of Cloud Control to monitor and support several components including: Grid Infrastructure, RDBMS, ASM, Listener, SCAN, RAC, queries, tablespaces and datafiles.
• Generation and maintenance of database documentation and reports on good practices and status of all databases environments.
• Used export import for move data between different database 10g, 11g and 12c
• Restore and recover governmental database for testing and development
• Configuration single and RAC databases in archivelog mode
• 7x24 Support and troubleshooting.
• Installation and configuration of Oracle Data Guard 11.2.0.4 and Data Broker on Oracle Linux 7.

Confidential

Oracle Database Administrator

Responsibilities:

• Tuning of DML's statements on Oracle RDBMS 10g, 11g and 12c.
• Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Oracle Linux v.6 to Centos v.6, PostgreSQL v.9 to Oracle RDBMS 11.2.0.4 from Windows 2008 to Oracle Linux v6.
• Archive log mode's configuration.
• Use of RMAN for backup (hot/cold), restore and recovery and export/import Data Pump.
• Configuration and implementation of standby and test databases.
• Implementation of database security and audit features.
• Table space management, database analysis report and data corruption troubleshooting.
• Configuration and management of database access to Oracle and non-Oracle applications accesing the databases.
• Database health monitoring and Log monitoring in scheduled manner.
• Quarterly backup & recovery test, quarterly offline backup process and quarterly Database log purging activity.
• Application different security patches PSU November on GI 10G, GI 11G and oracle database
• Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Oracle Linux v.6 to Centos v.6, Oracle RDBMS
• Installation, configuration and upgrades (patches apply and rollback) experience with Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4 and 12.1.0 and MySQL 5.4 and 5.5 using tools like: TOAD, ASM, Cloud Control 12.1.0.5, Oracle Grid Infrastructure 11.2.0.4 and 12.1, Database Cluster RAC 11.2.0.3, and 11.2.0.4 and 12.1.0 and SuperCluster 12c with 30 nodes on Solaris 10 and 11, PGAdmin, MySQL Workbench and MySQL Admin.
• Solved issues data corruption in datafiles, controlfile, tablespaces, on databases 10.2.0.5, 11.2.0.4 and 12.1.0
• Configuring the Database in Archive log mode and take backups incremental, full backup and hot backup for different database 10g, 11g, 12c in the following environments TEST,DEVELOPMENT, PRODUCTION using RMAN script and export/import data pump.

Tools: /Environment: Oracle RDBMS 10.2.0.3, 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4 and 12.1.0, Oracle Grid Infrastructure 11.2.0.3, 11.2.0.4 and 12.1, Oracle RAC 11.2.0.3, 11.2.0.4 and 12.1, MySQL 5.4 and 5.5, Oracle Virtualization OVM 3.1, AIX 6.1. and 7.1, Red Hat 5, 6 and 7, Oracle Linux 6 and 7, Windows Server 2008 and 2012, Solaris 10 and 11, Networker 8.1, VMWARE 9,PGAdmin, MySQL Workbench and MySQL Admin.