Pedro Torres Rodriguez

Senior Architect Oracle DBA

Cel +52 1-55-209*-****

SUMMARY

Highly competent Oracle Certified Professional and Associate with more than 16 years of experience working in the IT industry, 14 + years as an Oracle DBA with strong expertise in Database Architecture, Oracle Database Administration, Database Design and Performance Tuning with Oracle 8i, 9i,10g and 11g on Unix, Linux and Windows platforms. Hands on experience performing backup/recovery security management and numerous database migrations and updates.

Have provided daily support for at least 100+ OLTP databases in a SOX and Non-Sox environments, of databases reside on 80+ different AIX, HP-UX RH Linux, and Solaris servers with a range of 10 gigabytes to 80 terabytes in size. Client portfolio includes but is not limited to Bank of America, Heinz, DHL, AUDI, Allergan, DCP, British American Tobacco, One America, Burger King, Shell among others. SCORECARD

EXPERIENCE

Sr. Oracle Database Administrator Dec 12 – Present T- Systems, México

Involved in all stages of databases including project planning, scheduling, designing, implementating, upgrades and migration.

Defined database implementation strategies for any new and existing applications for Oracle.

Responsible for installing, administrating, configurating and maintaining of Oracle Database versions 8i, 9i,10g and 11g including Real Application Cluster (RAC) and Oracle Dataguard on Unix, Linux and Windows environments.

Provided 24X7 production database administration and support. Skills Years of Experience

Data Modeling and Database Architecture 14+

Support, Maintainance and Troubleshooting 14+

Performance Management 14+

Management of Database security 14+

Database Backup and Recovery 14+

Operation

Systems

Linux

HP-UX

AIX

Microsoft

MS Server 2000,

2003,2008.

Databases

Oracle Database

8i, 9i, 10g, 11g and

12c

SQL Server

(2000,2005)

Software

Toad

Enterprise

Manager

Office Applications

MS Office Suite

Hardware

All Unix servers

(HP-UX, AIX.

Linux, Oracle

Linux)

Mainframe

Education

Bachelor of

Computational

Systems

Engineering,

UNITEC 2002,

México.

Certifications

-OCA Certified,

Oracle Certified

Associate 11gR2

-OCP Oracle

Certified

Professional

11gR2 and 12c

-RAC and Grid

Infrastructure

Certified Expert

11gR2

Pedro Torres Rodriguez

Senior Architect Oracle DBA

Cel +52 1-55-209*-****

Responsible for monitoring, tuning, proactive problem recognition and resolution of database issues.

Planned and implemented replication, archiving and backup/recovery strategies using Dataguard / RMAN

Migrated numerous databases, using Duplicate command / RMAN/ expdp to new data center

Performed upgrades from 10G to 11G and 12c using using different methods like DBUA, command line upgrades (catupgrd.sql), Oracle export/Import, Oracle Datapump, etc.

Responsible for Oracle installation and upgrades.

Planned, coordinated and upgraded database servers from Red Hat 6 to Red Hat 7.

Converted multiple databases from OS file system to ASM.

Configured client’s infrastructure to support operation business.

Supported requirements for new apps versions, including clones Databases and restores.

Implement changes according the Oracle Best Practices to Oracle RAC (complex environment)

Allocated system storage and planned future storage requirements for the database system (Capacity Planning)

Planned database capacity, based on database growth, utilization and forecasts.

Assited in defining database configuration standards related to performance and size of databases.

Achieved 99.999% Databases availability

99.9% of the incidents/changes resolved/completed according the SLA

99.9% of the changes resolved according the SLA, including complex changes with different teams

Implement Transparent Data Encryption to the tablespaces with confidential information

Implement Security policies to users/roles and profiles, include policies password

Ensured database environment meets or exceeds security and compliance requirements.

Implemented work Instructions to the operational team to shutdown/startup the databases.

Created and implemented procedures to create/Delete databases according to Oracle best practices

Provided technical solutions and guidance to client on best practices for database maintenance.

Planned modeled and created databases on test and production environments.

Performance tuning of critical Oracle databases by utilizing tools such ADDM, AWR, RDA, RAC Check, etc, from planning to maintenance stage.

Sr. Oracle Database Administrator Jan 11 – Dec 12

ACS – Affiliated Computer Services Inc. a Xerox Company, México

Senior Oracle DBA of Burger King Account and MGM with high level troubleshooting, and maintenance of complex security, infrastructure and performance issues.

Configured, managed and tuned Oracle databases 8i, 9i,10g and 11g including Real Application Cluster (RAC) and Oracle Dataguard on Unix, Linux and Windows environments.

Database monitoring, troubleshooting and performance tuning in a 24x7 environment.

Recommended strategies for system optimization according to experience and Oracle best practices.

Analyze client business risks and needs; recommend Changes according the Oracle Best Practices.

Planned and executed required database upgrades and migration projects.

Designed backup and recovery plan.

Provided technical solutions and guidance to client on best practices for database maintenance.

Developed Problem/Change Management strategies to solved different issues with clients’ databases.

Supervised Root Cause Analysis reports.

Pedro Torres Rodriguez

Senior Architect Oracle DBA

Cel +52 1-55-209*-****

Achieved highest levels of client satisfaction

Optimized resource allocation and achieved stable SLA (97%)

Performed multiple migrations, 30 using different methods like DBUA, command line upgrades

(catupgrd.sql), Oracle export/Import, Oracle Datapump, etc.

Apply patches installation and configuration in Oracle Database 11g,10g and 9i.

Implement Security policies to users/roles and profiles, include policies password

Ensured database environment meets or exceeds security and compliance requirements.

Provided technical solutions and guidance to client on best practices for database maintenance. Oracle Database Administrator June 03 – Jan 11

Radiomóvil Dipsa S.A de C.V. – Telcel

Supervised all critical Databases.

Installed, administrated, configurated and maintained Oracle Database versions 8i, 9i,10g and 11g including Real Application Cluster (RAC) and Oracle Dataguard

Designed and implemented backup schema for all databases.

Implementated & Managed of RMAN scripts to backup & recover the database, including backup policies according the Service Level Agreement.

Monitored and tuned databases for optimum performance

Proactive monitored the Databases (Health check) .

Implement Security policies to users/roles and profiles, include policies password

Ensured database environment meets or exceeds security and compliance requirements.

Contact this candidate