William  Jones, CCP

Austin, Texas

 wjones1114@sbcglobal.net

Qualifications Profile

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 Experience

Technical 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 Safe

Professional Experience HIGHLIGHTS

SBI GROUP  (Client : DELL COMPUTER), 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 : INTERNAL REVENUE SERVICE ), 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.

Volt (Client : Advanced Micro Devices, Inc.), 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.

Alistia Corporation, 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.

Acxiom Corporation, 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.

BMC Software, 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.

Tennessee Valley Authority (TVA), 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.

Tennessee Valley Authority (TVA), 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 / Training

M.S.     Capella University – Minneapolis, MN

Major: Information Technology

B. S.     Excelsior College – 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 – 2001
  • Oracle 7   Certified Professional DBA – 1998

 

[ Oracle Certified Professional Logo ]