JOHN R. (RANDY) PATTERSON
40018 THREE FORKS ROAD [Send email to request phone number] 59-9201
MAGNOLIA, TEXAS 77354 JRP_1952@YAHOO.COM
SUMMARY
A highly qualified, results driven information technology professional with
extensive experience in database administration, software installation and
patching, scripting/programming, systems analysis, and technical support.
Possesses a proven ability to automate reporting and back-up processes, improve
database performance, ensure maximum uptime and data integrity, and rapidly solve
problems. A hard-working team player and friendly communicator who enables staff
to meet performance goals, works independently, and consistently exceeds
expectations.
COMPUTER SKILLS
Oracle 7, 8i, 9i and 10g on Linux Red Hat, Solaris and Windows NT.
Oracle 7 and 8i on AIX
Oracle 9i DBA Certified Associate
UNIX shell scripting.
SQL Server 7 and 2000
Statspack, minimum RMAN, RAC, OEM Grid Control and HTML DB
EXPERIENCE
KnowledgeBase Marketing, Houston, TX
Database Administrator, 2005-
Held responsibility for creating and maintaining Oracle databases that support
marketing applications on Sun Solaris Unix. Installed and patched Oracle software
and upgraded databases to 10g. Increased Unix scripting skills. Held
responsibility for database performance, space management and helping users with
SQL based problems and questions.
Created partitioned tables and indexes, bitmap and function based
indexes and materialized views to improve the performance of all databases.
Installed and maintained Oracle HTMLDB.
Installed and maintained OEM 10g Grid Control.
Assisted in the installation of Oracle 10g RAC.
Maintained multiple terabyte databases.
Technical Areas:
Oracle Versions 8i, 9i and 10g
UNIX Solaris 9
Software DBArtisan, Erwin
Anadarko Petroleum, The Woodlands, Texas
Senior Database Administrator, 2001-2005
Held responsibility for creating and maintaining mostly Oracle databases that
supported purchased and in-house written applications on Unix, NT and Linux.
Installed and patched Oracle 8i and 9i software and SQL server software. Held
responsibility for the database performance and helping the user with any Oracle
related questions, including SQL tuning. Increased his Unix scripting skills.
Maintained several SQL Server databases as well. Documented all databases and
procedures.
Created partitioned tables and indexes, bitmap and function based
indexes and materialized views to improve the performance of the Documentum
database.
Implemented Statspack on all production databases and used the reports
to improve their performance.
Performed many database upgrades using import/export and the Oracle
Migration Assistant from Oracle 8i to 9i.
Assisted in the moving of databases from Fort Worth to Houston after
the UPR merger.
Assisted in the creation of the Openview database and took over
maintenance of it afterwards.
Installed Oracle 9i client on numerous NT servers.
Maintained Data Warehouse database, installed Warehouse builder version
9.0.4, built the repository for it and assisted in the move from version 9.0.2.
Wrote multiple Unix scripts, including one to refresh a test database
from production on a nightly basis through a cron job.
Helped migrate multiple databases to other servers to free up old ones
and save the company money.
Learned SQL Server administration and Microsoft Enterprise Manager.
Learned DBArtisan and used it for most DBA tasks.
Installed Oracle 10g on Solaris, built two databases and ran
performance tests.
Technical Areas:
Oracle Versions 7, 8i, 9i and 10g and Warehouse Builder 2.3
UNIX Solaris 8, Linux red Hat and HP-UX
NT Windows NT
Software Documentum, HP Openview, DBArtisan, Quest SQLab and Spotlight and
in-house Data Warehouse
American General Insurance, Houston, Texas
Application Database Administrator, 1999-2001
Monitored databases and helped users with SQL tuning.
Created materialized views to improve performance of budget reports.
Created tables and indexes as requested by the application
programmers.
Assisted in performance tuning of queries.
Upgraded databases from Oracle 7 to 8i using Oracle Migration
Assistant.
Technical Areas:
Oracle Versions 7 and 8i and Enterprise Manager
UNIX AIX
Brown & Root, Houston, Texas
Programmer, 1989-1999
Started out as COBOL programmer maintaining the IMS online and batch financial
system. Made transition to Oracle applications DBA.
Used Microfocus COBOL to debug COBOL programs.
Learned UNIX scripting.
Learned SQL and SQR programming.
Learned basic DBA skills.
Responsible for promotion of new versions of the software to all job
sites.
Technical Areas:
Oracle Versions 7 and 8i and Enterprise Manager
UNIX Sun Solaris
IBM Mainframe
EDUCATION
Lamar University, Beaumont, Texas
Bachelor of Science, Computer Science
PERSONAL
Married; one child.
Enjoys yard work, crossword puzzles, and computer games.
REFERENCES
Carl Wilganowski Supervisor Anadarko Petroleum 832-636-1000
Steve Bering Supervisor Anadarko Petroleum 832-636-1000
Evelyn Wernick Documentum Supervisor Anadarko Petroleum 832-636-2973
Robin Auerbach Data Warehouse Analyst Anadarko Petroleum 832-636-2509
Robert Glaze Database Administrator Anadarko
Petroleum 832-636-3405
Earl Nanney Database Administrator Anadarko
Petroleum 832-636-3310
Raziq Shekha Database Administrator Anadarko
Petroleum 832-636-1250
De De Snavely DB2 DBA
American General 713-831-8187
|
