Resume Troy: Senior Oracle RAC DBA consultant 

 

 

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.

 

 


Troy is an analytical and results driven IT Consultant and Senior DBA team leader with long term experience in engineering,  implementing and supporting  disaster recovery and high availability plans and solutions based on Oracle software on multiple platforms. 

Troy specializes in Oracle RAC, DataGuard, Oracle system architecture, upgrades and implementations. 

EDUCATION:           Georgia Institute of Technology    Atlanta, Georgia
                                  Bachelor of Science with a major in Computer Science

SPECIAL SKILLS & QUALIFICATIONS:

  •  ORACLE Certified Professional (8i/9i/10g)  

  • Microsoft Certified System Engineer  

  • Operating Systems: HP-UX 9/10/11/11i, HP MC ServiceGuard clusters, AIX, Solaris, Linux and Windows   Software: Oracle 7/8/8i/9i/10g/11g, Oracle 9i/10g/11g RAC, Oracle Data Guard (standby db, both logical and physical), Oracle Advanced Replication, Oracle Streams, RMAN, Oracle Enterprise Manager, 9i Application Server, Oracle APEX, Oracle Internet Directory (OID/ONS), MySQL,  SQL Server 2000/2005  

  • Programming Languages: SQL, PL/SQL, Perl, Shell scripting       

EXPERIENCE:

09/04  to Present     IT Consultant / Senior Oracle DBA DB Team

Provide Oracle and SQL Server database support and consulting to employer’s external trade customers.  Support includes routine DBA tasks such as backup and recovery of full and partial databases using RMAN/NetBackup/DataProtector, performance tuning of SQL and PL/SQL code, system and database  performance tuning of HP-UX multiprocessor shared database environments.  

Provide detailed architecture, consulting, engineering, implementation and support for database availability, backup and recovery, and performance tuning projects. Provide system DBA engineering, implementation and  support for Siebel Applications and SAP  using Oracle databases.  

Provide  DBA implementation and support for SAP/Oracle migrations and upgrades, including environments  using Oracle DataGuard.  

Provide Oracle Application Server and Oracle APEX implementation and  support.  

Provide support for Oracle Enterprise Manager Grid Control and Agents. 

Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster and system management.  

Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC (Real Application Clusters) databases on HP-UX and Linux.

Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions.  

Provide after hours 24x7 database support, engineering and consulting for trade customers.   Engineered, implemented and supported Oracle 9i SAP environment (over 10Tb in size) to use Oracle DataGuard on HP-UX for over 4 years. 

Successfully engineered, implemented,  documented and supported upgrade of the environment to Oracle 10g.   Lead engineering effort , implemention and support a migration of an existing Oracle 10g RAC (64cpu/128gb RAM/60Tb ASM disks on HP-UX) environment worth over 10M in annual revenue to the customer to two (128cpu/192gb RAM/60b ASM disks on HP-UX) environments.  

Engineering, implemented, documented and support builds of new clusters to use Oracle 10g/11g RAC on HP-UX and Linux.  Including installing clusterware, ASM (and shared disks) and creating new databases.  

Lead engineering effort, implementation, tuning and support of  Oracle 10g RAC/Dataguard upgrades to Oracle 11g RAC/Dataguard. 

Designed a proof of concept environment to facilitate functionality testing and features, built a pilot environment which mirrored production to do in depth testing for all customers, and provided a detailed migration plan to migrate the current production cluster to the new environments.  

Lead engineering and implementation effort for migration of over 100 small to medium sized databases (< 2Tb) from HP PA-RISC based machines to HP Itanium and Linux based machines

03/04 to 09/04       Technology Consultant  - Member of HA Transformation Team

Provide  database architecture and consulting  to external trade customer sites with Oracle, HP/UX and SAP environments.   Perform assessments on customer sites and report to management with recommendations on how to achieve a   highly available production environment.  Design HA environments to be implemented within customer sites.  

Design, implement and support incident support system using Remedy. Create and supervise change and configuration management processes for external trade customers.  

06/2000 to 03/04    IT Engineer/ Senior Oracle DBA  - Member of IT Consulting Staff  

Provide database and system management for multiple HP-UX/NT servers running Oracle 9i RAC and Oracle Advanced Replication, and several Oracle 8i databases ranging in size from 500Gb to 1.5Tb+.  

Installation, upgrades, migrations, performance tuning, backup and recovery, schema management, SQL tuning, proactive monitoring and troubleshooting Oracle databases in a 7x24 environment.   Primary DBA support for primary E-commerce site, several related customer facing OLTP and data warehouse systems.  Databases were  responsible for single sign on and profile information to over 3000 internal websites.  

Provide engineering, implementation, strategy and support plans to development teams for database related issues, including designing HA and redundant database systems and implementing advanced Oracle options for mission critical environments.  

Designed, implemented and supported highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.  

Provided Oracle RAC consulting and engineering to internal organizations for planned implementations and migrations.  Consulting included designing backup solutions (using RMAN), disaster recovery plans, and performance tuning advice for RAC implementations.  

Design, implement and support Oracle advanced replication and Oracle streams to provide a replicated database environment to support internal HP business sites.            

08/98 to 06/2000         Database Administrator /Developer - Information Technology Engineer

 Provide database and system management for multiple HP-UX/NT servers running Oracle 7.3/8/8i/9i, ranging in size from 200Gb up to 500Gb+ of data.   Primary DBA support for Pricing and Product databases, Enterprise Directory Service and multiple CRM applications.

 Implementation and support of Oracle standby databases, and multimaster advanced replication in an environment consisting of over 40 separate database environments. Implementation and support of  backup strategies, providing database consulting and engineering to development teams within company, creating custom SQL scripts, database monitoring and backup scripts, database performance tuning, writing support and training documentation and investigating new database related technologies for use within company.  

Develop stored procedures, functions and business logic in PL/SQL to support in-house database applications and websites.                        

06/94 to 08/98   Remote HA Specialist/ORACLE DBA  

Provided remote technical consulting and DBA support for employer’s HA customers.   Coordinated support plans for commercial customers with enhanced or premium support offerings.   Scheduled training requirements for analysts and developed a proactive change control management plan for customers.  

Designed tools to proactively report system and database availability in highly available environments.   Created SQL and PL/SQL scripts to provide periodic reporting and database monitoring for internal and remote customers.  

Provided remote technical support to customers with environments based on employer’s UNIX and Windows Servers.   Supported Microsoft server components including SQL Server, Exchange and SMS server, as well as the complete Backoffice suite.  

Duties included installation and configuration support, technical problem resolution, hardware and software assistance, and networking support for customer environments and clients.