Donald Anthony " Tony" Johnson

*** **** ******** *****

Chandler, AZ 85225

abj1w0@r.postjobfree.com

Home : (

*** ) 892 - 0282

Cell : ( 480 ) 229 - 6444

Fax : ( 480 ) 497 - 9685

A solutions-oriented Oracle Database Administrator with a proven track

record of success in the analysis, architecture, development, and support

of robust database-driven applications that directly support bottom-line

business needs.

. Over 25 years of experience in architecting, designing and implementing

database platforms to meet the needs of high availability and high volume

driven applications meeting internal and customer based SLA agreements

. Highly adept at promptly and thoroughly mastering new technologies,

architectures and infrastructures

. Experienced in working with locally and remote based management and

development teams working towards common corporate schedules and goals

Professional Experience

LifeLock Inc. Tempe, Az

Senior Database Administrator - January 2010 to

September 2010

Supporting Oracle 10g and 11g/SQL Server 2005/MySQL 5 database environments

responsible for ;

- The upgrade planning and testing of all Oracle environments upgrading

from 10gR2 to 11gR2. This includes standalone instances (running under

VMWare ESX) and RAC clusters

- Re-architecting a MySQL Data Warehouse to run in an Oracle 11gR2

environment

- Upgrading OEM 10g to 11g while adding support for MySQL, SQL Server

and Weblogics servers

- Creating, testing, implementing into Production new database objects

working with Applications Development teams in Tempe,Az, Irvine,CA

and India using an Agile/Scrum based methodology

- Performing proactive and reactive Performance Tuning using Oracle

Enterprise Manager 10g/11g on new and legacy applications thereby

delaying the need for server upgrades due to increased traffic and new

applications

- Performing a DataGuard Proof of Concept test in Oracle 11gR2 for a

planned implementation in Q4 2010

- Providing SQL Server database support in the testing and migration to

Metratech Billing application to replace current interface to PayPal

- Day-to-Day Database Administration tasks such as verifying daily/

weekly Oracle RMAN backups, checking logs for error messages and/or

conditions that need further research, database creation/re-

population/restoration, patch application, submission of Oracle

Service Requests when required

Wells Fargo NA (TekSystems) Chandler, Az

Database Architect - September 2009 To

January 2010

Contract Lead Database Architect responsible for the consolidation, re-

architecting and migration of Wholesale Electronic Payment functionality at

the merged Wells Fargo and Wachovia banks to a new single system to be

implemented in 2010. This architecture will support over $60 billion

dollars of transactions per day and will consist of Red Hat Linux 5, Oracle

11gR2, RAC, DataGuard and either Oracle Streams or GoldenGate to support

multi-location Active-Active databases.

VaultDigital / The Straford Group Chandler, Az

Database Administrator/Architect - March 2009 To

September 2009

Independent Consultant\Contractor working completed the following projects

;

- Remote support of multiple Oracle databases performing normal

administration functions and projects

- Migration of Oracle 8i/9i databases and corresponding applications to

Oracle 10g, ASM and Oracle Enterprise Linux 5

- Migration of a Microsoft Access application to VB.Net and SQL Server

2008

- Installed and configured Oracle Grid Control 10.2.0.5 to control

multiple Oracle instances on multiple servers

- Developed architecture for a new enterprise level Data Warehouse

including all ETL processes to verify and load data from multiple data

sources into Oracle 11g on Oracle Enterprise Linux 5 using PL/SQL

Apollo Group Phoenix, Az

Senior Database Administrator - November 2007 To

February 2009

As a Senior Database Administrator supporting the Online Student (OLS)

databases for the University of Phoenix with over 400,000 students

worldwide I ;

- Provided 24X7 support for 9 multi-terabyte Production Oracle 10g RAC/ASM

clusters running on Oracle Enterprise Linux

- Regular monitoring of all application SQL identifying problem statements

using custom scripts, OEM, SQL Developer then providing solutions to

applications teams to maximize application and platform efficiency

- Provided support for an additional 6 RAC clusters in Test, Development

and QA

- Lead project to implement Partitioning across all systems and migrate

affected data to partitioned tables with minimal downtime

- Lead project reducing Data Warehouse population time from days to hours

- Lead project to architect and migrate a 4 terabyte Data Warehouse to

Oracle 11g and 64 bit Oracle Enterprise Linux

- Architected and built new Production, QA and Test Clusters for the next

generation OLS databases

- Member of team that performed Proof Of Concept testing and Architecture

for Oracle DataGuard Implementation

Intel Corporation Chandler, Az

Senior Database Engineer - February 2006 To

November 2007

As a Senior Database Engineer in the Assembly Test and Technology Division

my Projects/Responsibilities included ;

- Acted as Lead DBA to support the migration of a 6tb DSS database from

Oracle 8.1.4 to Oracle 10gR2. Responsible for all loader and stress testing

activities related to the conversion in addition to making performance

enhancements in the physical schema and recommending changes in

applications to improve performance.

- Qualified Oracle 10gR2 Real Application Clusters (RAC) as the future

platform for all future DSS databases.

- Member of the Core DBA Team leading the migration of 3 separate Oracle

8.1.4 DSS databases into a consolidated 20tb 10 node Oracle 10gR2 RAC

architecture database running on 64 bit Windows 2003. Responsible for the

implementation of and migration to RMAN for all backup and recovery

activities. Responsible for the monitoring and reporting on all data

loading components and performance tuning as required.

- Developed and communicated on a test, daily and weekly basis performance

based statistics and monitoring results to RAC team

- Assisted in the migration of the 1st Production system internally to

running on Oracle RAC.

- Lead DBA responsible for the design and architecture of a site based

Operations DataMart consolidating data from a number of internal systems.

This system will be based on SQL Server 2005 and will use Integration

Services for loading data from other Oracle and SQL Server databases.

- Developed and tested Performance and Functionality Test and Use Cases to

validate configuration and architecture of RAC Cluster

- Lead DBA responsible for maintaining and monitoring Oracle and SQL Server

databases included in the Integrated Testing Environment of ATTD. This

environment includes all software installed in the factory and simulates

station controller activity with data tracing through all layers to the

backend DSS databases.

Trimble Mobile Solutions Chandler, AZ

Database Administrator - July 1999

To February 2006

Database Administrator solely responsible for supporting a 24X7 Wireless

GPS Location Based Fleet Management ASP set of applications and databases.

Architecture consisted of Oracle EE 9.2.0.4.0 running on Windows 2003

Advanced Server and Microsoft Cluster Services with Oracle FailSafe. The

production databases were over 1 terabyte in size and supported over 40

million OLTP and DSS transactions per week in a Dell\EMC hardware based

environment.

Responsibilities included;

- All Logical and physical database designs based on application

requirements and current\future RDBMS features

- Coordinate with local and remote management and development groups to

implement new RDBMS features

- Insure all application and database changes meet requirements to

support internal and external SLA's

- Operation, monitoring, maintenance and upgrading of a 4 level

development and 2 production environments

- Creating and monitoring adherence to established corporate and

divisional database standards and practices

- Training of personnel on database concepts and best practices in

database design, SQL and architecture

- Advanced performance tuning as needed on internal as well as customer

based database instances

- Gathering and analysis of capacity planning metrics and

recommendations based on those metrics for presentation to management

and finance including budget impacts and options

- Assist field based implementation teams in setting up customer based

application and trouble-shooting database issues and problems as

needed

- Support SQL-Server based legacy based applications as required both

internally and at customer sites

- Consultant to marketing\sales organization to review RFP responses for

future database related impact and planning

- Project Lead to migrate the current database architecture to Oracle

10gR2, Red Hat Linux Advanced Server and Real Applications Clusters

(RAC). This included coordination with outside consulting, testing of

current application suite (including functional and stress testing to

24 month sales and growth plans), recommendations for application

modifications to better support the new environment and associated

hardware and software requirements, procurement and setup

- Beta testing of Oracle 10g Release 2 for future usage as part of

10g/RAC project

- Working as part of a team tasked with the consolidation and migration

of multiple production environments into one site with the added scope

of implementing the foundation for a comprehensive DR strategy

- Re-design of current local customer based application database to

better support larger customer loads, volumes and support

- Beta testing of SQL-Server 2005 for possible use on customer based

remote reporting databases

- Project Lead to migrate of all SQL-Server based applications to Oracle

- Evaluation and recommendation for purchase of a selected 3rd party

database environment monitoring environment\toolset

- Conversion of database components to run on Sun Solaris

Motorola Inc. Mesa, AZ

Senior Staff Scientist / Senior Database Administrator November 1997

- July 1999

Was personally responsible for the operation, monitoring and maintenance of

Development, Training and Production Oracle 7/8/8i Servers instances in 11

Wafer Fabrication and Semiconductor manufacturing sites in the Phoenix

metropolitan area.

Accomplishments included;

- The implementation of naming and architecture standards across all

instances/sites, the standardization of tools and architecture across

all platforms and the selection and implementation of an America's

Region wide instance monitoring and capacity planning system.

- Lead of an SPS team that negotiated and implemented a worldwide

licensing and support agreement with Oracle for RDBMS and Application

development tools

- Assisted application development teams in database design,

implementation of new product releases and mentoring other less

experienced domestic and internationally based DBA's.

- Acted as Database architect to implement a common reporting/data

warehouse system using Oracle 8.1.5 and HP/UX 11.

- Part of team which successfully upgraded all Phoenix region factories

to a common HP/UX 10.2/EMC/Oracle 8i Y2K compliant infrastructure

foundation.

- Implemented Platinum Technologies Oracle Toolset (

ProVision/DBVision/TSReorg/Enterprise DBA ) into production usage

across multiple factory sites.

- Acted as Database Consultant to team from China temporary relocated to

Phoenix to learn how to set up and operate a new Wafer Fabrication

being built near Shanghai that they would ultimately staff and

operate.

PCS Health Systems. Scottsdale, AZ

Database Administrator April 1997 - November

1997

Responsible for all data base functions relating to the implementation of

Fourgen Financials, a proprietary Mail Order Pharmacy System, Order Entry

And Fulfillment and Warehouse/Inventory systems. Duties include database

organization, performance tuning and backup / recovery mechanisms utilizing

Informix Online Dynamic Server (Sun 4000, Solaris 2.5.1), Informix

Workgroup Server ( Windows NT/Server 4.0 ) and Microsoft SQL Server 6.5.

CSK Auto Inc. Phoenix, AZ

Database Administrator November 1996 - April

1997

Responsible for all data base functions relating to the implementation of

PeopleSoft Financials including data base organization, performance tuning

and backup / recovery mechanisms utilizing Informix Online Dynamic Server

on HP/UX 10.

Motorola Inc. Phoenix, AZ

Senior Staff Scientist / Software Engineer April 1994 -

November 1996

As part of the RF Semiconductor Products Division (RFSD) Business And

Engineering Systems group was responsible for the design and implementation

of a number of application systems across the Marketing, Planning,

Financial and Manufacturing business areas. Examples of systems implemented

included a Marketing Forecasting System, a Factory Capacity Reservation

System and a Graphical Computer Assisted Manufacturing System prototype.

All applications were implemented working with user teams utilizing the

following hardware/software; Informix Online Dynamic Server ( HP/UX,

Solaris, Windows/NT ), Informix 4GL, Microsoft Access, Windows95 and

Windows/NT Server.

CyCare Systems Inc. Scottsdale, AZ

Data Base Administrator February 1986 -

April 1994

Responsible for the creation and management of a Database Administration

group for one of the nations leading provider of Medical Group Practice

software. This included the development, communication and enforcement of

all data base related standard practices, staff and client education, data

base design (both logical and physical), all required documentation

(database schema, E/R diagrams), implementation and support of internal and

client production and test data base systems. Beyond the technical aspects

of the position, also included were various Sales and Marketing support

functions including pre-sale client visits/presentations, seminar

presentations and industry consultations. Systems supported ranged in size

from single users to those with hundreds of users spread over large

geographical distances. Platforms supported include IBM/ MVS/VSE and HP/UX

with databases supported including TOTAL, SUPRA, IMS/DL1, DB2, Informix

Dynamic Server and Oracle6 Server.

Best Western International Phoenix, AZ

May 1980 - February 1986

Over a 6 year period was promoted to increasingly more responsible

positions supporting the world wide reservations system infrastructure

group. During this time I worked on a number of short and long term

projects either as part of a team or individually. In my last position as

Data Base Administrator was responsible for all data base administration

duties which included the installation/migration of new data base

management system releases, design and implementation of new data base

schema and maintenance and enhancements to all legacy systems. Platforms

supported include IBM/ VM/MVS and TPF with databases supported including

TOTAL, SUPRA.

Phoenix Union High School System Phoenix, AZ

Teacher August 1979 - May 1980

Taught courses in Biology, Health and Physical Education. Extra duties

included Assistant Varsity Football Coach, Head Junior Varsity Basketball

Coach and Freshman Assistant Baseball coach.

Technical Background

Software Skills

Oracle 6/7/8/8i/9i/10g/11g EE/SE/XE, Oracle RAC, Oracle FailSafe for NT,

Oracle Enterprise Manager/GridControl, Oracle PL/SQL, Veritas BackupExec

and NetBackup, Oracle SQL Developer, Microsoft Office(Word, Visio,

Powerpoint, Excel, Access)

Familiar With

VMWare, Oracle DataGuard, Oracle APEX, VB.Net, ASP.Net, JAVA, NetBeans,

JDeveloper, Python, MS Access, Visual Basic, C#, Microsoft Cluster

Server(MSCS), Microsoft SQL Server 2005/2008, MySQL, Informix Dynamic

Server, Informix SE Server, Assembler, CICS, Tuxedo, SyBase SQL Server,

IMS/DL1, DB2, DB2/PE, H/P Image, PeopleSoft Financials, Fourgen Financials,

MANTIS, Informix 4GL, IBM COBOL, MicroFocus COBOL Toolset/Workbench,

Informix NewEra, Oracle Forms, C / C++, CA/Platinum Technologies

ProVision, DBVision, TSReorg, Erwin, Enterprise DBA, and Desktop DBA, Quest

Central/SQL-Navigator, TOAD

Hardware/OS Experience

Oracle Enterprise Linux, RedHat Linux, Windows 2000/2003/2008

Server/Advanced Server, Hewlett/Packard 9000 and HP/UX 9.04/10.2/11, Sun/OS-

Solaris, EMC Clarion/CX/DMX, EMC Navisphere and VisualSAN,

Windows95/98/XP/Vista, IBM VM/MVS/VSE AIX, H/P ServiceGuard, Windows/NT

Server, H/P EVA

Education\Training

Formal Education

Arizona State University - Bachelor of Arts

in Education 1978

Motorola University - Motorola Management

Institute 1995

Honors / Achievements

President Cincom Systems Worldwide Relational Users Group - 1989 - 1990

Conference Organizer - Cincom Relational Users Group Technical Users

Conference - April, 1991 Tucson, AZ

Selected to the Motorola SPS Technical Ladder in May, 1996.

Most Recent Classes

Linux Management for Oracle - 2004

Oracle 9i RAC Administration - 2004

Oracle 10g New Features For Administrators - 2004

Advanced VB.Net Programming Fall 2006

Oracle 10g RAC Implementation and Administration September

2006

Implementing and Administering a SQL Server 2005 Database March

2007

ASP.Net 2.0 Programming Spring 2007

Enterprise ETL with SQL Server 2005 Integration Services June 2007

Oracle 11g Performance Tuning April 2009

Contact this candidate