Andrea M. Johnson
Oracle Certified Professional, 8i
5947 32nd Avenue SW
Seattle, WA 98126
Home: (206) 932-1363
Cell: (206) 351-1156
SUMMARY of QUALIFICATIONS:
- Over 10 years computer technology experience
Macintosh
NextStep
Unix
Windows
Linux
- 9 years overall DBA experience
5 years Oracle Database Administration: Oracle versions 7.32, 8.0, 8i
server installation
server upgrades
data conversion
design
application development
SQL, PL/SQL
MySql
WORK HISTORY:
2005 -
Grand Image, Ltd., Seattle WA
INFORMATION MANAGER
-- Spec, maintain, and purchase all computers, servers, and software.
-- Responsible for Customer Retention Management and Accounting/Inventory databases.
-- Responsible for backup and integrity of company's digital image library; and design and implementation of on-line Digital Image Directory/website.
-- Handle all technology issues within the company; including: computers, internet access, telephone system, website.
-- Continually moving the company through the trials of becoming a digitally-based image production business.
2000 - 2002
Ocentrix, Inc., Seattle WA
DATABASE ADMINISTRATOR
Oracle 8i, Linux/Windows 2000 Server
-Administration of Oracle database for development of web-based, automobile industry dealer management system
-Maintained coordination of different database builds and data on multiple database servers with varying O/S platforms
-Regularly rebuilt database for new test machines
-Installed weekly/nightly database development builds
-Performed QA for initial build application operability; Analyzed build integrity
-Managed data issues required for regular build update cycles; Re-populated tables with different test data per relative test machines
-Ran data queries for developers and product spec team
-Worked with System Administrator to troubleshoot problems with application/database
-Worked with off-shore developer team
-Handled data loads from legacy dealer management systems
-Researched and specified equipment and datacenters for all tiers and product roll-out scenarios
-Worked with engineering team to develop comprehensive backup solution
-Collaborated with outside consultants for machine level application/database server architecture
-Defined and acquired software and hardware for development environment
-Designed and completed MySql-based application (prior to work on more extensive Oracle-based application)
1996 - 2000
RMI.NET (a.k.a. WolfeNet), Seattle WA
DATABASE ADMINISTRATOR
-Managed Perl-based client/service/billing database for Internet Service Provider: Solaris
-Trained staff for database/application use
-Wrote database training manual
-Regularly re-programmed Perl-based database/application to accommodate rapidly changing ISP industry
-Provided extensive accountability data reports
-Instrumental in compiling data necessary for corporate sale of WolfeNet to RMI.NET
-Converted Perl-based database system to Oracle:
* relational model for Oracle database
* implementation of new design to Oracle
* data conversion from existing system to new table design in Oracle
* front-end design based on extensive user input
-Successfully bridged gap between programmer mind-set and real-world end-user requirements
-Completed massive data extraction for conversion of WolfeNet data into nationally consolidated RMI.NET billing database
-NeXT Administrator
-NT Administrator
-PC support:
* specification & acquisition of hardware
* hardware/software troubleshooting & repair
* staff support
1990 - 1996
Winn Devon Art Group, Seattle, WA
NETWORK SUPPORT/FRONT DESK MANAGER
-Administered and implemented expanding internal Macintosh network for art publication industry
-Macintosh equipment acquisition/troubleshooting/repair/upgrades
-Staff training for Macintosh systems
-FileMaker Pro database design/management
-Managed office staff
Andrea M. Johnson
Oracle Certified Professional, 8i
5947 32nd Avenue SW
Seattle, WA 98126
Home: (206) 932-1363
Cell: (206) 351-1156
REFERENCES:
Ray Gurke
IC&C (formerly RMI.NET)
Vice President, NW Region (former)
cell: (206) 334-5297
work: (340) 774-8550
alt. cell: (340) 513-0366
Brian Miller
Multimedia 2000
Chief Financial Officer
(206) 622-5530
Judy Nance
IC&C (formerly RMI.NET)
Operations Manager (former)
(269) 792-6117
Jon Scott
Ocentrix, Inc.
Chief Technology Officer (former)
(360) 303-1005