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.
• I have experience in the 3 levels of production support:
• I worked in L1 as Help Desk and On site Technician in Lloyds bank, Carrefour and Ernst & Young
• Worked in L2 level as Data center Operator in companies like HSBC and Santander
• Since 15 years I’ve been working in L3 as Database administrator with Oracle, Sql server and MySQL in a variety of companies
• Expertise in various database administration activities such as instance management, Schema management, Security management, Database migration, Performance Tuning in areas of Applications, Backup implementation, Recovery and Oracle Installation & Configuration, PL/SQL programming.
• Extremely successful at ensuring projects are completed with a high level of quality, are on schedule, and often under budget.
• Installed and configured order software for the team and organization under ebiz off patching and implementing the software in silent mode.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• 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
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Experience working with Exadata, migration from RAC and Standalone databases to Exadata.
• Exadata and Database performance tuning, and flash cache configuration and compression
• Negotiation of oracle software license and Linux licensing and tracking expiry and renewal cut off dates.
• Expert in all ticketing system incident, change Demods under remedy, Jira, identity and access governance and my services.
• Background with RAC and high availability infrastructure, and proficient in all aspects of design testing and implementation of new and innovative technologies.
• Well versed in Backup and Recovery using RMAN, hot backups, database Cloning, Logical Backups using Import/Export using Data Pump.
• Experienced in administering and maintaining diverse versions of Oracle databases and Fusion Middleware and Oracle WebLogic
• Experience installing and administering Oracle Flexcube, a core banking ERP
• Experience in Fusion Middleware and Database migration, upgrade, and implementation.
• Very fluent in creation of Instances, Table spaces, IOT tables/ Partitioned tables/ Indexes, External Tables, Materialized Views, Bitmap Indexes, SQL*Loader, SQL Copy, PLSQL packages, objects, roles etc.
• In - depth knowledge in analyzing performance tools of Oracle like Automatic Workload Repository (AWR), ADDM, TKPROF and TUNING ADVISOR.
• I Have 8 years of experience in DDL to create database from scratch, to modify table and database structure in several database brands
• I have 8 years of experience in DML to manage, administer and modify data and information in several database brands
• I have experience in Database Tuning, like memory, cache and process tuning, and also experience in queries analysis, tuning, performance reports and queries improvement
• Knowledge in Oracle E-Business OBIEE, Weblogic, Fusion, Report and Forms
• Technical documents writing skills with clear and precise manner of adding business values to the company.
• Offshore knowledge transfer with documents and tasks in sequential order periodically communicating monthly tasks, weekly tasks.
• Data modeling, design and reengineering to create the entity-relation diagram for the database tables with Erwin
• Worked in 24/7 production Support as Database Administrator on multi-Terabyte Databases.
• Skilled at making critical decisions and resolving complex business challenges in multicultural environments. Articulate communicator with bilingual proficiency in English and Spanish.
• Really enjoy working in challenging environments, part-time learner, currently doing masters in business administrations and looking forward to grow professionally. Always willing to relocate and travel as way to help me to grow personally, knowing new people and learn new culture.
• Excellent verbal and written communication skills
• ETL process experience, extract data to Excel or CSV file, modified the data and then upload the data with sql Loader or other applications
• Experience and knowledge in ETL tools like Oracle Data Integrator (ODI) and INFORMATICA ETL
• I have experience by myself learning and administering in sandbox the following technologies: IBM 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

TECHNICAL SKILLS:

• ORACLE Dataguard
• ORACLE Streams
• ORACLE GoldenGate
• ORACLE RAC
• ORACLE RMAN
• ORACLE ASM
• ORACLE 8, 9i, 10g, 11g, 12c, creation, installation, upgrade, cloning, troubleshooting
• ORACLE RAC Configuration from 10g, 11g and 12c. troubleshooting
• ORACLE grid control an EM configuration and troubleshooting
• ORACLE Table partitioning, database tuning and patch applying
• ORACLE 12c multitenant, container (CDB) and pluggable database (PDB) configuration
• ORACLE patch applying, database upgrade and downgrade
• ORACLE Database parameters tuning, query tuning and Oracle SQL tuning advisor
• MS SQL SERVER experience: (10 years of experience with ORACLE)
• 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
• MYSQL experience: (8 years of experience with MYSQL)
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MS SQL SERVER reverse engineering
• 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
• BIG DATA experience: ( less than 1 year of experience with NoSQL)
• MONGODB Installation, configuration and administration
• HADOOP Installation, configuration and administration
• Oracle Enterprise Manager, Oracle grid control, Quest Spotlight, Lab128
• Quest Toad for Oracle, Quest Toad for MySQL, Oracle SQL developer, SQL server management studio
• Rman, ASM, Oracle SRVCTL, Oracle CRSCTL, exp/imp, expdp/impdp, SQL loader
• Oracle SQL tuning advisor
• Fusion Middleware, Oracle WebLogic, Amdocs Cramer
• HP-UX, IBM-AIX, Sun Solaris, Linux-Redhat
• XP, 2000, server 2003, server 2008, server 2012, Patch applying
• AS400 (basic)
• PL/SQL, AnsiSQL, T-SQL, 4GL, Korn and Bash shell scripting, Windows PowerShell scripting, Visual Basic, C#, C++
• MS Visio, MS project, PowerPoint, Rational Plan, VMware workstation, VMware VSphere, Oracle virtual box, Apache, Tomcat, Tivoli, Erwin, Putty, WinSCP, FileZilla

PROFESSIONAL WORK EXPERIENCE:

Confidential, Boston, MA

Database Administrator/Architect

Responsibilities:

• 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
• MS SQL SERVER experience:
• 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)
• MYSQL experience:
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MS SQL SERVER reverse engineering
• 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
• 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
• As architect I was Responsible for coordinate and supervise all the IBM tasks related with databases
• Generate and initiate strategies for backup and recovery on relational database management system (RDBMS).
• 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.

Environment: Oracle RAC 9i, 10g, 11g and 12c, Golden Gate Unix Shell Scripting, OID, OEM, TOAD, Dataguard, ASM, RMAN, SQL*Loader, PL/SQL, MS SQL Server, MySQL, SQL Server 2012, Erwin, Jenkins, ITIL, 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.

Environment: Oracle RAC 9i, 10g, 11g and 12c, Oracle GoldenGate, Oracle Dataguard, ASM, RMAN, Oracle Enterprise Manager, BPMN, DER, OLTP, OLAP, ITIL methodologies, CMDB, TOAD, Unix.

Confidential

DBA Oracle Sr/MySQL/MS SQL Server

Responsibilities:

• 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).
• MS SQL SERVER experience:
• 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
• MYSQL experience:
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MS SQL SERVER reverse engineering
• 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
• 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
• Experience and knowledge in ETL tools like Oracle Data Integrator (ODI) and INFORMATICA ETL, configuring data transformation and then upload to Datawareahouse and OLTP databases

Environment: Oracle RAC 10g/11g/12c, ASM, RMAN, Oracle EM, Oracle GoldenGate, Dataguard, MySQL, MS SQL Server 2008/2012, Linux, Windows.

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
• 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
• MS SQL SERVER experience:
• 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)
• MYSQL experience:
• MYSQL performance tuning, troubleshooting
• MYSQL Active - Pasive configuration
• PERCONA software for cluster and backup
• MYSQL Cluster configuration and replication
• MS SQL SERVER reverse engineering
• 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
• Experience as Architect, designing and leading RAC implementation project.
• Designed database data layout on ASM for all HA databases.
• 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
• Assisted application team in configuring Apache and Tomcat servers and troubleshoot database connectivity.
• Unix (SUN, IBM 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
• I have knowledge and some experience in Oracle Data Integrator (ODI) Oracle Master Data Management (MDM), Oracle Utilities Customer Care and Billing (CCB).
• Basic experience working as Application Admin, administering Weblogic, Apache Tomcat, Glassfish, Fusion and IIS

Environment: Oracle RAC 10g/11g, Sybase, Progress, DB2, Oracle, SQL Server, MySQL, Dataguard, Oracle Streams, GoldenGate, Oracle EM, Web Administration (Apache/Tomcat), Unix (SUN, IBM AIX, HP-UX), Linux, Windows.

Confidential

Senior ORACLE DBA

Responsibilities:

• Oracle RAC 10g, 11g, Installation and administration
• RMAN configuration and administration,
• ASM Configuration and administration,
• Database Cloning
• Unix Shell scripts
• Oracle RAC migration from 9i to 11g.
• Database tuning and queries tuning. RMAN
• Solve issues and troubleshooting about package de-compilation
• Installation and configuration of the following software, Oracle Fusion Middleware, Oracle WebLogic, Amdocs Cramer

Environment: Oracle RAC 9i, 10g/11g, RMAN, ASM, Unix Shell Scripts, Oracle Fusion Middleware, Oracle WebLogic, Amdocs Cramer.