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 and administration on multiple platforms
· Thorough
understanding of, and long experience with: high availability; high-volume transaction
processing; tight service level requirements; large database installations (in the TB
range); pro-active monitoring and reliability engineering; automation; remote
administration of multiple databases, platforms, sites and organizations simultaneously
· Programming in: C/C++; SQL; PL/SQL,
RMAN, Perl, Korn, Bash, DOS, CMD Shell Scripting, Tcl/Tk
· UNIX (Solaris, AIX, HP-UX, Linux) and
WINDOWS system administration, including clustered systems
· 9 years experience in State Government
Business Process Outsourcing Industry
· Experience facilitating enterprise
innovations, staff and process development, coordination of people, negotiations and
situation management (including very challenging and contractually sensitive business
relationships)
TECHNICAL SUMMARY
Current Skills
Experience
ORACLE Database Administration 10 years (7.3.x,
8.0.x, 8.1.x, 9.x, 10g, 10g RAC)
UNIX System Administration 12 years
(RHEL, CentOS, SUSE, AIX, Solaris, HP-UX)
Windows System Administration
12 years
SQL Programming 10 years
(incl. Optimization, Profiling and Trace Analysis)
PL/SQL Programming 6 years
C /C++ Programming 6 years
(incl. Oracle OCI, OTL)
PERL Programming 3 years
(incl. Oracle binding, programming)
Shell Scripting (ksh, bash, DOS, CMD) 10 years
HTML Programming 10 years
ETL tools (e.g. Data Junction) 3 years
Technical Documentation 7 years
TCP/IP Networking 5 years
Reliability engineering / high
availability 9 years
Automation of business processes 9 years
PROFESSIONAL EXPERIENCE
Prelude Systems, Inc. 2009 - Present
SENIOR DEVELOPMENT ORACLE DATABASE
ADMINISTRATOR / DATABASE ARCHITECT
· All database work for re-engineered Texas State Agency applications – ARWOT Project
· Creation, administration, and documentation: Oracle 10g database models and physical databases, UNIX and Windows platforms
· PL/SQL analysis, programming and testing
· Assistance and coaching of java programmers for all database issues
· Sybase to Oracle code and data model translations
· Sybase coding (T-SQL) and analysis
International Business Machines (IBM) / Stellargy Services - Austin 2008-2009
SENIOR ORACLE DATABASE ADMINISTRATOR
· Support of multiple Texas State Agencies – Team for Texas Project
· Creation, administration, documentation, maintenance, patching, troubleshooting and deletion of Oracle 10g RAC databases on UNIX platforms (AIX and Solaris), including storage administration (JBOD, SAN RAID1, SAN RAID5, SAN ASM), backups, exports and imports, monitoring and high availability engineering
· Creation , administration, documentation, maintenance, patching, troubleshooting and deletion of standalone Oracle 10g databases on UNIX platforms (AIX, Solaris, Linux, HP-UX), including storage administration (JBOD, SAN RAID1, SAN RAID5, SAN ASM) backups, exports and imports, monitoring and high availability engineering
· Creation , administration, documentation, maintenance, patching, troubleshooting and deletion of stand alone Oracle 10g databases on Windows platforms backups, exports and imports, monitoring and high availability engineering
· Use of Grid Control to administer multiple databases, including multiple RACs, stand alone databases and ASM instances
· Design, maintenance and troubleshooting of RMAN backup programs including scripts
· Design, maintenance and troubleshooting of complex database-to-database refresh scripts on AIX
· Migration of aging databases to modern hardware and software
· Rapid response to incidents filed by authorized users
· Use of BMC Remedy Incident and Change Management Tool
· Security auditing and remediation
AFFILIATED COMPUTER SERVICES (ACS Government Solutions - Austin) 2005-2008
SENIOR ORACLE DATABASE ADMINISTRATOR /
DATABASE ARCHITECT
· Design and implementation of new product databases
· Initial database build script development and maintenance
· Creation and maintenance of test schema
· Conversion of text file (initial load) data (including use of Pervasive Data Junction ETL tool)
· Creation and implementation of ETL processes using Oracle native tools and Data Junction
· Analysis of conversion data, comparison to specifications, resolution of differences
· 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
·
Use of Peregrine
Enterprise Incident and Change Management Tool
· 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
· Process design, documentation,
delegation to operations personnel
· Data warehouse extract, transform &
load (ETL)
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 databases 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
·
Recruited and trained four new Oracle database administrators as
senior DBA
·
Articulated and documented proper approach to large-scale SAN
storage and database performance
·
Introduced new, graphical monitoring system and presented
business process methods, based on past manufacturing experience, to address reliability
issues and systematically improve process flow and uptime
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 greatly 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 design and
usage of all databases, including database logical structure and tables
·
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
·
Performance and
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
· Exposure-level use of Oracle Designer;
Design and Data Modeling
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 Scriptics, 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 ER installations.
·
Designed and
implemented new custom database for St. Vincent's Hospital in Indiana.
ADDITIONAL TENURES
Member Technical Staff /
Consultant DCI Inc. / IBM (Austin)
1998-1999
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 Enterprises, Inc. (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