Oracle DBA

Resume of GERALYN MARIE R. TORRES

***.******@*****.***

770-***-****(Mobile)

678-***-**** (Home)

Experience Summary

Over 25 years industry experience

** ***** ** ******** ************** experience

Oracle 12c/ 11g / 10g RAC implementation

Oracle High Availability [HAA] Solutions

Oracle 12c Exadata

Oracle Golden Gate Replication

Oracle Data Guard

Disaster Recovery

Oracle Streams / Advanced Queuing

ASM implementation

Oracle XML DB

Oracle APEX

Oracle Enterprise Manager (OEM)

Partitioning, performance tuning, optimization and database maintenance

RMAN Backup and Recovery

Data modeling and design (ERwin)

Oracle XML DB, PL/SQL, SQL*Loader, SQL*Plus,

Applying Oracle patches and design and development in an Oracle environment

Domain knowledge & experience in healthcare, telecom billing, provisioning and network management systems

Current Skills/Tools

.

ORACLE RDBMS 12c, 11g, 10g, 9i, 8i, 8, 7.3, Microsoft Access

Oracle Exadata, ASM

Oracle 9i App Server,

OEM 12c

SQL-Station, SQL Navigator

ERwin Data Modeler

DataGuard

Oracle Designer, Forms, Reports, Discoverer

RMAN

Statspack

SQL*Plus, TOAD, PL/SQL Developer

GoldenGate, Oracle Streams, Shareplex

Scripting - Unix, Perl

Java - (J2EE,JDBC,Weblogic App. Server 6.1), Together v.4.2

Crystal Reports Lotus Notes, Microsoft Word, Excel, PowerPoint, Project

Red Hat Enterprise 6, Sun Solaris 10, HP-UX, IBM-AIX 6.1, Windows

SVN, HP QC, Rational CQ, ClearCase, ccHarvest, PVCS,CVS, Continuus

Hardware

PowerEdge R900, SUN Fire E2900, 480R, T200, M5000, E6900, HP-UX PA-RISC 64-bit, Sun Fire 880, SunW Ultra-Enterprise, GNU/Linux, Fujitsu Superbox running Solaris 2.8, Sun Sparc 250, Sun Sparc 450e, IBM PC, RS/6000 Machine, Indy Silicon Graphics Machine running IRIX 4, Linux x86-64, Power Systems (64-bit running IBM AIX 6.1)

Experience

Project Summary

December 2012 – November 2017

Conduent (formerly Xerox) Healthcare Solutions/Cognizant (Oracle DBA)

Responsibilities:

Database Administrator for the Enterprise State Healthcare production and non-production databases, i.e. Oracle Exadata 12c, 11g and 10g databases (RAC with ASM and non-RAC databases).

Set-up and installed RAC and non-RAC databases.

Upgraded and patched Oracle 10g and 11g databases.

Managed, set-up, troubleshoot and monitored GoldenGate processes.

Set-up DataGuard and alerts for Production RAC ASM databases and monitored the DR replication processes.

Implemented data refreshes from production to non-production environments using Datapump.

Set-up different database environments for the different state healthcare applications on RAC/non-RAC DB’s.

Identified problem areas in application scripts and provided corrective actions through performance tuning optimization.

Set-up and maintained RMAN backups.

Created database scripts used for deployment from non-production to production environments.

Successfully handled deployments on non-production and production environments.

Archived production data to reporting databases.

Monitored and managed databases using OEM 12c and shell scripts.

Worked on capacity planning for new and existing databases in relation to project plans.

Created and managed Unix shell scripts and Perl scripts.

Migrated databases to different environments and data centers.

May 2008 – August 2012

at&t Mobility (Oracle DBA)

Responsibilities:

Application Database Administrator for AT&T Mobility databases for the following applications: CCR, Jackcache, HDS-Gears and Dashboard applications.

RAC implementation.

Migrated existing databases to Oracle RAC using transportable tablespaces.

Installed and monitored GoldenGate and related processes.

Troubleshoot GoldenGate replication issues.

Managed the various development and QA databases for scheduled releases.

Mentored developers in performance tuning issues.

Capacity planning for new databases and existing databases in relation to project plans.

Archived production databases to reporting databases.

Implemented Oracle Transparent Data Encryption (TDE) and Network Encryption.

Refreshed development and QA databases from production.

Database scalability testing using Benchmark Factory.

Implemented the initial CCR set-up through Datapump import.

Optimized database settings.

Participated in enforcing database security and partitioning standard naming-conventions.

Oracle APEX installation and application development using PL/SQL.

Created a team inventory database for all the databases our team supports.

Work with system architects to implement technologies to enhance existing applications.

May 2007 – May 2008

Verizon Wireless (Oracle DBA)

Responsibilities:

Application Database Administrator for Verizon Wireless - RSS (Reseller Solution Suite).

Refreshed development and UAT databases from production.

Archived databases.

Coordinated database-related discussions between team members.

Created database monitoring scripts.

Monitored the RSS databases and the Shareplex table replication.

Documented the existing application database objects.

Implemented database changes for production releases.

Participated in enforcing database security and auditing.

Performed performance tuning of PL/SQL code.

Set-up Oracle Advanced Queueing for the Near-Real Time architecture.

Implemented Oracle Streams as a POC.

April 2005 – May 2007

ACS Government Healthcare Solutions (Oracle DBA)

Responsibilities:

As a DBA, managed state healthcare data warehouses and OLTP databases.

Created, tuned, maintained and monitored DSS databases.

Migrated databases between servers.

Set-up DataGuard.

Upgraded test and production 9i databases to 10g; applied the applicable database patches.

Installed OEM Grid Control repository, OMS and agents and set-up events/jobs and reports.

Improved the efficiency of the DSS load and cut the running time by more than 50%.

Oversaw the weekly loading of data from different states into the data warehouses.

Created and maintained RMAN backups; performed backup and recovery.

Set-up new clients for the data warehouse.

Created and modified Unix scripts and PL/SQL packages.

August 2003 – March 2005

FLEETCOR, THE FLEET CARD COMPANY (Database Developer)

Responsibilities:

Database Developer to Fleetnet.

Created, developed and maintained database objects for Citgo, Getty Reconciliation & Host

Site Mapping projects.

Installed the Oracle Developer Suite and configured Oracle clients.

Created/modified Unix scripts, PL/SQL packages for Reconciliation & Settlement processes.

Designed/developed user interfaces for the Fleetnet and Citgo project using Forms/Reports.

November 2000 – November 2002

CINGULAR WIRELESS

Responsibilities:

Database Administrator for POSabilities (Point of Sale), Cingular Cash Accounting System (CCAS), Prepaid PINS and ClearQuest.

Installed and configured Oracle DB’s on Solaris boxes; set-up replication and standby DB’s.

Upgraded Oracle v.8.1.6.3 to 8.1.7.4; migrated databases to different Unix boxes.

Performed database backup and recovery on the DEV & ClearQuest PROD databases.

Responsible for database performance tuning and maintenance; created UNIX shell scripts.

Configured the networking architecture of client and server machines.

Developed, reviewed, tested and tuned SQL, PL/SQL queries/packages and triggers.

Fixed and tested defects for the Java application.

May 1998 – May 2002

COMPUTER CONSULTING SERVICES CORP (Oracle DBA)

BASF CORP(formerly CYANAMID/AMERICAN HOME PRODUCTS)

May 2000 – October 2000

Responsibilities:

Reported directly to the IT director of North America

Managed, designed and developed Sales and Marketing programs for the Crop Protection Product (CPP) Marketing team.

Performed database analysis and design and modified existing structures.

Created database uploading procedures for the Inventory system.

Created packages/scripts/reports for Inventory/Payment/Complaint Service Request systems.

June 1998 - March 2000

ADVANTICA RESTAURANT GROUP(Denny's restaurants)

Responsibilities:

Designed and developed the Sales Verification System, Universal Account Reconciliation system, Food Cost Variance modules and Operational Reporting modules.

Planned the placement of database files for systems with multiple storage devices.

Created Oracle databases on multi-instance environments.

Configured the Net8 Components on the server and on the client machine.

Performed backup and recovery; set-up table constraints for database integrity.

October 1992 - March 1998

PHILIPPINE NATIONAL OIL COMPANY-ENERGY DEVELOPMENT CORP. (PNOC-EDC)

(Data/Systems Analyst)

Responsibilities:

Administered and developed business and technical applications (CAPEX, Payable, Payable Tax systems, GL and Cost and Expense System).

Installed Oracle databases and set-up table constraints for database integrity.

Performed database modeling and design for optimal performance.

Developed backup and recovery procedures for database information.

Designed and developed PL/SQL scripts and stored procedures and functions.

Education

Bachelors in Chemistry w/ Computer Engineering, Ateneo de Manila Univ., Manila, Philippines

Training and Certification

Oracle 9i Certified Associate – 04/2004

Completed the Oracle 9i OCP training. – 11/2003

Contact this candidate