Resume of GERALYN MARIE R. TORRES
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
Oracle Streams / Advanced Queuing
Oracle XML DB
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
ORACLE RDBMS 12c, 11g, 10g, 9i, 8i, 8, 7.3, Microsoft Access
Oracle Exadata, ASM
Oracle 9i App Server,
SQL-Station, SQL Navigator
ERwin Data Modeler
Oracle Designer, Forms, Reports, Discoverer
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
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)
December 2012 – November 2017
Conduent (formerly Xerox) Healthcare Solutions/Cognizant (Oracle DBA)
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)
Application Database Administrator for AT&T Mobility databases for the following applications: CCR, Jackcache, HDS-Gears and Dashboard applications.
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)
Application Database Administrator for Verizon Wireless - RSS (Reseller Solution Suite).
Refreshed development and UAT databases from production.
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)
As a DBA, managed state healthcare data warehouses and OLTP databases.
Created, tuned, maintained and monitored DSS databases.
Migrated databases between servers.
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)
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
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.18.104.22.168 to 22.214.171.124; 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
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)
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)
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.
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