SUMMARY:

• 17 years of experience working on the IT field with primarily as database administrator with prime focus on design and architect, installation, implementation, configuration, administration, migration, upgrade, patching, replication, capacity planning, data modelling, security, backup, recovery, optimization and custom business application databases and systems in High availability environment.

• Extensively worked on Database Administrator with a variety of databases (Oracle, MySQL, MS SQL Server)
• Experience as Database Coordinator and Database team leader.
• Worked in many companies in worldwide, working in technology and financial companies as Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential / Confidential, Confidential, Confidential, Confidential, Confidential .
• Strong experience in ORACLE Databases, Oracle large databases, RMAN, RAC, ASM, Dataguard, Streams, Golden Gate, 12c multitenant, CD, PDB and Exadata
• Experience with MS SQL SERVER in all version, cluster replication and Always On configuration
• MS SQL SERVER, Installation and administration, Creating instances Database Cluster and Logins, configuration tuning and queries tuning
• MS SQL SERVER performance tuning and assist to development team to improve performance in SSIS and procedures
• MS SQL SERVER, backup, migration and development strategies
• Experience as DBA leader and Manager
• Knowledge in AWS, Google cloud and Azure
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• I have experience by myself learning and administering in sandbox the following technologies: Confidential cloud, Amazon Web Services, Google Cloud and Teradata
• Now I’m learning by myself all related to Big Data, Data Science, Data governance, Hadoop, Python, Spark, Mapreduce, Yarn, R Leguaje, NoSql and Apache PIG

PROFESSIONAL EXPERIENCE:

Confidential - Pleasanton, CA

DBA Oracle Sr/MySQL/MS SQL Server

Responsibilities:

• MS SQL SERVER cluster active-passive
• MS SQL SERVER always on
• Query tuning and T-SQL script and tuning
• MS SQL SERVER Log shipping replication
• MS SQL SERVER reverse engineering
• Database Performance Tuning
• MS SQL SERVER user creations, database migration, upgrade, tuning and troubleshooting
• MS SQL SERVER security and standardization of database names
• MS SQL SERVER, Installation and administration, Creating instances, Database Cluster and Logins, configuration tuning and queries tuning
• MS SQL SERVER Cloning databases with Detach/attach and Backup/restore
• MS SQL SERVER 2000, 2005, 2008, 2012, 2014 and 2016, creation, installation, upgrade, cloning, troubleshooting
• Administered sql server (all version), solve troubleshooting, upgrade, cloning databases and script execution, some experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• ORACLE Dataguard
• ORACLE Streams
• ORACLE GoldenGate
• ORACLE RAC
• ORACLE RMAN
• ORACLE ASM
• Maintain, monitor, and upgrade the development and production of Oracle databases on RAC and 11g and 12c version to ensure accuracy and quality, as well as producing environment for databases and application servers.
• Maintain, monitor, and upgrade the development and production of Oracle databases on RAC and 11g and 12c version to ensure accuracy and quality, as well as producing environment for databases and application servers.
• Monitor the maintenance, upgrade, and deployment of Java Enterprise Applications on WebLogic servers 11g and 12c versions that use Oracle Business Intelligence Enterprise Edition (OBIEE).
• Produce new scripts for automation tasks on PERL, WLST, and shell (Bash, TCSH).
• Installation and administration of Oracle RAC 9i, 10g, 11g and 12c.
• Oracle Dataguard, installation and configuration
• Oracle 12c stand alone, Rac, CDB and PDB
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MYSQL reverse engineering
• MYSQL Database Performance Tuning
• MYSQL administration with InnoDB and MyIsam engines
• MS SQL SERVER experience:
• ORACLE experience:
• MYSQL experience:

Confidential, Boston, MA

Latin America Database Administrator/Architect ORACLE, SQL SERVER, MySQL

Responsibilities:

• MS SQL SERVER cluster active-passive
• MS SQL SERVER always on
• Query tuning and T-SQL script and tuning
• MS SQL SERVER Log shipping replication
• MS SQL SERVER reverse engineering
• Database Performance Tuning
• MS SQL SERVER user creations, database migration, upgrade, tuning and troubleshooting
• MS SQL SERVER security and standardization of database names
• MS SQL SERVER, Installation and administration, Creating instances, Database Cluster and Logins, configuration tuning and queries tuning
• MS SQL SERVER Cloning databases with Detach/attach and Backup/restore
• MS SQL SERVER 2000, 2005, 2008, 2012, 2014 and 2016, creation, installation, upgrade, cloning, troubleshooting
• Administered sql server (all version), solve troubleshooting, upgrade, cloning databases and script execution, some experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• ORACLE Dataguard
• ORACLE Streams
• ORACLE GoldenGate
• ORACLE RAC
• ORACLE RMAN
• ORACLE ASM
• Maintain, monitor, and upgrade the development and production of Oracle databases on RAC and 11g and 12c version to ensure accuracy and quality, as well as producing environment for databases and application servers.
• Monitor the maintenance, upgrade, and deployment of Java Enterprise Applications on WebLogic servers 11g and 12c versions that use Oracle Business Intelligence Enterprise Edition (OBIEE).
• Produce new scripts for automation tasks on PERL, WLST, and shell (Bash, TCSH).
• Installation and administration of Oracle RAC 9i, 10g, 11g and 12c.
• Oracle Dataguard, installation and configuration
• Oracle 12c stand alone, Rac, CDB and PDB
• Extensively worked on ASM, RMAN, Oracle Enterprise Manager.
• Experience working with Exadata, migration from RAC and Standalone databases to Exadata.
• Exadata monitoring and Exacheck tools, ASM and resource manager
• Exadata and Database performance tuning, and flash cache configuration and compression
• Experience with Oracle on Migration Management, Patch Management, Environment Management, Replication and HA Management, Infrastructure Management, Release and Upgrade management activities
• Perform code optimization through the use of Perl, SQL, PL/SQL, and Bash, Database tuning, DDL and DML, queries performance improvement
• Spearheaded and collaborated with staff in worldwide on upgrading databases from 11g to 12c.
• Data modeling, design and reengineering to create the entity-relation diagram for the database tables with Erwin and other applications
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MYSQL reverse engineering
• MYSQL Database Performance Tuning
• MYSQL administration with InnoDB and MyIsam engines
• MS SQL SERVER experience:
• ORACLE experience:
• MYSQL experience:
• ARCHITECT ROLE, Responsible as architect to migrate all the databases from Latin-American countries, like Costa Rica, Colombia, Peru, Chile and Uruguay and concentrate all the databases into the Mexico Data Centers
• ARCHITECT ROLE, As architect I was Responsible for coordinate and supervise all the Confidential tasks related with databases
• Generate and initiate strategies for backup and recovery on relational database management system (RDBMS).
• ARCHITECT ROLE. As Database Architect I was responsible to decide the best option to install the database, the best SO, Network configuration and database parameters, experience in design and develop the database architecture for OLTP and OLAP databases
• Database support to Latin-American Confidential Branches
• ITIL methodologies, CMDB.

Confidential

Senior ORACLE DBA

Responsibilities:

• Installation and administration of Oracle RAC 9i, 10g, 11g and 12c.
• Oracle GoldenGate, installation and configuration
• Oracle Dataguard, installation and configuration
• Oracle ASM, RMAN, Oracle Enterprise Manager. ITIL methodologies, CMDB
• Perform code optimization through the use of Perl, SQL, PL/SQL, and Bash, Database tuning, DDL and DML, queries performance improvement

Confidential

Infrastructure ARCHITECT/Database ARCHITECT

Responsibilities:

• Architected, designed and lead Project, as a primary database administrator.
• Contract Administration and Tracking System for managing general administration and client services contracts.
• Created documentation about all business process and information flow according to BPMN Specification.
• Also created documentation about the technological infrastructure, Operating system, Application, Database, physical layers and Servers locations.
• Created DER diagrams of database tables using reverse engineering from Oracle, MYSQL and SQL SERVER
• Designed Logical Data Models and conceptualized logical layout to meet the business needs.
• Designed Physical Data Modeling with Entity Relationship using TOAD Data modeler.
• Designed and Implemented Golden Gate replication between OLTP and OLAP schemas on 12c RAC database.
• Designed the database storage layout, schemas on OLTP, OLAP on Superclusters and ZFS storage systems.
• Interface with developers regarding physical database design decisions and PL/SQL coding design.
• Spearhead design, implementation and review of modifications impacting the physical DB design and
• Database architecture.
• Translate logical data models into a physical model, using performance based denormalization.
• Application support with Golden Gate replication on Dev, Test, Pre-Prod and Prod environments.
• Good Exposure to Agile methodologies of Software Development Life Cycle for timed project delivery to gather requirements, design, modelling, planning, risk management, process, quality and testing practices.

Confidential

DBA Oracle Sr/MySQL/MS SQL Server

Responsibilities:

• MS SQL SERVER cluster active-passive
• MS SQL SERVER always on
• Query tuning and T-SQL script and tuning
• MS SQL SERVER Log shipping replication
• MS SQL SERVER reverse engineering
• Database Performance Tuning
• MS SQL SERVER user creations, database migration, upgrade, tuning and troubleshooting
• MS SQL SERVER security and standardization of database names
• MS SQL SERVER, Installation and administration, Creating instances, Database Cluster and Logins, configuration tuning and queries tuning
• MS SQL SERVER Cloning databases with Detach/attach and Backup/restore
• MS SQL SERVER 2000, 2005, 2008, 2012, 2014 and 2016, creation, installation, upgrade, cloning, troubleshooting
• Administered sql server (all version), solve troubleshooting, upgrade, cloning databases and script execution, some experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Experience with MS SQL SERVER in all version, cluster replication, clustering, log shipping for Disaster Recovery (DR) and Always On configuration
• ORACLE Dataguard
• ORACLE Streams
• ORACLE GoldenGate
• ORACLE ODI
• ORACLE RAC
• ORACLE RMAN
• ORACLE ASM
• ORACLE FLEXCUBE
• Installation and administration of Oracle RAC 9i, 10g, 11g and 12c.
• Oracle Dataguard, installation and configuration
• Oracle 12c stand alone, Rac, CDB and PDB
• Perform code optimization through the use of Perl, SQL, PL/SQL, and Bash, Database tuning, DDL and DML, queries performance improvement
• Oracle 10g, 11g, 12c Database administration and troubleshooting
• Oracle RAC, ASM, RMAN Installation and administration.
• Oracle Enterprise Manager troubleshooting.
• Troubleshooting and problems solved regarding Oracle RAC, Oracle GoldenGate and Oracle EM
• Migration of Oracle Database from Oracle RAC 10g to 11g/12c.
• Migration of Oracle Standalone to RAC and from Rac to Standalone,
• Logical and Physical DATAGUARD configuration
• Experience with Oracle on Migration Management, Patch Management, Environment Management, Replication and HA Management, Infrastructure Management, Release and Upgrade management activities
• I have knowledge and some experience in Oracle Data Integrator (ODI) Oracle Master Data Management (MDM), Oracle Utilities Customer Care and Billing (CCB).
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MYSQL reverse engineering
• MYSQL Database Performance Tuning
• MYSQL Database Administrator, compile and install new Databases,
• MYSQL Installation and administration, configuration tuning and queries tuning
• MYSQL administration with InnoDB and MyIsam engines
• MS SQL SERVER experience:
• ORACLE experience:
• MYSQL experience:
• Responsible to teach, supervise and tasks assignment to Jrs DBA.
• Solving issues in Oracle E-Business and Oracle Fusion
• Help and teach all my knowledge to the Jrs DBA
• Perform code optimization through the use of Perl, SQL, PL/SQL, T-SQL and Bash, Database tuning, DDL and DML, queries performance improvement in a variety of databases brands
• Data modeling, design and reengineering to create the entity-relation diagram for the database tables with Erwin
• Migrating database into and from AWS and cloud applications
• As Database Architect I was responsible to decide the best option to install the database, the best SO, Network configuration and database parameters, experience in design and develop the database architecture for OLTP and OLAP databases

Confidential

Technical Database Coordinator/Lead and Database Architect

Responsibilities:

• Responsible for the Installation and administration of the following databases (Oracle, MS SQL Server and MySQL)
• I was the Database Leader and Technical Coordinator
• I was in charge to task assignment and control to team members who manage SYBASE, EDGE PROGRESS, POSTGRE and DB2 databases
• Coordinate the task for database team, task assignment and SLA accomplish
• MS SQL SERVER cluster active-passive
• MS SQL SERVER always on
• Query tuning and T-SQL script and tuning
• MS SQL SERVER Log shipping replication
• MS SQL SERVER reverse engineering
• Database Performance Tuning
• MS SQL SERVER user creations, database migration, upgrade, tuning and troubleshooting
• MS SQL SERVER security and standardization of database names
• MS SQL SERVER, Installation and administration, Creating instances, Database Cluster and Logins, configuration tuning and queries tuning
• MS SQL SERVER Cloning databases with Detach/attach and Backup/restore
• MS SQL SERVER 2000, 2005, 2008, 2012, 2014 and 2016, creation, installation, upgrade, cloning, troubleshooting
• Administered sql server (all version), solve troubleshooting, upgrade, cloning databases and script execution, some experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• ORACLE Dataguard
• ORACLE Streams
• ORACLE GoldenGate
• ORACLE RAC
• ORACLE RMAN
• ORACLE ASM
• Maintain, monitor, and upgrade the development and production of Oracle databases on RAC and 11g and 12c version to ensure accuracy and quality, as well as producing environment for databases and application servers.
• Monitor the maintenance, upgrade, and deployment of Java Enterprise Applications on WebLogic servers 11g and 12c versions that use Oracle Business Intelligence Enterprise Edition (OBIEE).
• Produce new scripts for automation tasks on PERL, WLST, and shell (Bash, TCSH).
• Installation and administration of Oracle RAC 9i, 10g, 11g and 12c.
• Oracle Dataguard, installation and configuration
• Oracle 12c stand alone, Rac, CDB and PDB
• Extensively worked on ASM, RMAN, Oracle Enterprise Manager.
• Experience working with Exadata, migration from RAC and Standalone databases to Exadata.
• Exadata monitoring and Exacheck tools, ASM and resource manager
• Exadata and Database performance tuning, and flash cache configuration and compression
• Experience with Oracle on Migration Management, Patch Management, Environment Management, Replication and HA Management, Infrastructure Management, Release and Upgrade management activities
• Perform code optimization through the use of Perl, SQL, PL/SQL, and Bash, Database tuning, DDL and DML, queries performance improvement
• Spearheaded and collaborated with staff in worldwide on upgrading databases from 11g to 12c.
• Data modeling, design and reengineering to create the entity-relation diagram for the database tables with Erwin and other applications
• Experience configuring CDC process in Oracle streams, Oracle Dataguard and Oracle GoldenGate replication
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MYSQL reverse engineering
• MYSQL Database Performance Tuning
• MYSQL Database Administrator, compile and install new Databases,
• MYSQL Installation and administration, configuration tuning and queries tuning
• MYSQL administration with InnoDB and MyIsam engines
• MS SQL SERVER experience:
• ORACLE experience:
• MYSQL experience:
• Experience as Architect, designing and leading ALWAYS ON implementation project.
• Designed database data layout on CLUSTER for all HA databases.
• Perform code optimization through the use of Perl, SQL, T-SQL and Bash, Database tuning, DDL and DML, queries performance improvement in a variety of databases brands
• Assisted application team in configuring Apache and Tomcat servers and troubleshoot database connectivity.
• Unix (SUN, Confidential AIX, HP-UX), Linux, Windows
• Data modeling, design and reengineering to create the entity-relation diagram for the database tables
• As DATABASE ARCHITECT ROLE I was responsible to decide the best option to install the database, the best SO, Network configuration and database parameters, experience in design and develop the database architecture for OLTP and OLAP databases
• Basic experience working as Application Admin, administering Weblogic, Apache Tomcat, Glassfish, Fusion and IIS

Confidential

Senior ORACLE DBA

Responsibilities:

• ORACLE Dataguard
• ORACLE Streams
• ORACLE GoldenGate
• ORACLE RAC
• ORACLE RMAN
• ORACLE ASM
• Maintain, monitor, and upgrade the development and production of Oracle databases on RAC and 11g and 12c version to ensure accuracy and quality, as well as producing environment for databases and application servers.
• Monitor the maintenance, upgrade, and deployment of Java Enterprise Applications on WebLogic servers 11g and 12c versions that use Oracle Business Intelligence Enterprise Edition (OBIEE).
• Produce new scripts for automation tasks on PERL, WLST, and shell (Bash, TCSH).
• Installation and administration of Oracle RAC 9i, 10g, 11g and 12c.
• Oracle Dataguard, installation and configuration
• Oracle 12c stand alone, Rac, CDB and PDB
• Extensively worked on ASM, RMAN, Oracle Enterprise Manager.
• Experience with Oracle on Migration Management, Patch Management, Environment Management, Replication and HA Management, Infrastructure Management, Release and Upgrade management activities
• Perform code optimization through the use of Perl, SQL, PL/SQL, and Bash, Database tuning, DDL and DML, queries performance improvement
• Spearheaded and collaborated with staff in worldwide on upgrading databases from 11g to 12c.
• Data modeling, design and reengineering to create the entity-relation diagram for the database tables with Erwin and other applications
• Experience configuring CDC process in Oracle streams, Oracle Dataguard and Oracle GoldenGate replication
• Solve issues and troubleshooting about package de-compilation
• Installation and configuration of the following software, Oracle Fusion Middleware, Oracle WebLogic, Amdocs Cramer

Confidential

MS SQL SERVER DBA

Responsibilities:

• MS SQL SERVER cluster active-passive
• MS SQL SERVER always on
• Query tuning and T-SQL script and tuning
• MS SQL SERVER user creations, database migration, upgrade, tuning and troubleshooting
• MS SQL SERVER security and standardization of database names
• MS SQL SERVER, Installation and administration, Creating instances, Database Cluster and Logins, configuration tuning and queries tuning
• MS SQL SERVER Cloning databases with Detach/attach and Backup/restore
• MS SQL SERVER 2000, 2005, 2008, 2012, 2014 and 2016, creation, installation, upgrade, cloning, troubleshooting
• Administered sql server (all version), solve troubleshooting, upgrade, cloning databases and script execution, some experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Sql server, instance and parameters configuration tuning and queries tuning
• Implementation/Execution of Script and Stored Procedure.
• Permissions and roles Management.
• Data modeling and reengineering to create the entity-relation diagram for the database tables
• Database support distributed worldwide and following the work system "Follow the Sun".
• Scheduled jobs to check for SQL Server database optimization, space allocation and index utilization.

Confidential

Senior Oracle DBA/Project Leader

Responsibilities:

• Worked at multiple levels throughout tenure at Solges Consulting as Senior Oracle DBA, project coordinator, project leader and delivered successfully.
• Implementation of Oracle database, Oracle WebLogic, Oracle SSO 10g
• Oracle 9i and 10g database administrator
• Administered and monitored Oracle databases in 10g, 9i, and 8i in Linux, windows and Solaris.
• Cloning Oracle production databases by RMAN onto development and QA databases and regular synchronization.
• Responsible for day-to-day monitoring of the high available database in an OLTP 24x7 environments.
• Extensively worked with Oracle Support raising Service Request and escalations.
• Database tuning, DDL and DML, queries performance improvement
• Installation, upgrade, patching and Administration of Oracle, SQL server and MySQL databases.
• Scheduled regular backup of MySQL production databases and Checking for table corruptions to troubleshoot.
• Experience with 1 years in Oracle Identity Management, SOA Integration and Oracle Data Integrator