|
Resume Troy: Senior Oracle RAC DBA consultant
EDUCATION: Georgia Institute of
Technology Atlanta, Georgia SPECIAL SKILLS & QUALIFICATIONS:
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. 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. |
|||||