Resume Joe: Oracle RAC consultant and instructor

 

 

 

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.

 

 

Joe is an experienced Real Application Clusters (RAC) Oracle Certified Professional (OCP) that has been working with Oracle for 20 years and possess a Masters degree in Engineering from Pennsylvania State University.

Joe has designed, developed and tuned highly available databases and Oracle-based applications and possess an active Top Secret security clearance. He has excellent analytical and communication skills.  Joe is also a Licensed Professional Engineer (PE) and a FAA Licensed Private Pilot.

Skill Set

  • Oracle 11g RAC, Data Guard, Enterprise Manager (EM) Grid Control
  • Data Warehouse, Star Schema, Oracle Designer, Logical Schema, Oracle Spatial
  • Automatic Storage Management (ASM), Storage Area Networks (SANs), Physical Schema
  • Procedural Language/Structured Query Language (PL/SQL), Stored Procedures, Triggers, JDeveloper
  • Java, J2EE, C++, C, Pro*C/C++, Object-Oriented Programming (OOP)
  • Extensible Markup language (XML), XMLDB
  • SQL*Net, Streams and Advanced Replication
  • Tuning: Automatic Workload Repository (AWR), Statspack, tkprof, utlbstat/utlestat, explain plan
  • Recovery Manager (RMAN), Flashback Database, Veritas NetBackup
  • Extraction, Transformation, and Loading (ETL): Transportable Tablespaces, SQL*Loader, expdb/impdb
  • Oracle Application Server 10gR3, Portal, Single Sign-On (SSO), Oracle Internet Directory (OID)
  • Oracle HTTP Server (OHS), MOD_PLSQL, Java Servlets, Service Oriented Architecture (SOA)
  • Auditing, Roles, Privileges, Oracle Label Security (OLS), Virtual Private Database (VPD)
  • UNIX Administration (Linux, Solaris, HP-UX), ksh, bash, awk, sed, vi, top, sar, netstat, ifconfig

Employment History

2004-Present   Senior Database Architect

Senior Database Architect of a 12 TB RAC database in an n-tier architecture.  Integrating this database with legacy systems using SOA, which will save $3.5M in custom interface costs.  Was also Senior Database Architect of a 8 TB RAC database on which he performed SQL access and memory tuning which increased the throughput by 250%.

1998-2003       Senior DBA

Was the Senior DBA of a 1 TB database. The system facilitates collaboration of field technicians and managers via pagers, personal digital assistants, internet browsers, and wireless telephones. I converted the single instance database to a 2-node RAC database making the system scalable and saving $150K in new hardware costs.  Was also Senior DBA of a 100 GB database. The system detects, analyzes, and clearly identifies abnormal network conditions.  Normalized the schema for a disk space savings of 53% and improved the throughput by a factor of 5 by performing SQL access and memory tuning.

1996-1998       Senior DBA

Was the senior DBA of a 56 GB database. The system manages and administers digital cable TV video on demand. Used snapshots, now known as materialized views, during data migration to reduce downtime from 3 hours to 15 minutes during application software upgrades.

1994-1996       Senior DBA

Increased database performance by 300% in a system that reconfigures network capacity to meet demand. This increased customer satisfaction and resulted in $1.2M in additional revenue.

1993-1994      DBA

Designed and developed a database for a voice and data network monitoring, surveillance, and control system. Employed object-oriented design methodologies.


1992-1993      DBA

Designed and developed a data warehouse of the functional uses of area, point, and line geography and the grouping of these usages into hierarchies.

1992                Programmer/Analyst

Designed and developed a database to track and control the life cycle of container shipments.

1990-1992      Software Engineer

Designed and developed a database for a system that monitors and controls a large-scale, real-time, highly reliable satellite-based communications system.

1988-1990      Software Engineer

Designed and developed a database for the Intelligence Community, which stores SIGINT data for retrieval and analysis.

Education

MSEE, Pennsylvania State University, 1988
BSEE, Pennsylvania State University, 1986