Oracle System
Resume:
Irvin O. Perez
** ********** ***** (***) ***-
**79
Norwood, MA 02062
***********@***.***
___________________________________________________________________________
Senior Data Base Administrator
Proficient with SQL databases including Oracle and MS SQL in:
ERP, Distribution, Accounting, Financial Services and Human Resource
Applications.
SOFTWARE
DBMS: ORACLE 7x-10x
MS SQLSERVER 4.21-8.0
SYBASE 4.92-11.03
Application Servers: Weblogic, Oracle Application Server 3.X-9iAS
Allaire's Jrun Tomcat
OS: Sun Solaris 2.41-10, IBM ZLinux, Linux Red Hat AS30,AIX 5.1
HP-UX 11, NT Server 3.11-WIN 2000, DEC-ALPHA 4.0C 4.0D
PROGRAMMING LANGUAGES
PL/SQL, Designer 2000, Oracle Utilities, Oracle Discoverer,
Powerbuilder 3.0-5.0, C, TSQL,Unix Shell Scripting: Perl,Bourne, Korn
& C shells, MSACCESS
ORACLE UTILITIES: Oracle RAC,CRS,Oracle Services
Oracle Streams, AWR infrastructure
RMAN, DATA GUARD, STATSPACK,OEM 1.x-9.x
Designer 2000, Oracle Discoverer,
Oracle Report Server, Oracle Forms
Server
Third Party DB Utilities: Embarcadero's DBArtisan, TOAD
ERP Applications: Oracle 11i EBusiness Suite
PeopleSoft 7.X - 8.X HRMS and
Financials
EXPERTISE
. Datamart and Datawarehouse . PeopleSoft Installation and
Implementation
. Network Infrastructure . Database and Instance Configuration
. Database Performance . Oracle AWR Monitoring
. Oracle Materialized Views . Database Design, logical and physical
. Oracle 11i Administration . Oracle Advanced Queueing
. Oracle RAC Configuration . Standby Databases and DataGuard
. Oracle Streams . Backup and Recovery
____________________________________________________________________________
___
State Street Corporation Westwood, MA 2005-Current
Senior Oracle RAC DBA
Responsible for managing at an enterprise level, application' respective
Oracle Database Management Systems.
Currently responsible for installation of the Oracle software, creation of
databases, RAC and single instance, upgrades, and performance and
monitoring of these.
Projects include:
Installations, Upgrades and Patching
( Install, upgrade and patch various Oracle 9x to 10.2.0.4 of RAC and
single instances
Operating systems include: Linux, Solaris 10, 5.3 and Windows. These
include the upgrade and patching of the Oracle CRS.
. Configuration of one to many Streams environment, which includes the
configuration of the capture, propagation and apply services for the
source and target databases. Sizing the respective memory structures for
the purpose of optimal performance when data is transported between
source(s) and targets.
. Dataguard configuration as a DR solution for all of the bank critical
systems.
. Performance and monitoring of databases with the use of AWR reports and
Oracle advisor utilities.
OXFORD GLOBAL RESOURCES Inc Plymouth,MA 2004 -2005
Senior Oracle-MSSQL-ERP DBA
Responsible for managing at an enterprise level, clients' respective Oracle
and MSSQL Server Database Management Systems.
Currently responsible for the following clients:
Boston College, Benchmark Systems, Sonus Networks, Sulzer Pumps Houston
Inc., Royal Appliance, Grand Circle Travel, Oxford Global Resources Inc.
Projects include:
Installations, Upgrades and Patching
( Install, upgrade and patch various Oracle 8x-9x and Oracle Applications
11.0.x - 11i
in single and multi-tier node environments. Operating systems include: HP-
UX, Linux, Solaris, AIX and Windows.
Application and Database Cloning
( Perform application and database cloning from clients production systems
to development, test and patch environments using Rapid Clone.
( Patching and maintenance of 11.0.3 and 11i Oracle Application
Environments.
( Monitoring and troubleshooting of concurrent managers.
( Provide 24*7 on-call support on a rotating basis.
( Recommend and implement Backup and Recovery solutions using RMAN
technology.
( Monitor and recommend solutions when statspack shows system degradation.
TIME WARNER BOOK GROUP Boston, MA 1999 -
2004
Lead Oracle DBA
Responsible for making sure all Oracle based systems within the
organization stay current with the latest database technology. Lead team of
3 DBAS.
. Implemented 12 Oracle based systems. The systems and projects included:
Datamart and Datawarehouse
. Designed the operational data store that became the data source to the
sales reporting datamart.
. Performed logical and physical dimensional modeling for sales
datamart which optimized retrieval times.
. Wrote programs to transform the data from the operational data store
to the dimensions and fact tables of the datamart.
.. Database currently is running under AIX 5.1 at the OS level and
9i at the database level.
PeopleSoft Installation and Implementation
. Performed installation and configuration for every component of the
PeopleSoft Internet Architecture package: Financials module version 8.4
and version 8.1.8 of PeopleTools.
. The components installed and configured included:
.. Web Server - WebLogic
.. Application Server - Tuxedo 6.5
.. NT Batch Scheduler
.. Unix Batch Scheduler
.. Unix Cobol Compiler
.. Oracle 9i Database on AIX 5.1
. Performed role of PeopleSoft Administrator including:
.. On-going application of bundles and patches, assisting PeopleSoft
developers, monitoring and tuning components within the
architecture.
Network Infrastructure
. Designed and installed the database network infrastructure through
the implementation of Oracle's names server network solution.
. Configuration included a failover strategy which is composed of
multiple names servers running on different hosts.
Disaster Recovery Exercises
. Quarterly recovered all mission critical Oracle based systems in a
disaster recovery scenario in an undisclosed IBM location.
Database Performance . Monitoring Alert System . Resource Capacity
Planning
. Installed and configured Oracle's EM 9i using repository option.
.. The resource capacity tool within OEM Provides management with
metrics on CPU utilization, memory consumption, and disk storage
usage.
Shipments Distribution System
. Challenge: create a seamless backup for a 24/7 OLTP system that
controls shipments of books from the distribution center. Zero downtime
tolerance. Solution: installed and configured Oracle's DataGuard. These
9i databases run on AIX 5.1.
Digital Asset Management System
. Installed and configured a third party vendor web based system which
stores digital information on every book that is published or distributed
from the company's distribution facility.
. System components consisted of Netscape web server, Jrun, and Oracle 9i
running under Solaris 5.8.
Book Ordering Web Based System
. Installed, configured, and wrote monitoring scripts for a 24/7 book
order web based system allowing clients all over the world to place
orders resulting in a 15% increase in sales.
. System uses Oracle Application Server and PL/SQL cartridge process as
the application server. The server runs on its own NT box running Oracle
8i.
In-house OLTP Based Systems
. Provide developers with assistance on coding techniques, index
placing, development and test. Used Oracle Statspack utility package to
troubleshoot.
STATE STREET BANK & TRUST Quincy,MA 1994 to
1999
Database and Systems Administrator
State Street Corporation and Retirement Information Services Department
. Performed database administration, design, system administration and
application development for 401K OLTP app and 401K ADHOC reporting
database.
. Implemented upgrades from 7.3.3 to 8.0.4, Oracle space management,
Oracle security management.
. ADHOC database tasks included the logical, physical design and
implementation of the database. Database used for reporting for plan
administration and external clients like Boeing, Chevron, and Lockheed.
. Client software used is Oracle's Discoverer version 3.1 and the
designer tool used was Designer 2000 version 1.3.2.
. Perl and shell scripting were used for daily backups and for space
monitoring of both systems. Databases run on Unix DEC ALPHA version
4.0.D.
State Street Corporation PeopleSoft Project
. Performed DBA and Unix system support for PeopleSoft in four
environments.
. Support included: development support for programmers. Advised on
efficiency of query tuning, shell scripting, fragmentation, and backups.
State Street Corporation PeopleSoft Project
. Designed and implemented PeopleSoft user reporting database fed
nightly from the current Peoplesoft Enterprise System.
. PeopleSoft runs on Oracle 7.3.3 on Solaris 2.51. The user reporting
database runs under Oracle Workgroup Server on NT 4.0.
Internet State Street Applicant Tracking System
. Worked with a software development company for the implementation of
an internet job applicant tracking system.
. Developed the physical design of the database, the installation and
monitoring. Platform was Oracle Workgroup Server running on NT 4.0.
Corporate Training Administrator System
. Installed, tuned, monitored and maintained corporate training
administrator system used to track employees training and classroom
scheduling for the State Street Institute.
. System runs on NT 4.0 with Oracle workgroup server 7.3.3.
Affirmative Action Management System
. Converted client server application from MS SQL Server 4.21 to Oracle
server 7.3.3 due to logging inefficiencies of MS SQL server.
. Rewrote stored procedures from TSQL to PL/SQL including data
conversion and migration, including redesign of the tables, and indexes.
Employee and Corporate Information System
. Designed and implemented series of MS SQL databases to interface with
the Essbase EIS system.
SmartStream Procurement and Accounts Payable Systems
. Installed product and performed DBA tasks for this enterprise system
which runs on Sybase 11 on Unix Sun Solaris 2.51.
DBMS and OS Upgrades
. Upgraded 10 Oracle servers from versions 7.0 to 7.3.3 to 8.0.4.
. Upgraded 6 MS SQL servers from 4.21 to 6.5.
. Upgraded 5 Sybase servers from 4.92 to 11.03
. Upgraded 3 Sun Servers from 2.4 to 2.51.
. Script writing for database backups, database monitoring and
performance optimization, utilizing shell scripting, sqlplus, server
manager, TSQL.
Prudential Group Investment Management Workstation
. Added screen flow and reporting functionality to existing
workstations for Prudential Group's investment managers.
. Project used Powerbuilder as the font-end and Sybase as the data
repository.
Merrill Lynch Mutual Funds Reporting
. Designed and developed reporting facility to monitor the mutual fund
daily activity using Microsoft Access including data entry screens and
reporting functions.
HOUSTON LIGHTING & POWER Houston, TX 1988 to
1999
SR PROGRAMMER ANALYST
Corporate Licensed Software Distribution Routine
. Created a C language routine for mapping a Novell Netware logical
drive and distributing corporate licensed software by wide-area network.
Organizational Department Viewer
. Designed and developed software allowing online access to HL&P
employee information using Powerbuilder and Microsoft SQL Server,
prototyping using Visual Basic.
Automating Employee Training Records and Scheduling System
. Used CASE tools to analyze and design a training records system for
corporate tracking of employee internal training using ADW.
THE HARTFORD INSURANCE GROUP Hartford, CT 1985 to
1988
PROGRAMMER ANALYST
. Tested, documented, and installed 50+ programs for Personal Lines
System.
(((
EDUCATION
University of Rhode Island, Kingston, RI, BS Management Information
Systems, 1985
LANGUAGES
Write and speak fluent Spanish
ADVANCED TECHNICAL TRAINING
Oracle University DBA Certificate, Datawarehouse Design, Java,
Application Server Administration.
PeopleSoft University PeopleSoft Administrator Certificate
Sybase University DBA Certificate, PowerBuilder
Northeastern University Object Oriented Programming, C++
Sun University Solaris System Administration
Contact this candidate