Oracle Management
Resume:
jonathan white
North Wales, PA 19454 ********@***.*** 267-***-****
Summary
Senior Database Administrator with over ten years experience building and
maintaining highly available Oracle environments. Strengths include
database design, project management, troubleshooting and group leadership.
Oracle 11g, 10g, 9i, 8i Confio Ignite SQL
Linux OEM PL/SQL
Solaris GRID Control RAC
TOAD Developer Unix Shell
Professional Experience
Navteq/Nokia, Malvern, PA 2009-2012
Sr. Database Administrator, Operations
NAVTEQ is the leading global provider of maps, traffic and location data
(digital location content) enabling navigation, location-based services and
mobile advertising around the world. The database environment consists of
9i, 10g, 11g RAC databases. In this position I am responsible for
supporting development, QA and production databases.
Responsibilities and accomplishments:
. Support of Production OLTP and large OLAP data warehouses (15 TB).
. Built and migrated 9i Probe data warehouse to 11g.
. Setup warehouse RMAN & Networker configuration and backup policies.
. Monthly partition table management.
. Supported Development and Development releases - QA and production.
. Configured EMC storage for asm disk groups.
. Refreshed QA and Development databases using export/import, datapump and
RMAN clone.
. Updated existing Perl script adding management of rotating tablespaces
for partitioned tables. This greatly reduced manual partition
maintenance. Additional scripts updated.
. Installed map releases in QA and production.
. Database creation 10g & 11g (RAC)
. Upgraded Oracle binary and applied patches as needed.
. Participated in 24/7 on call support.
. Advanced compression deployment in data warehouses.
. Grid control server setup and agent update/configuration.
. Extensive Wiki documentation.
GSI Commerce, King of Prussia, PA 2003-2009
Database Administrator, Shared Services (2007 - 2009)
GSI Commerce is one of the leading e-commerce solution providers including
over 60 web stores for companies like Ralph Lauren, Toys R Us, NFL, MLB,
PBS. This position focused on previously ignored internal infrastructure.
In this position I was responsible for the development, test and uat
databases in a fast paced, highly parallel development environment. I
rebuilt the existing databases and set up the necessary shell scripts and
specified operating procedures these environments lacked. Much of my focus
was on process improvement to reduce environmental issues. The number of
databases grew from 8 to over 30 as we built out more environments.
. Managed an SLA for all development databases that included 24/7 support
. Reengineered the web store development database tier to facilitate highly
parallel development while reducing resource requirement from six
databases to one
. Developed and maintained a set of tools to dynamically manage the
development schemas to support the various data model changes in rapid
release cycles
. Managed communications and process of removing depreciated development
schemas
. Eased release process by creating automated reports to identify release-
specific DDL changes
. Served as liaison between Data Architects, Developers (100+), QA and
Production DBAs
. Monitored object accuracy against production
. Helped developers resolve database issues
. Management and maintenance of many data merges from production
. Space analysis and co-ordination of additional storage
. Worked with Release Management and Production DBA's to ensure builds were
properly deployed.
. Deployed and customized production scripts for dev/test/uat environments
. Wrote many monitor scripts - user, tablespace, ASM, object status and
more
. Created automated scripts to move release data from CVS to dev, test, QA
database servers
. Resolved database related application errors
. Provided expertise on Oracle and company-specific data model for
developers
. Additional process enhancements and automation to reduce environmental
issues
. Identified and resolved SQL performance issues using Ignite, Grid
Control, OEM
. Base lined databases to match production using TOAD and custom scripts.
Database Administrator, Production DBA Team (2003 - 2007)
Database support and maintenance in high transactional, 99%+ uptime
environment. Daily monitoring of over 25 production and data warehouse
databases, ranging in size from 100GB to several terabytes. Implemented
release database schema changes as well as database parameter tuning and
security. Shell scripting in Sun and Red Hat environments. 24/7 on call
rotation.
. Resolved production issues, both Oracle and data.
. Migrated databases from 8i to 9i and from Solaris to Linux
. Web store schema migration project
. Managed initial RAC proof of concept project.
. Packaged and bundled database builds to production databases.
. Worked with developers on SQL code review and tuning, packages,
procedures, data integrity.
. Designed company standard perm layer and scripts to apply them.
. Performance analysis.
BeMusic, Inc, Fort Washington, PA 1997-2003
Senior Database Administrator (1999 - 2003)
Database support and maintenance for two of the top internet music retail
sites, CDnow.com (ranked 2nd) and BMGmusic.com (ranked 3rd). 99%+ uptime
availability. Daily monitoring of over 30 production and data warehouse
databases, ranging in size from 1GB to 150GB. Database backend support for
Kana E-mail Management, CA AutoSys and MicroStrategy business applications.
Database backup and restore. Replication using snapshots, transportable
tablespaces, import/export. Worked with and supported developers throughout
the development lifecycle - project and database requirements, SQL code
review and tuning, packages, procedures, data integrity, SQL*Loader.
Implemented project database schema changes as well as database parameter
tuning and security. Shell scripting in a Sun environment. Member of the
Change Management team. 24/7 on call rotation.
Education
Bachelor of Science, Business, Computer Science, Susquehanna University,
Selinsgrove, PA
Technical Training
Oracle Streams (2008), Oracle 10g New Features for Administrators and RAC
Overview (2006),
Oracle 11g Dataguard (2010), Oracle 9i Real Application Clusters R2 Ed2,
Oracle 9i New Features (2002),
Oracle 8i SQL Statement Tuning Workshop (2001), Oracle Performance Tuning
Workshop (1999),
Oracle Network Administration (1999), Oracle Backup & Recovery (1999),
Oracle Database Administration (1999),
Intro to Oracle (1999)
Sun Education Classes: Shell Programming (1999), Fundamentals of Solaris
2.x (1999)
Contact this candidate