Richard M. LaManna
7 Carriage Lane
New Fairfield, Connecticut 06812
Home Phone [Send email to request phone number] 46-7548
SUMMARY:
A certified Oracle 7.x, 8, 8i, 9i and 10g professional with over twelve years
experience as a Database Administrator, focusing on database administration and
information systems. Results oriented professional, with the ability to logically
think through processes in a systematic way as to provide the best solutions.
HARDWARE/SOFTWARE:
Oracle 7.x, 8.x, 8i, 9i, 10gr2 RAC, Oracle Enterprise Manager, Sun Solaris 2.8,
Oracle Forms, HP/UX 11, LINUX, Microsoft Windows NT, Microsoft - SQL Server 7.0,
Sybase 11.3, and IBM AIX. Relational Database Design and Data Modeling, Oracle
Designer, Networking communications, Silverrun Schema Designer, Operating
Systems, Architecture Case and GUI tools, Information Systems, Database
administration and ERWIN case tools. Extensive experience with designing and
implementing Oracle databases, including systems architect, project management,
data warehouse design, implementation and tuning, Oracle SQL tuning, and tuning
of very large Oracle databases.
EXPERIENCE:
IBM GLOBAL SERVICES (contract) 01/05 – Present
Senior Oracle Database Administrator
Oracle 10g Certified Professional for Database Administration
Description:
Administered all phases of database administration in an Oracle 9i and 10.3
environment. Primary responsibilities are the design, maintenance, tuning,
security, and administration of PeopleSoft Financials residing on AIX and LINUX.
Additional responsibilities include supporting an Oracle 10g (10.3) RAC database
for Equifax, Empire Blue Cross, SONY, Discover, and AstraZeneca.
Responsibilities include the following;
Performed tuning and optimization for database server.
· Installing and upgrading Oracle server and application tools.
· Allocating system storage and planning future storage requirements for the
database.
· Creating primary database storage structures once developers have designed an
application.
· Creating primary database objects (tables, views, indexes) once the
application designers have designed an application.
· Modifying the database structure as necessary, from information given by
application developers.
· Enrolling users and maintaining system security.
· Ensuring compliance with Oracle licensing agreements.
· Controlling and monitoring user access to the database.
· Planning for backup and recovery of database information using RMAN.
· Maintaining archived data on appropriate storage devices.
· Contacting Oracle Corporation for technical support.
· Management of object related features.
· Determination of LOB storage options.
· Assistance with RAID configuration.
· Determination of proper index strategy (normal, reverse, IOT, bitmapped)
· Education of Developers in Oracle features and their use.
· Management of distributed environments.
· Management of parallel server and parallel query.
· Determine and manage partitions and sub-partitions.
· Determine proper use of outlines and SQL profiles
· Create, manage and maintain resource groups.
· Create manage and maintain global temporary tables.
· Create and manage materialized views, summaries and snapshots.
· Monitoring and managing the automatic and dynamic sizing parameters.
· Monitoring and managing the automated UNDO
· Monitoring and tuning RAC environments, especially the cluster interconnect.
· Manage and maintain fine grained auditing (HIPPA/SOX requirements)
· Manage and maintain row level security
· Manage and maintain fine grained access controls.
READERS DIGEST 11/03 - 12/04
Lead Oracle Database Administrator
Oracle 9i Certified Professional for Database Administration
Description:
Administered all phases of database administration in an Oracle 9i environment.
Primary responsibility are the design, maintenance, tuning and administration of
our data warehouse residing on Sun Solaris for decision support using Abinitio
ETL software, UNICA client selection, and Oracle Discover reporting applications.
Schema design and modification changes for all database environments using
ERWIN.
Performed tuning and optimization for database and application server.
Secondary responsibilities were for our Financial Systems running on MicroSoft
SQLServer.
Environment: Oracle 9.2.0.4, Oracle 10.1.0.2, Oracle Discover, Sun Solaris 2.8,
Oracle Application Server 11.5, Abinitio ETL, UNICA, MicroSoft SQLServer 7.0,
VERITAS, and Microsoft Windows NT.
GARTNER GROUP 08/02 - 10/03
Lead Oracle Database Administrator/Data Warehouse Administrator
Oracle 8i & 9i Certified Professional for Database Administration
Description:
Administered all phases of database administration in an Oracle 8i and Oracle 9i
environment at Gartner, which provides research and analysis of computer
hardware, software, communications and related information technology
information.
Administered, tuned, installed, and upgraded all versions of Oracle on Sun
Solaris, HP-UX 11 and on Microsoft Windows NT technology.
Primary responsibility is the maintenance and administration of our data
warehouse residing on Sun Solaris for decision support using Brio software
reporting applications, along with the administration of our corporate OLTP (OPS)
databases.
Writing of stored procedures, functions, and triggers included.
Created Bourne and K-Shell UNIX shell scripts using crontab, and SQL*PLUS
scripts for administration purposes.
Loading of Data Warehouse using DataStage ETL. Schema design and modification
changes for all database environments using ERWIN.
Secondary responsibilities were for our PeopleSoft (EnterpriseOne Human Capital
Management) database using Oracle Forms residing on NT technology and Sun
Solaris.
Environment: Siebel, Oracle 8.1.7.4, Oracle 9.2, Oracle Enterprise Manager,
BRIO, CRYSTAL, Oracle Forms, Sun Solaris, AIX, HP-UX, Linux, DataStage ETL,
MicroSoft SQLServer
7.0, and Microsoft Windows NT.
META Group 10/00 - 02/02
Manager of Database Administration
Oracle 8i & 9i Certified Professional for Database Administration
Description:
Administered all phases of database administration in an Oracle 8, Oracle 8i and
Oracle 9i environment at this world-class research and consulting firm focusing
on information technology and business transformation strategies.
Installed, upgraded and tuned all versions of Oracle both on NT and UNIX.
Maintained data warehouse on Sun Solaris for decision support being used by Brio
software reporting applications. Maintained code tables, materialized views and
fact tables being loaded on a daily basis from various sources. Designed
dimensional data models (star schemas), which consisted of both fact and
dimension tables.
Implemented data loading using daily snapshots along with Oracle 9i's external
table (ETL) feature was 100 gigabytes in size.
Aligned data and index segments on various sized tablespaces. Tuned segments so
that chaining and migration was at a minimal.
Maintained 2 Lawson databases, residing on an NT server, each was 50 gigabytes
in size.
Maintained our Internet database, which resided on a Sun Solaris platform.
Managed group of 4 Database Administrators.
Environment: Oracle 8.1.7, Oracle 9.0.1, Sun Solaris 2.6, Oracle Enterprise
Manager, Oracle WebDB, and MicroSoft SQLServer 7.0.
United Rentals 08/99 - 10/00
Senior Database Administrator
Oracle 8i Certified Professional for Database Administration
Description:
Supported database environments for production and development groups using
Oracle 8 and Oracle 8i.
Responsibilities included backup, recovery, monitoring, optimizing database
performance, system security, controlling, monitoring user access, installing and
upgrading Oracle Server tools, and creating database objects.
Environment: Oracle 8.0.6, Oracle 8.1.5, Oracle Enterprise Manager, Oracle
WebDB, MicroSoft SQLServer 7.0 and HP/UX 11.0.
Research Institute of America 04/98 - 08/99
Database Administrator
Oracle7 Certified Professional for Database Administration/Oracle8 Certified
Professional for Database Administration
Description:
Installed and upgraded the Oracle7 and Oracle8 server and application tools,
modified the database structures, created primary database storage structures and
primary objects.
Allocated system storage and planned future storage requirements for the
database, controlled and monitored user access to the database, backed up and
recovered the database, maintained system security, and monitored/optimized
database performance for Data warehouse and OLTP applications.
Environment: Oracle 8.0.3, Oracle 7.3.3, MicroSoft SQLServer 6.5 and Sun
Solaris.
Hyperion Software 11/95 - 04/98
Database Administrator
Description:
Maintained and supported database environment for development group.
Monitored and optimized database performance, back up and recovery, maintained
system security, and allocated system storage structures.
Controlled and monitored user access, creating stored procedures/triggers as
needed, established dump devices, created new tables, indexes, primary keys,
created views, Unix shell scripts and maintained the referential integrity of the
database.
Environment: Oracle 8.0.3, Sybase 11.3, MicroSoft SQL Server 6.5, Informix 4.0,
IBM AIX, Sun Solaris and HP/UX.
Prior work related experience available upon request
EDUCATION:
Western Connecticut State University Danbury, CT.
M.A. Master of Business Information Systems, currently enrolled
B.A. Bachelor of Information Systems
CERTIFICATIONS:
Oracle Certified Professional for Database Administration 7, 8, 8i, 9i, & 10g
Oracle Master in Enterprise Database Administration
Recent Technical Training
Oracle 10g: New Features for Database Administration
Oracle 11g: New Features for Database Administration
|
