Oracle DBA

SUMMARY

Oracle 8i Certifi••••• Professional DBA with experience with Oracle 8, 8i and 9i. Member of production DBA team for global semiconductor company with experience in installation, patches and upgrades, database design/creation, data warehousing, database/SQL performance tuning, trouble shooting, backup and recovery, replication, disaster planning and implementation. PeopleSoft Oracle DBA team support for OM, CRM and HRMS.

SOFTWARE,TOOLS AND PLATFORMS
Oracle•••••HP-UX ••••••••••Erwin•••••Exce••••••••••PeopleTools
PeopleSoft•••••Windows NT•••••Stat!•••••Shareplex Sql Analyze
OEM•••••SQLab Vision•••••Test Director RMAN•••••OmniReplicator
Sun Solaris ••••• Unix•••••SQL*Loader Vantive•••••MS Access
Statspack•••••Toad•••••tkprof•••••Spotlight Oracle Gateway
Patrol•••••JVM•••••EXTPROC Metalink BCV
Shell Scripting

PROFESSIONAL EXPERIENCE

April, ••••• Present

Oracle DBA, Fairchild Semiconductor, S. Portland, Maine
Senior Oracle DBA in Sun, HP-UX and Windows production, development and QA environments covering Oracle software installs, upgrades and patches; database design, creation and maintenance; SQL and database performance tuning/trouble shooting; pfile and parameter tuning; Parallel Query Option; backup and recovery; database bug/problem research/resolution; space management and user security; Shareplex replication, Unix shell scripting, •••••x7 on-call Oracle DBA support for all corporate production systems.

Lead Oracle DBA for data warehouse group. Advise data architect on database issues to include schema objects, database object creation/reorgs, SQL tuning, space planning and management, Parallel Query Option implementation and tuning, data load performance improvements, security and permissions, resource management using profiles and the upgrade/patch processes. Database refreshes with RMAN duplicate scripts.
Recogniz•••••, suggest••••• solutions to and correct••••• design flaws including row chaining, index and table space management and layout, use of bitmap indexes, partitioning practices and pfile parameter and SGA tuning.
Lead Oracle DBA for backup and recovery and disaster planning with and without RMAN. Research•••••, test••••• and creat••••• Corporate Oracle backup and recovery standards and proc•••••ures. RMAN performance tuning and trouble shooting. Very experienc••••• in hot and cold backups, real world restores, recoveries and database duplication with RMAN, export/import, rcp and BCV splits.
Performance tuning using Statspack, OEM, Sql Analyze, Quest tools (SQLab Vision, Spotlight) and sql scripts for problem queries; Parallel Query Option and SQL Loader/direct-path insert data loads. Query/session tracing using TKPROF, explain plans and third party tools. SGA tuning and monitoring. Research and solve latch contention and locking problems and shar••••• pool performance and trouble shooting.
Oracle DBA support to third party database applications and their databases including Business Objects, Documentum, Quest Stat and Nettracker
DBA support for PeopleSoft HR production and development databases. Responsible for database maintenance and refreshes, performance troubleshooting, backup and recovery and guidance to developers and managers. Extracting data from MSAccess and loading into Oracle using SQL*loader for employee school data. BCV splits, export/import and RMAN duplicates for database refreshes.
Creat••••• corporate on-call Oracle DBA trouble shooting and day to day proc•••••ures for junior and non-Oracle personnel. Also conduct••••• training sessions for other Informix and Oracle DBAs. Mentor to junior Oracle DBAs.
Research••••• replication technologies and advis••••• management on replication solution. Responsible for testing, implementing, troubleshooting, patching and support of Quest Shareplex replication for the PeopleSoft Order Management group.
Part of Oracle DBA team supporting the implementation/conversion of PeopleSoft Financials on Informix to Oracle and PeopleSoft ••••• Responsible for migrations, database refreshes with BCV splits, rcp and RMAN, SQL tuning, SGA tuning, buffer pool management, parameter changes for sql tuning, Oracle Transparent Gateway for Informix setup and trouble shooting, database troubleshooting and performance tuning. Also responsible for the administration of replication for reporting in the PeopleSoft OM environment using Quest Shareplex.
Lead DBA for managing/improving current database monitoring through the use of sql and shell scripts and BMC Patrol monitoring at the OS and database level.
Net*8 management to include management of tnsnames and ••••• files, Oracle Transparent Gateway for Informix with •••••, external proc•••••ures with EXTPROC, resolving connectivity and permissions issues.
Oracle Performance tuning using session level ••••• traces and the hotsos Profiler by Cary Millsap.

April, ••••• April, •••••

Oracle DBA, Commerce-tv, Braintree, MA
Oracle DBA support for development and production environment for a startup company that develop••••• an application that allow••••• digital TV subscribers to purchase items through their television. Development support includ••••• schema management, creating, altering, dropping and modifying users, privileges, roles, tables, tablespaces and datafiles, software installation and upgrades, space management and capacity planning.
Develop••••• and document••••• system for tracking and implementing numerous database DDL and DML changes and creat••••• application upgrade scripts for development, QA and production. Kept track of various levels of application development with the use of PVCS.
Support••••• large group of developers in a number of databases. Manag••••• schemas, schema refreshes, permissions, roles, security and PL/SQL code review for tuning purposes.
Manag••••• user security and permissions to include roles, system permissions, research••••• and test••••• Fine Grain••••• Access Control for row level security.
Database SGA and pfile parameter tuning for performance in support of JVM and OLTP operations.
Net8 troubleshooting for SQL*PLUS, tnsnames and listener issues and provid••••• database and troubleshooting support to Oracle developers for consistent database availability.
Responsible for creating and maintaining schema ER diagrams using Erwin for numerous application releases and upgrades and updating the data dictionary.
Assist••••• in design of tablespace, index and table layout on disk array for •••••+GB OLTP production and development databases.
Familiar with Lakeview Replication software, OmniReplicator and replication methodology. Assist••••• with development and production support, design and troubleshooting of replication using OmniReplicator.
Numerous Oracle server/client software installs and upgrades of databases from ••••• to ••••• on both Unix Sun Solaris ••••• and Windows NT platforms.
Oracle Java Virtual Machine (JVM) and XML parser support, troubleshooting and upgrades.
Support••••• developers, production DBAs with NLS issues and migrating databases to UTF•••••


•••••UCATION and CERTIFICATIONS

Oracle 8i Certifi••••• Professional DBA
Currently taking classes with Aspen University towards MS in Information Technology
BA in Criminology from University of Southern Maine, •••••
Graduate of Clark Universitys ••••• hour Oracle DBA Certification Course, ••••• ••••• Woburn, MA
Sun Solaris Introduction to Unix training, Boston, MA (5/•••••)
Optimizing Oracle Performance Course taught by Cary Millsap March •••••

Additional Information:

March, ••••• April, •••••

Police Officer/Detective, Wells PD, Wells, Maine