Austin,
Texas 78753 e-mail
OBJECTIVE Oracle Database
Administration
development dba - data architect
SUMMARY OF QUALIFICATIONS
·
Database Architect / Senior
Production and Development ORACLE Database Administrator
·
Oracle 10g RAC (Real Applications Cluster) support
·
Programmer
(C/C++; SQL; PL/SQL, Perl, Korn, Bash, DOS, CMD Shell Scripting, Tcl/Tk).
·
UNIX
(Solaris, AIX, HP-UX, Linux) and WINDOWS system administration, including
clustered systems.
·
7
years experience in Healthcare Industry
·
Experience
facilitating large-scale technical innovations, staff development, negotiation
and coordination with many diverse people
TECHNICAL SUMMARY
Current Skills Experience
ORACLE Database
Administration 7 years (7.3.x, 8.0.x, 8.1.x, 9.x, 10g, 10g
RAC)
UNIX System Administration 10 years (RHEL, CentOS, AIX, Solaris, HP-UX)
Windows System
Administration 7 years
SQL Programming 7 years (incl. Optimization, Profiling and
Trace Analysis)
PL/SQL Programming 5 years
C /C++ Programming 6 years (incl. Oracle OCI, OTL)
PERL Programming 2 years (incl. Oracle binding, programming)
KORN Shell Programming 5 years
BASH Shell Programming 5 years
DOS / CMD Shell Programming 6 years
HTML Programming 10 years
ETL tools (Data Junction) 1 year
Technical Documentation 7 years
TCP/IP Networking 5 years
PC Hardware 9 years
PROFESSIONAL EXPERIENCE
AFFILIATED COMPUTER SERVICES
(ACS Government Solutions - Round Rock) 2005-present
SENIOR ORACLE DATABASE ADMINISTRATOR / DATABASE ARCHITECT
· Design and implementation of new product databases
· Initial build script development and maintenance
· Creation and maintenance of test schema
· Conversion of text file (initial load) data (including use of Pervasive Data Junction tool)
· Implementation into production database
·
Database
migration Oracle 8.1.7.4 to 10.2.0.1, including (manual) scripting for
conversion of all database objects.
·
Reverse
engineering of all database objects
·
Schema
comparisons via TOAD
·
Optimization
of long-running processes by parallel processing
·
Support
of Oracle database servers v9.2.x, 10.x, 10g RAC
· Troubleshooting and 2nd-level support for database application issues, including
·
Remote
administration of Unix OS: HP-UX, Solaris, Linux
·
Backup
and recovery via RMAN scripts and troubleshooting
·
Monitoring
of Oracle database; automated error notification
· Implementation of Oracle Transparent Data Encryption (TDE)
· SQL statement analysis and tuning
· Storage analysis and allocation
·
Online
index rebuilds and storage recovery
KEY ACCOMPLISHMENTS
·
Rapidly learned to support extremely complicated distributed
24/7 transaction and reporting system spread over multiple data centers,
multiple UNIX-type OSes, multiple versions of Oracle (including 10g RAC on
Solaris 10), and multiple products, covering a diverse family of technical
problems from hardware issues to performance tuning
·
Developed new product database and participated in all aspects of the
entire development cycle, including developer support, testing and
implementation
·
Performed complex, remote conversion of production database from Oracle
8i to 10g, including hand-scripted recreation of most database objects ,
encryption of a subset of the data via TDE, and verification of new database
after conversion
AFFILIATED COMPUTER SERVICES
(ACS State Healthcare Solutions - Austin) 2001-2005
PRODUCTION AND DEVELOPMENT ORACLE DATABASE ADMINISTRATOR
·
Helped build and support a local software team to reduce
cost, time to market, and significantly increase quality of releases.
·
Standardized database software releases and install
procedures and wrote automation to install releases off-hours.
·
Developed
database software release installation standards based on three years'
experience with releases
·
Developed
three standardized levels of release install automation including hand
installs, SQL controlled installs and fully automated installs, documentation,
templates and examples for each, to cover every install requirement
·
Fully
automated install program (Perl) is platform independent, schedulable, network
aware and Oracle aware, and can be adapted to run almost any processes
including RPC processes
·
Thorough
documentation set, including online documentation provided in the program, MS
Word documentation and HTML documentation suitable for intranet use
·
Supported development, project management and business
analyst teams in addition to supporting high-volume call center, production
database, archives database (data
warehouse), training and multiple test environments.
·
Subject
matter expert for SQL, database installs, database logical and physical
structure, storage allocation
·
Application
development support to programmers on all aspects of database programming
·
Responsible for all software
release installs to test, training and production databases
·
Responsible for maintenance and
improvement of production, archive Oracle database
·
Responsible for data
refreshes for production, development and training databases
·
Responsible for storage
usage of all databases, including rearrangements of the database logical
structure and tables when needed
·
Completely rebuilt Oracle
database system twice, to upgrade Oracle binaries, implement new, higher
performing hardware, rearrange and rework logical structure for better
performance, implement clustering and failover high-availability via Oracle
Fail Safe, implement large SAN
·
Troubleshooting application errors and performance
issues, including process simulation, to isolate and identify issues; implement
solutions to both short and long-term issues; continued refinement of solutions
·
Automated many common tasks including:
·
Backups,
exports and imports, archiving old records and verification of such processes
·
Periodic
trimming of Oracle system log files and removal of old redo log archives
·
Gathering
of cost-based optimizer (CBO) statistics for tables with stale statistics
(performance tuning)
·
Gathering
of both database and operating system metrics relevant to performance
monitoring and tuning
·
Stress
testing of new database installations
·
Patch
sets to Oracle database binaries that lacked installation programs
·
Responsible
for Oracle database security and patching, Oracle database capacity analysis
and planning
·
Wrote
and delivered technical presentations on Oracle database operation (to
colleagues)
·
Documentation
of Oracle database operations and training of backup personnel
·
Added
duties of two development DBAs to regular production DBA tasks as of 4/1/2004
·
Exposure-level
use of Oracle Designer; Design and Data Modeling (typically, I write scripts by
hand)
KEY ACCOMPLISHMENTS
·
Improved success rate of deployed tasks per test failure by more than
150% as part of development team
·
Improved overall productivity of the development lifecycle by over 40%
as part of development team
·
Deployment of over 15 high-demand timesaving software changes as part
of development team
·
Deployment of more than 150 releases in all
·
Drastically reduced unscheduled downtime and improved performance.
·
Automated backups, software release installs, performance tuning and
database metrics gathering
·
Improved backup processes resulting in one-minute (downtime) cold
backups
·
Rebuilt, reorganized and simplified databases, enhancing development,
maintenance and performance
·
Improved database replication practices resulting in on-demand,
one-hour refresh
·
Documented most critical procedures and trained backup staff to run
them.
CYBERPLUS CORPORATION (now
A4 Health Systems, Inc., Austin) 1999-2001
UNIX / ORACLE SYSTEM ADMINISTRATOR
n Primarily
tasked with replication of hospital production Oracle databases to create fresh
test environments
n Developed
software to monitor Oracle database storage usage and warn of impending issues
n Designed
and implemented custom Oracle database extension for hospital customer
n Supported
new product rollout on-site at hospital; troubleshoot user issues and gather
user suggestions
KEY
ACCOMPLISHMENTS
·
Administered Oracle 7.x and 8.x on AIX and HPUX
platforms at multiple hospital emergency room installations.
·
Designed and implemented new custom database for
St. Vincent's Hospital in Indiana.
DECISION CONSULTANTS
INCORPORATED / IBM (Austin) 1998-1999
MEMBER TECHNICAL STAFF / CONSULTANT
n Primarily
tasked with building test program for IBM's new Fast Connect SMB Server running
on AIX OS. Built the successful program
from scratch, including development and implementation of principle test cases.
n Secondary
tasks included participation in test lab procedures: OS installs, network and
application troubleshooting.
n Site
Manager for DCI at IBM; UNIX trainer for DCI staff development courses.
KEY
ACCOMPLISHMENTS
Created a robust and successful
client-server system test program from scratch using a variety of client
components to thoroughly test a server message block (SMB) server running on
AIX.
ADDITIONAL
TENURES
ACTIVE SERVER PAGES
PROGRAMMER, CCMS,
Inc. (Austin) 1998-1998
NETWORK CONTRACTOR, TRAMMELL CROW (Austin) 1997-1998
NETWORK CONTRACTOR, MERRY MAIDS (Austin) 1996-1997
BUSINESS OWNER, HYPER-AD
COMMUNICATIONS (Austin) 1996-PRESENT
BUSINESS
OWNER, TECHNICAL TUTORING (Austin) 1993-1996
INSTRUCTOR OF
CHEMISTRY, AUSTIN COMMUNITY COLLEGE (Austin) 1991-1993
PROCESS
ENGINEER, ADVANCED MICRO DEVICES (Austin) 1990-1991
EDUCATION
Master of Arts, Chemistry
University of Texas, Austin, 1990
Bachelor of Science, Chemical
Engineering
University of Texas, Austin, 1983