Oracle Manager
Resume:
James L. Colestock
**** **** ****** abqip5@r.postjobfree.com
Wheat Ridge, CO 80033 http://www.colestock.com
Summary of Qualifications
Over a decade of progressively more challenging experience within the field of Information Technology as a Database Administrator, Developer, and Architect
Technology-savvy self-starter adept at leveraging disparate IT products in order to deliver solid business solutions
Oracle Certified Database Administrator (OCP) with experience implementing and managing Enterprise-level Oracle solutions, such as: RAC, Grid Control, Data Guard, and Streams
Technical Expertise
Database Administration: Oracle 8i-11gR2, SQL Server 7-2008, MySQL 3.X-5.X, Access, PostgreSQL
Platforms: Linux, Solaris, Windows NT-Server 2008, HP-UX, AIX
High-Availability: Real Application Clusters (RAC) 9i-11g, Data Guard, Oracle Streams, HP ServiceGuard, Veritas Cluster Server, Oracle Failsafe
Enterprise Database Tools: Oracle Designer, CA ERWin, OEM/EM Grid Control (Enterprise Manager), Toad & Quest Central, Veritas i3, Oracle Warehouse Builder (OWB)
Application Servers: OAS 4.X.X, 9iAS, OAS 10g, Apache/Tomcat/JBoss/Resin, IIS, Zend LAMP
Application Systems: Oracle Applications 10.7-11i, SCT Banner, Siebel
Programming: PL/SQL, PHP, Java/J2EE, JavaScript/AJAX, Perl, bash, ksh, C
Education
B.S. in Business Administration, Indiana University (IPFW), 1994-1999 (3.6 GPA)Database Systems Certificate Coursework, Purdue University (IPFW), 1999-2000 (3.5 GPA)
Certifications
Oracle Certified Professional (OCP) Database Administrator - 8i, 9i, 10g, 11gMySQL AB Certified Database Administrator 5.0 (CMDBA)Microsoft Certified Technical Specialist (MCTS) – SQL Server 2005
Community Involvement
Junior Achievement – Success Skills Program Habitat for Humanity / St. Bernard Project – New Orleans, LA
Professional Experience
TRUEFFECT, Broomfield, CO
Oracle Database Consultant (Contract) 11/08 – 10/10
Database Administrator/Data Architect 10/10 – 12/11
Provide comprehensive consulting and support, focusing on scaling and evolving back-end services of client’s online ad serving product
Design, install, patch, upgrade and tune multi-terabyte database infrastructure using: 10g; 11g; ASM; Grid Control (OEM); SQL Server 2008
Design, code, and implement large-scale, multi-threaded solutions for: Data Warehouse ETL, Flat File/Log/XML processing, and Reporting using: PL/SQL; Java (Ant, Axis, JavaMail, log4j, SAX, JDBC); Perl and C
Create and maintain enterprise backup and recovery plan using: RMAN & NetBackup
In charge of migrating entire database infrastructure from 10.2.0.x to 11.2.0.x
Provide 24X7 support for Oracle/SQL database infrastructure
Create and maintain internal applications/dashboards using: PHP; AJAX; Zend LAMP; open-source APIs: FusionCharts, jgGrid, Flot
COMCAST CABLE/IDEA INTEGRATION, Greenwood Village, CO 11/07 – 12/07
Sr. Oracle Consultant (Contract)
Served as a short-term contract DBA to internal billing organization
Led initiative to improve multi-terabyte Operational Data Store and Date Warehouse performance; primary point-of-contact for design and Oracle Warehouse Builder (OWB) issues
Provided 24X7 support for Oracle database infrastructure
NORDSTROM, Seattle, WA 12/06 – 06/07
Oracle Database Administrator
Served as primary Oracle DBA for mission-critical OLTP and OLAP databases, responsible for 40+ databases (500GB to 4TB+)
Implemented the following Oracle solutions: Grid Control; Streams; Physical & Logical Standbys (Data Guard); Oracle Warehouse Builder
Performed 50+ database and application upgrades (9i -> 10g)
Provided 24X7 support for Oracle database infrastructure, including bi-annual Disaster Recovery exercises
THE BOEING COMPANY/CDI, Seattle, WA 12/04 – 06/06
Oracle Database Consultant (Contract)
Served as an internal Oracle consultant to a large Oracle DBA team (250+ members)
Provided 24X7 support for Oracle databases on a variety of platforms; responsible for 50+ databases, including RAC
Implemented the following Oracle solutions: RAC; Grid Control; Streams; Physical & Logical Standbys
Performed 70+ database and application upgrades (9i -> 10g)
Professional Experience
FUTURE LOGISTICS, Portland, OR 09/04 – 10/04
Oracle Database Consultant (Contract)
Performed statement of work for small trucking company on an independent basis
Instituted a comprehensive backup and recovery plan for client’s Oracle 9i databases on WIN2K using RMAN
Provided detailed instructions and trained operations personnel on how to recover/restore Oracle databases
IOVATION, Portland, OR 11/03 – 09/04
Oracle Database Consultant (Contract)
Served as an independent Oracle consultant responsible for migrating the company’s database infrastructure from MySQL to Oracle
Implemented the following as part of the solution: a 4-node, Oracle 9i RAC (Real Application Clusters) Database; Oracle Enterprise Manager; Oracle Designer
Performed all physical and logical data-modeling, coding, and business analysis required to migrate client data
Provided documentation and training, including comprehensive backup and recovery plan
MENTOR GRAPHICS/VOLT, Wilsonville, OR 06/03 – 08/03
Database Consultant (Contract)
06/03 – 08/03
PORTLAND STATE UNIVERSITY, Portland, OR 06/02 – 06/03
Oracle DBA/Developer III
06/02 – 06/03
TRM CORPORATION, Portland, OR 12/01 – 06/02
Oracle DBA/Developer III
12/01 – 06/02
AVOLO.COM, Seattle, WA 11/00 – 05/01
Oracle DBA/Developer
11/00 – 05/01
PREMIER LEASE & LOAN SERVICES, Bellevue, WA 07/00 – 10/00
Oracle Business Analyst
07/00 – 10/00
LOCKHEED MARTIN, Fort Wayne, IN 08/97 – 07/00
Cost Analyst
08/97 – 07/00
Contact this candidate