SR. LEVEL DATABASE ARCHITECT AND ORACLE APEX APPLICATION DEVELOPER

Innovative and proactive database engineer able to predict back - end data needs, gather requirements cross functionally, and deliver flexible, long lasting technical solutions. Thrives on challenges that push the envelope both in technology and time constraints. Focused and experienced in the design and development of applications in a variety of industries from scientific research and health insurance to IPTV and gaming. Responsibilities have varied from building complete web based, data driven systems with attractive, highly intuitive, user interfaces and complex work flow, architecting new database schemas for OLTP, OLAP, reporting, data warehouses, developing systems of stored procedures, and enhancing existing systems to monitoring and administering engineering and production databases.

PROFESSIONAL QUALIFICATIONS:

• Self Directed
• Proficient in Multiple Databases
• Establish, Meet, and Exceed Deadlines
• Skilled Project Manager
• Statistical Reporting
• Requirements Definition and Prototyping
• Agile Project Management
• Risk Analysis/Corrective Action

Application Frameworks: Oracle Application Express 4.0 (experience includes dynamic actions and plug-ins)

Languages: SQL (expert), PL/SQL (expert), PHP (novice), Java (novice), UNIX shell scripts

Databases: Oracle 10g, MySQL, SQLServer, DB2

Source Control: SVN, Perforce

IDE: SQLdeveloper, TOAD, SQLYog, Navicat

ETL Tools: Pentaho Spoon

Data Modeling Tools: Jdev 11g, Oracle Designer, Embarcadero ER/Studio, ErWin, MySQL Workbench

Admin Tools: Quest Spotlight, MonYog, Oracle Enterprise Manager, Zmanda (backup and recovery)

PROFESSIONAL HIGHLIGHTS:

• Relieved application developers from database design, development, deployment, and administration tasks resulting in more productivity throughout the engineering organization and a cleaner more consistent database by taking ownership of the persistence layer.
• Developed start-up databases for a successful demo, beta launch and the first round of venture funding.
• Developed and deployed databases for two start-ups that were acquired.
• Accurate estimates. Identified, prioritized and estimated tasks based on management priorities.
• Identified and fixed underperforming SQL queries.
• Created a reporting subsystem to give management an accurate and detailed view of user activity from the time of initial signup.
• Translated user requirements to new database designs or enhancements to existing databases.
• Capacity to accomplish large scope of work in a short time frame.
• Within a few days of assessment, identified incorrect postage rate data in the USPS engineering database (before rollout to QA).
• Evaluated and implemented MySQL database health monitoring with MonYog.

EXPERIENCE:

Confidential, Menlo Park

Principal Application Developer

• Designed, developed, and deployed a complex web based system using Oracle Apex to automate SLAC’s “Radiation Safety Control Form” resulting in huge operational efficiency improvements. The user experience is quite intuitive but the workflow behind the user interface is very sophisticated.
• Automated the internal process of managing technical accelerator control projects by designing, developing, and deploying an Oracle Application Express web application and database.
• Enhanced and supported a custom trouble tracking and work management system (also Apex) that is critical to accelerator operations and used by over 500 internal users. Developed and managed a monthly release process.
• Established a source control directory tree for Apex applications and related database objects.
• Instructed and mentored coworkers in Apex development.

Confidential,Emeryville - Contract

Consulting Data Warehouse Engineer

• Pentaho Spoon (ETL tool) dimensional data warehouse development to provide metrics for community health index and other web user analytics. Pentaho ETL Performance tuning. I tuned the ETL loads from 1,000s of rows/hr to millions of rows/hr.

Confidential,San Jose - Contract

Oracle Application Express and database development

• Developed and deployed a web based system and database to be used worldwide.

Confidential,San Jose - Contract

Oracle Application Express and database development

• Developed and deployed a sophisticated web based order entry system to automate a network installation business.

Confidential, San Mateo - Contract

January 2009 March - Oracle developer

• PL/SQL development, schema changes and data validation scripts to support May 2009 postal price changes.

Confidential, Redwood City (Online 3D world for casual gaming/social networking)

, Sr. MySQL Database Engineer (Company was running low on funds)

• Developed and deployed a general purpose logging and reporting framework to provide visibility of detailed user activity from the web application or in-game. This turned out to be a critical source of information for management reporting and troubleshooting which was not available prior to my arrival.
• Created the database backend to an avatar inventory management system to manage avatar item transfers, store returns, and monetary transactions.
• Provided a historical view of the dynamic user activity window for historical reporting and research.
• Completely reorganized and cleaned up existing database schemas and deployed a couple major revisions to many databases.
• Developed stored procedures, functions and schema changes to support new product features.
• Migrated schema changes to multiple development, QA, and production servers.
• Database “neatnic” and data integrity “watchdog”. Hunted down and removed dead code and obsolete database objects and data.
• Put scattered financial transactions in one place that was easier to track using my new logging facility.
• Monitored engineering and production databases with MonYog.

Confidential,San Jose, CA, E-Discovery,

May 2007 (Metalincs acquired by Seagate December 2007) August 2008, (financial melt-down, customer base dried up)

Sr. Software Engineer

• Assisted and mentored report developer with sql development and testing.
• Developed and prototyped a partitioning strategy for very large tables.
• Tuned a migration script that originally took about an hour for a medium size data set to finish in about five minutes. This script reduced a migration from days to about an hour for a very large set of production data with very complicated mapping logic.
• Developed an asynchronous reporting process for billing that has minimal impact on a critical high volume data capture.
• Developed complex “fuzzy logic” to correct for missing data for migration from a very early schema version.

Confidential,San Francisco, CA, Online Blog Influence Analysis Tool

, Engineer, Contractor, Early start-up, contract ended

• Designed, developed, and maintained five new MySQL databases for OLTP and OLAP.
• Built out most of the db backend of the beta product leading to a successful post beta launch.
• Created an extensive set of procs and functions to simplify PHP front end database operations, manage data, manage the presentation of data, and maintain data integrity.
• Created a directory structure for storing database related files for builds, testing, and administration.
• Developed and maintained an ANT based database build, update, and testing utility.
• Developed db upgrade scripts for each release.
• Worked closely with PHP and flash developers to develop database support for new features.
• Developed a system of stored procedures and part of the java middle tier to raise alerts when some application data thresholds are exceeded or other events occur.

Confidential,San Jose, CA, Enterprise Incentive Management,

(recruited to Buzzlogic by a former Callidus Manager)

Sr. Software Engineer

• Enhanced existing product backend stored procedures.
• Investigated and resolved db layer product defects.
• Query performance tuning.
• Porting of very large and complex database stored procedures from Oracle to SQL Server and DB2.

Confidential,Mountain View, CA, IPTV,

Confidential

Sr. Software Engineer Left due to planned office closure

• Design/developed server side enhancements and new features for an Oracle 9i database and application server responsible for an interactive TV application for customers like Yahoo Japan, Telmex, AUNA, and Cyprus Telecom.
• Created scripts to convert data from an existing schema to a new schema without loss of data for major releases of our product.
• Created database tools for engineering and QA.
• Identified performance bottlenecks and recommended solutions.
• Fixed various compromising database problems in our development lab and at customer site.
• Patching and upgrading the Oracle Databases and Solaris OS.
• Installed and configured 10g and 9i RAC on Linux and Solaris for application testing.

Confidential,Redwood City, CA, Peer to Peer Music Service

Oracle Developer/DBA-on the engineering and development side (running out of money, layoffs)

• Designed and developed major enhancements to Napster OLTP database schema to support membership, digital rights management, customer relationship management, billing system interfaces, management reporting subsystem, and served in a rotation for on-call production DBA support.