William Jones, CCPAustin, Texas
**********@*********.*****************
Solutions-oriented Oracle Database Administrator with a record of
success in the administration, development, and support of robust database-driven
applications that directly support bottom-line business needs.
Dynamic database
administration and development, resulting in stable, scalable, and secure
database-driven systems.
Highly adept at promptly and
thoroughly mastering new technologies and adapting to existing corporate
infrastructures, producing results immediately on hire in cross-functional IT
roles.
Willingness
and a proven experience in a 24x7 database support role.
Core
Competencies:
w Broad DBA Experience in a Variety of Business
Environments
w Works Well with Team Members in Assigned
Duties/Projects
w Systems Administration Skills and ExperienceTechnical Background
Platforms:
UNIX
(Solaris, HP-UX, AIX), Linux, Windows (NT/2000/2003), OpenVMS
Databases:
Oracle,
SQL Server, Informix
Languages: UNIX shell scripting, HTML, JavaScript, AWK, Perl, C, Java
Tools: Microsoft Office Suite (Word, Excel, Outlook), Oracle
Enterprise Manager, SQL-Navigator, Toad, Oracle OEM, SQL Server 2000, SAS Enterprise
Guide, Patrol DB, SYNCSORT, Power Designer, Erwin, Visual Source SafeProfessional Experience HIGHLIGHTS (Client : ), Round Rock, TX (2003
2004)DATABASE DEVELOPER
Retained on contract to
serve on cross-functional team throughout development and implementation of
terabyte-sized data warehouse system. Worked closely with Data Architect to
assist in the implementation and configuration of project prototypes in the
Dell pre-installed Oracle 9.2.0.4 RAC environment, while personally authoring
numerous PL/SQL stored procedures to integrate .NET framework and security
solutions with database layer.
Key
Achievements:
Proactively
researched application of Oracle 9i Real Application Clusters (RAC) on Data
Guard logical standby configuration for Linux; identified numerous potential
liabilities in proposed prototype environment.
Assisted
in the planning and creation of numerous schemas to establish a solid
development environment, including development, build, and prototype
configurations.
PLATEAU SYSTEMS,
LTD. ( Client : ), Austin, TX (2003-2003)ORACLE DATABASE ADMINISTRATOR
Retained on short-term
contractual basis to serve as Oracle specialist throughout implementation of Enterprise
Learning Management System (LMS) that was scheduled for release nation wide in
the IRS environment. Performed daily DBA activities, including database backup
and recovery initiatives, testing, and occasional performance monitoring/tuning
of the 3-tier environment.
Key
Achievements:
Assisted
in the migration of SQL and PL/SQL code between various Enterprise LMS database
environments.
Recognized
as Oracle Database Administration resource point of contact, offering
assistance in all day-to-day Oracle administration efforts. (Client : ), Austin, TX (2001 2002)DATABASE ADMINISTRATOR
Retained to augment the DBA
team and assist on key migration and support activities on consultative basis
for publicly traded worldwide manufacturer of microchips and computing
hardware. Collaborated with in-house database engineering team on key migration
initiatives and providing technical assistance as necessary. Conducted
partition management and storage management activities to maintain data
integrity, while maintaining functionality of data replication repair scripts
between domestic and international servers. As part of the DBA team, scheduled
updates to production databases with worldwide customer base to minimize
downtime.
Key
Achievements:
Successfully
maintained day-to-day functionality and reliability of major database
applications supporting core business activities, managing terabyte-sized
production databases.
Volunteered
to participate in 24x7 an on-call support rotation with other DBA team members,
minimizing downtime of databases throughout United States, Far East, and
occasionally Germany., Austin, TX (2000 2001)DATABASE ADMINISTRATOR
Recruited to newly created
position to help support the database administration, automation, and
integration in demanding startup environment. Managed 5 databases in two
cities, connected with database links to drive Java/JSP commercial web
application. Provided ongoing Extract Transform Load (ETL), tuning, as well as
backup and recovery for numerous Oracle 8i databases.
Key
Achievement:
Successfully
designed, programmed, and implemented UNIX shell scripts to automate loading of
new SQL- and Sync Sort-based customer data information into databases on
Solaris and AIX servers., Little
Rock, AR (1998 2000)Database Administrator
Served as the account DBA
responsible for creating (via data models) and subsequently supporting the
terabyte-sized data warehouse for an external customer. Wrote the majority of
the automation processes dealing with monthly data updates and special
maintenance activities dealing with customer business needs.
Key
Achievements:
Implemented
and managed all ETL, tuning, security, upgrades, and support of data warehouse
owned by Discover Financial Services,
containing over 2.5 billion credit card transaction records.
Received
numerous awards recognizing customer relationship management and technical
expertise during data warehouse implementation, including Associate of the
Quarter, nomination for corporate Project Excellence Award, as well as direct
accolades from client.
Coordinated
with the external customer staff in the installation and configuration of SAS,
SAS*Connect, and running the PROC SQL scripts on the Sun Enterprise 6500 UNIX
server that also houses the terabyte-size Oracle data warehouse., Austin, TX (1995
1998)PRODUCT SUPPORT REPRESENTATIVE DBA TOOLS
Offered level-II support to the
national client base for corporate PATROL DB product line, promptly
identifying, isolating, and resolving issues in numerous vendor platforms and
development environments. Collaborated with numerous departments, including
authors, sales, marketing, and international business and technical teams to
gather and assess user needs and determine solutions.
Key
Achievements:
Created
and maintained an internal web site for support team, enabling instant access
to sales, and QA staffs for Patrol DB support., Chattanooga, TN ( 1992 1994)DATABASE ADMINISTRATOR
Provided broad scope of
database development and administration, systems administration, programming,
and support for Oracle systems at government facilities throughout 3-state
region. Diligently performed 24x7 emergency level-II support for 150 databases,
as well as conducting installation, configuration, and administration of backup
and recovery solutions for production servers.
Key
Achievements:
Selected
as one of two employees authorized to create, migrate, and modify Oracle
databases, ensuring consistency of over 100 servers in UNIX, Novell, and OpenVMS
environments.,Drakesboro, KY (1990 1992)PROGRAMMER ANALYST
The sole IT resource at 600-member
fossil fuel power plant facility, fulfilling duties of Systems Administrator,
Novell LAN Administrator, Database Administrator, Programmer, and primary IT
liaison. Directed all functional and administrative IT operations, including
budget preparation and allocation, staff training, in-house application
development, and facility compliance with corporate specifications.
Key
Achievements:
Prepared
and delivered budget proposal leading to over $700,000 award for IT spending. Education
/ TrainingM.S. Minneapolis,
MN
Major: Information TechnologyB. S. Albany, NY
Major: General Studies
Professional Training and Certifications:Oracle 10G Certified Professional DBA 2007 Oracle 9i Certified Professional
DBA 2006 Oracle 8i Certified
Professional DBA 2002 Oracle 8 Certified
Professional DBA 2001Oracle 7 Certified
Professional DBA 1998