Merci Moreno Gamboa Email & Phone Number

Provincia De Lima, Peru

- Create physical and logical database models as per the business requirements using Erwin Data Managment.- Provide Database Capacity Planning and performance tuning and release implementation.- Work with Architecture team to develop and articulate improvements on Big Data solutions.- Develop recommendations as to how the business and IT teams can constantly improve their Data Governance and Data Quality practice.- Validate, propose and design technical specifications for data solutions, according to the requirements received from the business.- Build and implement solutions and proof of concept documented according to our internal procedure.- Recommend solutions according to his technical expertise and to the newest technologies available in the market.- Give technical support regarding services and data solutions to the other technical teams in the company.- Technical Support: Formulate policies, procedures, and standard relating to database management, and monitor transaction activity and utilization. - Maintain security and integrity controls. Conduct performance tuning of indexes and databases in general. - Review database design and integration of systems, provide backup recovery and make recommendations regarding enhancements and/or improvements.- Performance Management - Monitor and tune system to achieve optimum performance levels, and provide reports to support metrics collection.- Provide software developers and analyst SQL support and guidance around best practices regarding coding for application performance.

Cincinnati Y Alrededores, Estados Unidos

- Provided on-going performance monitoring and debugging, resulting in a major reduction in downtime due to these issues.- Responsible for implementing and overseeing enterprise database security standards and ensuring compliance with the corporate IT change management process.- Provided architecture design and implemented the all production database replication, backup and contingency recovery strategies for all OLTP Databases in the company.- Working on Oracle database migration Project to AWS Amazon RDS y EC2 instances.- Designed and implemented disaster recovery plan using standby databases.- Assisted developers with writing and tuning SQL queries; performed on-call support and problem resolution 24/7.

Lima Perú

- Administration of Databases on RAC environment.- Administration and Tuning of Database Oracle 11g.- Monitoring performance of Database’s Servers Oracle.- Verify Storage daily on Database’s Servers.- Restore of information according to requirements.- Installing 11g Oracle Database.- To Analyze Tables and Index using statistic on Database.- Optimize top querys, improving response time for reports.- Execution application in Production Environment according to requirements of QA. - Execution of Databases Deployments.- Implementing policies of backup using RMAN.

Lima Perú

Client: La Positiva Seguros Database Administrator Jul 2010 – Oct 2011- Database’s Migration to Oracle 10g.- Administration and Tuning of Database Oracle 10g. - Monitoring performance of Database’s Servers Oracle.- Verify Storage daily on Database’s Servers.- Restore of information according to requirements- Create Partitioned Tables, create new partitions.- Administration and Monitoring Application Server OAS 10g.- Administration Database’s Server Informix - Administration Database’s Server SQL Server.Client: Supermercados Peruano Plaza Vea Database Administrator Jul. 2009 – May 2010- Administration of Databases on RAC environment.- Database’s Migration to Oracle 10g.- Administration and Tuning of Database Oracle 9i and Oracle 10g.- Monitoring performance of Database’s Servers Oracle.- Verify Storage daily on Database’s Servers.- Verify daily on Database’s Servers about alerts using errpt command.- Restore of information according to requirements- Create Partitioned Tables, create new partitions.- To Analyze Tables and Index using statistic on Database.- Optimize top querys, improving response time for reports.- Execution application in Production Environment according to requirements of QA. - Migration from environment AIX – Windows 2003 with Oracle 9 to new Server with Operating System Linux Red Hat and Oracle 10g

Lima - Perú

- Implementation of backup and recovery strategy for Oracle Database 10g. - Data Replication: Implementation commit materialized view and On commit and On Demand Oracle 10g.- High Availability: Installation and Configuration Stand by Database. - Migration from Oracle 9i to Oracle 10g on Sun Solaris platforms 5.10.- Migración de Oracle 9i a Oracle 10g sobre plataforma Linux.- Migration of Oracle 8i to Oracle 10g on Linux platform.- Installation and configuration of Instant Client 10 on Linux platform. - Manage users, privileges and Roles Oracle Database 10g.- Implementation of Audit at Oracle Database 10g.- Control of resources used by Oracle 10g Profiles users. - Optimizing the performance of the Oracle database Oracle 10g. - Restructuring the design of the database.

Big Data - Hadoop Platform

Aws Solution Architect

Máster En Administración De Negocios (Mba) Especializado En Big Data

Bachelor'S Degree, Systems Engineering

Oracle Database 10G Administration: Ocp Successfully