Consultant Profile

• Profile Summary: Senior consultant with over 25 years experience, skilled in developing and executing system migration strategies and enterprise level backup and disaster recovery (DR) plans. Gary also has experience administering and supporting large complex environments in production, development, test and support environments.
• Certifications: Oracle Certified Professional (OCP) - Database Administrator - Oracle 9i DBA; Oracle 8i DBA
• Security Clearance: US citizen with Top Secret (TS/SSBI) and ATF clearance

Core Competencies

• Databases: Oracle database (11gR2, 10gR2, 9i, 8i, 7), Oracle Times Ten in-memory database 11g, MS SQL Server 2005, MS SQL Server 2000, MS SQL Server 7.0, Adabas
• Oracle Applications: Oracle VM, Oracle database 9i/10g/11g Real Application Clusters (RAC), Oracle Recovery Manager (RMAN), Oracle Data Guard, Oracle Enterprise Manager Grid Control, Oracle Enterprise Manager Database Console, Oracle Application Server, Quest SharePlex Replication.
• Other Applications / Utilities: Quest Benchmark Factory, SwingBench load generator, Oracle OSWatcher, Oracle SQL Developer, WinSCP (SFTP client), PuTTY (Secure telnet client), VNC/VNC Server, Microsoft Office Suite, Lotus Notes, Microsoft Remote Desktop / Terminal Services.
• Operating Systems: Linux (Oracle Enterprise Linux, Red Hat, SuSE), AIX, Solaris, HP-UX, Tru64, Windows (all versions), MVS/XA and MVS/ESA with TSO/ISPF and CICS, VM/XA with CMS, VAX/VMS
• Storage Systems: EMC, IBM and HP Storage Arrays
• Programming Languages: Oracle SQL, SQLPlus, PL/SQL, Unix Shell scripting, Perl, Windows batch scripting, Window Script Host, VBScript, Natural v2, COBOL, MVS JCL, Dialog Manager, Rexx / Xedit (VM/XA)
• Publications / Technical Papers:
• Oracle 10g Performance on Windows Server 2008 Hyper-V Virtual Machine 2008
• Installing and Configuring Enterprise Manager 10g Release 2 Grid Control on the Linux Platform 2006

Career History

Confidential, Austin, TX Senior Oracle Consultant (Dec 2005 - Present)

Senior Oracle Consultant providing expertise in Oracle 9i, 10g and 11g architecture design and deployment, data and application migrations and upgrades. Responsible for database administration, OS system administration, application workload testing, integration, data migration and general problem solving. Conduct planning and architecture assessments on backup and disaster recovery solutions including RMAN, Oracle Data Guard and Quest SharePlex. Possess extensive expertise in the implementation of Oracle 11g, 10g and 9i Real Application Clusters (RAC) solutions on both Unix/Linux and Windows platforms. Gary has performed more than 40 Oracle RAC implementations with corresponding data migration to the new solution and more than 20 implementations of the Oracle Data Guard disaster recovery solution in Oracle 10g and 11g RAC environments.

Confidential, Consulting Engagement Highlights

This project consists of a review of a previously completed AT & T Architecture Assessment and performance analysis and tuning of AT & T's current Oracle database infrastructure and includes two phases. Phase I is a high level analysis of AT & T's Architecture Assessment with focus on future growth. In Phase II, solutions to optimize existing database systems and improve database system scalability were provided.

Provided ongoing remote DBA support for the implementation of:

• Oracle 10g R2 (10.2.0.2) RAC 2-node on RHEL 4.4 64-bit with ASM supporting (4) databases
• Oracle Clustered File System (OCFS2)
• Data Guard to a 10gR2 Single Node on RHEL 4.4 64-bit with EXT3 filesystems
• Upgraded databases to 10.2.0.4
• Updated the installed database character set
• Added a 3rd RAC node to the production cluster for all 4 databases

Provided expertise in deployment of Oracle 11g RAC database systems on the AIX platform, Oracle patching, upgrades and maintenance. Responsible for planning a data center move, including the installation and configuration of Oracle Data Guard for multiple multi-terabyte RAC databases at the new data center. Developed the migration plan and assisted with the migration of applications and 2 multi-terabyte RAC standby databases to the new data center.

• Performed more than 40 implementations of Oracle Real Application Clusters database (11g, 10g, 9i) using ASM and/or clustered file systems for a variety of private sector and government clients on Unix/Linux and Windows OS platforms.
• Most RAC implementations include the installation of the Linux or Windows OS including the configuration / customization of the OS, network and shared storage for the Oracle environment
• Some engagements included database data migration to the new RAC solution.
• Some engagements included the configuration of a corresponding disaster recovery solution using Oracle Data Guard.
• For selected clients, an assessment of the existing RAC environment was provided to validate the configuration against industry and PTC "best practices".

• Feb 2008 - Oracle 11g New Features - 11g Release 1
• Apr 2009 - Oracle 11g New Features - 11g Release 2 (11.2.0.1)
• Nov 2009 - Oracle Times Ten In-Memory Database 11g
• Mar 2010 - Oracle 11g New Features - 11g Release 2 (11.2.0.2)
• Aug 2010 - Oracle 11g R2 (11.2.0.2) RAC Administration - Labs only
• The PTC lab environment consists of
• Oracle VM (OVM) v2.2
• Oracle Enterprise Linux (OEL) 5 64-bit
• Oracle 11g R2 with ASM, RAC, and ACFS
• Oracle Enterprise Manager Grid Control 10g Release 5

Provided ongoing remotedatabase administration support for multiple Oracle 8i, Oracle 9i and Oracle 10g environments at the client's facilities in Pasadena, Texas and Amsterdam, The Netherlands. Responsibilities included instance creation and configuration; instance performance monitoring; table space utilization; verification and validation of database backups, and server space utilization monitoring. Prepared and delivered detailed, instructive documentation for Administration and non-DBA staff regarding the Oracle database architecture, troubleshooting and maintenance activities.

• Member of the Software Development Engineering DBA team (East Coast) providing Oracle database administration and infrastructure support for application software development, quality assurance testing and production environment simulation exercises in a multi-OS Unix (Tru64, HP-UX and Solaris) environment featuring single node and multi-node clustered database server configurations using Oracle 9i RAC.

• Lone on-site Oracle resource for a 24x7 web-based, real-time OLTP production application utilizing Oracle 8i and OAS 4.0.8 in a Solaris, Linux and NT / Win2K environment at the Harris County Toll Road Authority (HCTRA) in Houston, TX.

• Infrastructure support DBA team member providing support for 150+ Oracle 8i instances in a multi-platform, multi-OS Unix (Solaris, AIX) and Windows (NT / Win2K) environment. Implemented an enterprise-wide Oracle backup and recovery solution using a combination of BMC's SQLBackTrack for production and internally developed Unix shell and VBScript scripts on non-production servers.

• Performed numerous Oracle enterprise product installations, upgrades and instance creation and configuration for Oracle 7 / 8 / 8i on Solaris, AIX, Tru64 and NT / Win2K platforms. Provided database administration support for SQL *Server 7 and MS Access on the NT / Win2K platform. Provided System Administration support for various NT shared directories used by the application development staff. Provided database design consultation and reverse engineering support for SQL Server using the Erwin design tool.

• Provided remote database administration, monitoring and maintenance support of multiple Oracle v7.3.4 environments on Windows NT 4.0 platforms.

• Provided software development and data administration support for the client's Legacy Data Archival project. Developed an ETL process for archiving legacy data utilizing a combination of MS Excel, UltraEdit-32, SQL *Loader, and various custom-developed Unix shell scripts to convert legacy application data from various proprietary formats under MVS/TSO, VM/CMS, VMS/VAX, AS400 and others to a standardized ASCII, tilde-delimited format, which was then recorded I the Archive Master Index (AMI) and archived to DLT tape on an HP-UX platform. Developed an interactive Korn shell application to process user requests for AMI data and automate the retrieval from tape and subsequent load to Oracle 8 using the SQL *Loader utility.

• Provided database administration support for all Oracle 8 environments on Tru64 and Solaris platforms and the Oracle Rdb production environment on Vax/VMS. Provided Unix System Administration support for user account creation, security and product installation for all Unix database servers.

• Provided data capacity planning support, platform data architecture and directory structure design, coordination of data integration activities, including application software migration and enterprise-wide Oracle DBA support for a multi-platform AIX and Solaris environment. Oversaw data integration to maintain database standards. Coordinated all application software release migration from Development to Q/A Test to Production. Coordinated and performed the Oracle RDBMS product upgrades from v7.0.16 to v7.1.4 to v7.2 to v7.3.4 on both AIX and Solaris platforms. Trained and mentored junior associates.

• Provided comprehensive database administration support for the Adabas DBMS environments under the MVS/XA and VM/CMS mainframe platforms. Coordinated software CM and the migration of application releases between the Development, QA and Production environments. Mentored software developers on database design and Natural programming issues. Created and implemented various software utilities under NV/CMS and MVS/TSO to automate DBA-related functions for more efficient use of manpower resources. Team Lead for a team of seven software engineers performing the simultaneous development and sustaining engineering of 15 management information applications for using Natural v2 / Adabas in a VM/CMS environment.

Education:
Bachelor of Science, Accounting
Associate of Applied Science