Professional Summary

Systems Engineer

• Extensive technical, data architecture and systems architecture background architecting, engineering, implementing, monitoring, end-to-end performance tuning and troubleshooting complex, highly scalable, low latency, large scale distributed systems and high-availability mission critical production business solutions utilizing architecture including dedicated equipment, in-house clouds, hybrid clouds and public clouds with database infrastructure including Relational database systems, NoSQL, In-Memory and Hadoop data stores.
• Technical and systems architecture background in security implementations using roles, AD groups, LDAP, OID, OUD, Linux/AIX sudo permissions and PAM to ensure secure, scalable, compliant, automated and auditable systems.
• Acted in many roles such as Visionary, Manager, Technical Lead, Mentor, Data Architect, Systems Architect, Database/Systems Engineer, Database/Systems Administrator, Exadata Machine Administrator, Network Architect and Data Center Solution Architect.
• Designed and utilized statistical models for Capacity Planning, Benchmark analysis and application testing to create deterministic systems ensuring scalability and uptime.
• Designed and implemented backup and DR systems along with Disaster Recovery planning and long term archiving to meet all levels of compliance and requirements for the business.
• Designed and implemented automated production deployment, operations and monitoring solutions.
• Provided Technical Leadership and mentoring to my clients, my team mates and the business.
• Worked with all levels of management, engineering and business personnel to set appropriate goals and drive the projects and business to success.

Experience

Confidential

Chief Technologist/Owner

• RMOUG Abstract Reviewer 2013 TD and 2015 TD.
• Performed database and systems work for a Fortune 19 retailer.
• Took client from 2 Oracle databases to over 135 Oracle databases in 10 months across 20 Modernization projects as the Database Platform of choice with private cloud, dedicated equipment and Oracle Exadata.
• Tested and recommended Exadata X3-2/X4-2 for the future platform of choice.
• Performed all tasks related to Exadata Machine Administration.
• Installed and configured OUD POC. Created automation for system admin tasks and tested deployment into dev, test and qa fleet. Tested performance and scaling of architecture. Recommended for acquisition in next contract purchase cycle.
• Interviewed 72 DBA/DBE candidates over 6 months of which client made offers to 12 candidates and 4 DBAs/1 DBE accepted the offers.
• Built 6 RAC clusters then moved the SAP databases for CRM, BW and ECC landscapes to those clusters. Converted to TDE encrypted table spaces with BRSPACE, upgraded databases from 11.2.0.3.0 to 11.2.0.3.7 and changed the DNS database server name entry to standard c-name architecture in preparation for future movement to the Exadata and being able to perform standby flips. Worked with Oracle ACS SAP COE to verify RAC systems were built to exact specifications and reviewed system setups.
• Worked with Linux Team and Cisco Engineering team to get RAC physical servers working across Cisco Frames.
• Worked with VMWare and Network Engineering teams to get RAC to work on VMWare. Tested setup with Basis team. Went through multiple rehearsals of conversion of landscape systems to RAC and implemented RAC for the production landscapes.
• Worked with the IBM MDM Initiate team to install and configure their databases. Worked with WebSphere team on connectivity.
• Worked with the IBM FileNet team to install and configure their databases.Worked with WebSphere team on system connectivity.
• Worked with multiple DEV teams on data model designs and writing PL/SQL procedures/packages for data loading and data manipulation.
• Benchmarked TDE and column level encryption versus no encryption. Worked with Enterprise Architecture to write the Database Security Encryption Standards document requiring TDE encryption for all database systems.
• Worked with Informatica ETL team of performance tuning conversion code and conversion best practices for Oracle. Trained ETL developers on Oracle SQL and partitioning.
• Worked with the internal Java developers on connecting and working with Oracle. Trained Java developers on DB2 versus Oracle differentials.
• Trained and worked with the Data Modeling team on differences of Oracle to DB2/Netizza /MS SQL Server. Helped determined best practices of dealing with Oracle systems based on clients current processes on DDL code generation from PowerDesigner.
• Reviewed thousands of SAP notes to create SOP for DBA team to work within the bounds of SAP rules while properly administering systems from an Oracle perspective.
• Worked with Basis and Accenture teamsto move backups to the DBA team for all the SAP project databases to meet compliance requirements, project sustainability and eliminate problems they were having with their current setup. Took over system refreshes from Accenture team for SAP databases to decrease time in order to meet project timelines.
• Trained the DBA team on: Oracle SW installation, Oracle GRID Infrastructure, Oracle OEM 12c with management packs, Oracle RAC, Oracle Troubleshooting, Oracle Performance Tuning, Oracle backups, Oracle Security, Linux scripting, PLSQL and SAP on Oracle.
• Designed and reviewed new Oracle backup code that utilized RMAN instead of exports that were being performed on original databases.
• Worked extensively with the Enterprise Backup Team, the DBA/DBE teams, Enterprise Architecture and both vendors to review and test the different backup systems CommVault/TSM across Oracle/DB2/MS SQL Server. Based on significant bugs in CommVault determined TSM was the better choice for all database backups.
• Worked with Oracle ACS and Enterprise Architecture team in writing the client Oracle MAA document.
• Worked with Oracle ACS, Basis and Linux team to test HA characteristics of RAC, RHEL Cluster and Data Guard to determine HA setup for Costco systems. Worked with Enterprise Architecture to produce client Database HA Architecture document utilizing RAC as the foundation for systems requiring 99.9 availability and other lower available systems being on VM Ware with Data Guard.
• Worked with DBE/DBA teams and Enterprise Architecture to define Schema as a Service and Database as a Service instead of the every project gets their own database server and own private database.
• Worked with Test Data Management Team and Delphix to setup and test Delphix Database Virtualization.
• Authored the client Oracle Database Specification document. Setups included lun layouts, AIX, VM Ware and Linux OS configurations, packages to be installed, users/groups to be created, directory structures and SW layouts, sudo privileges for DBAs/DBEs.
• Worked with the Linux team to build puppet module for building SAP/Non SAP RAC/Single Instance systems based on the client Oracle Database Specification document. Performed testing of configurations for both physical and virtual servers. Worked with AIX team for porting of the puppet modules to AIX RAC clusters.
• Worked with Enterprise Architects and authored document on Schema As A Service SaaS and Database As A Service DaaS . Implemented SaaS and DaaS, bringing schema and database deployment down from days to less than an hour.
• Performed HIPAA audits and security enhancement of systems to meet all compliance requirements.
• Upgraded original 2 Oracle Standard Edition RX databases to Oracle Enterprise Edition by use of materialized views.
• Contracted by an Internet Gaming company for installation of Berkeley DB and setup of management and monitoring of systems. Provided Data design of JSON messages.
• Contracted by an Internet Security company for installation of second Hadoop cluster and second Pig, Hive and Flume cluster. Performed software installation and configuration.
• Contracted by an Internet E-Retailer for installation of OUD and setup of custom programs for standard tasks to be executed by help desk personnel for user creation and password management.
• Contracted by Delphix to perform installation and replication setup of Delphix Database Virtualization servers for the subsidiary of the largest Cruise Lines in the world.
• Installed new Delphix Database Virtualization servers on Cisco UCS blade servers with VM Ware 5.x and migrated all databases from previous Delphix Server.
• Cleaned up problems with the backup configurations of the databases on Linux and AIX.
• Installed and Configured Replication servers in Florida.
• Trained the DBA/Unix/Storage team on the Delphix system and operations management of database on Linux and AIX.
• Performed Database and system analysis on a 4 node RAC cluster for Mobile Market client.
• Managed system until client DBAs could be hired.
• Trained DBA team and assisted in their 11g upgrade and RedHat 5.x to 6.x OS upgrade.
• Rewrote all the PL/SQL ETL load jobs to allow client to meet their DW Report delivery objectives. Decreased runtime of ETL load jobs by 83 .
• Worked with Business end users on their reporting requirements.
• Managed Business Objects reporting architecture. Redesigned Business Objects Universes and modified Finance reports and dash boards for the different finance/marketing groups ofthe Business Objects system.
• Worked with development teams on code redesign of their work flows into the DW system.
• Worked with MySQL DBAs on backup automation and database design for Database as a Service.
• Presented at the 2011 FujiFilmGlobal IT Executive Summit. Backups and Cold Storage: Scaling and Cost Containment Utilizing Tape Storage At The PB Scale And Beyond Without the Disk Cloud.
• Performed remote troubleshooting and patch analysis support for Global Institutional Investment firm.
• Performed analysis and performance tuning on an 8 node RAC system for the second largest Internet Ad retailer.
• Made recommendations forchanges to the Database and OS parameters.
• Examined NFS Netapps Storage and worked with Netapps Engineering on changes to configuration.
• Decreased the time for completion of load jobs by 77 .
• Performed database and system analysis on Oracle 10g Linux system for the largest Internet IP Telephony provider.
• Provided training to the database team on different technologies and Oracle 11g.
• Designed and implemented regional data center move of database systems with less than 2 minutes of downtime.
• Provided data block level repair, database recovery and data extraction from 10g database that was down without backups for an equipment manufacturer.
• Performed remote system analysis and system repairs on EBS11.5 for large golf club manufacturer.

Confidential

Database Engineer

• Designed Exadata/ZBA architecture and worked with senior management and Enterprise Architecture to plan and acquire the replacement of the whole Oracle fleet.
• Worked with Data Center Engineering, Network Engineering, Oracle Exadata and ZBA Engineering, Oracle Sales Engineering, Oracle ACS SAP COE and Oracle ACS Platinum Services on installation, setup and configuration of 4 Exadatas and 2 ZBAs. Assisted Oracle ACS in applying SAP bundle Patch for initial installation of an Exadata X4-2.
• Worked with Oracle Exadata Engineering and Oracle ACS SAP COE on design and consolidation planning for moving the fleet to the Exadatas balancing memory to flash performance trade-offs.
• Worked with Oracle ZBA Engineering and Oracle ACS Platinum Services to design the Infiniband network for a ZBA SAN along with optimal performance design to achieve the test results from the testing we performed in Oracle Santa Clara lab.
• Designed and performed a comprehensive benchmark of the Oracle Sun ZBA at the Oracle Santa Clara lab. Trained other DBE on benchmarking tools and proper disk system benchmarking best practices.
• Designed and performed benchmarking on: Exadata X3-2 versus X4-2, database administration activities and data model designs.
• Designed and Implemented Exadata/ZBA DatabaseBackup architecture. Architecture implementedutilizing 3 Infiniband networks for the multiple sets of Exadatas and 1 Infiniband network for the attached TSM Backup system for offsite tape storage to create a ZBA SAN.
• Migrated Oracle SAP DatabasesCRM, BW and ECC to an Exadata X4-2.Migrated ODS and ETL databases from the original Exadata X3-2 to new Exadata X4-2 with RMAN duplicate. Built new databases on the Exadata systems in PROD and NonPROD. Prepared plans for migration of rest of fleet to the Exadatas.
• Performed all tasks related to Exadata Machine Administration. Performed system, network and database administration for 4 ExadataX3-2 and X4-2 systems 11.2.0.3.22BP22 and SAP Bundle Patch Sep2013, 11.2.0.4.6BP6 and 12.1.0.1.3 BP3 along with the 2 ZBAs, multiple management, jump and gateway servers along with theInfiniband Network.
• Installed and benchmarked Oracle Berkeley DB 12cR1 12.1.6.0.30 for eCommerce cache. Tested various scenarios for performance and HA.
• Worked with the Enterprise Architecture on a variety of forward looking projects with our Cloudera Hadoop system and Exadata systems. Examined VM Oracle databases for rapid ETL/BI construction and testing and Hadoop as an Archive system for direct access and off-loading work from the Exadata.
• Installed and configured Golden Gate on Linux and AIX. Worked with Oracle development and DB2 team for iSeries to Oracle data conversion. Implemented Golden Gate for IBM Ecommerce DB2 to Oracle IBM MDM Initiate data movement. Tested Golden Gate for cross country data center replication. Tested Golden Gate for SAP replication.
• Installed, configured, administrated, upgraded and resolved issuesfor Oracle 11g/12c RACon VM Ware/Linux, Linux Physical and AIX. Built 21 three to six Node RAC clusters: SAP CRM 4 Nodes , BW 3 Nodes , ECC 3 Nodes , HPBSM/OEM 3 Nodes , Informatica 3 and 6 Nodes , IBM MDM/IBM FileNet 3 Nodes , SAS 3 Nodes and Rx 3 Nodes .
• Installed, configured, administrated, upgraded and resolved issuesfor Oracle 11g/12c Databases across all projects. Worked with a variety of projects teams on testing their software on Oracle 12c in preparation for upgrades.
• Performed multiple refreshes of SPT/QAT/ADT databases converting Single Instance to RAC and RAC to Single Instance. Worked closely with the Basis team to ensure systems worked and proper modifications were made on the application side.
• Worked with the Test Data Management team on evaluation of database virtualization solutions including Oracle, Delphix, VMWare and EMC. Worked with Delphix Sales and Engineering team on sizing systems and training for Costco personnel. Worked with VMWare team on setup of Delphix servers.
• Designed and reviewed Oracle automation for GRID/ASM/TDE build out for SAP DB Refresh/DB Migrations.
• Worked with the Basis and Linux team on unified install process for conversion of the Accenture installed systems to the Costco Database standard fleet format. Migrated 62 SAP databases across 7 landscapes from file system based to Grid Infrastructure ASM based systems or RAC. Migrated the databases to TDE encrypted table spaces with BRSPACE, upgraded databases from 11.2.0.3.0 to 11.2.0.3.7 and changed the DNS database server name entry to standard c-name architecture in preparation for future movement to the Exadata and being able to perform standby flips.
• Worked with Basis team and development teams for performance tuning the CRM landscapes in preparation for go-live. The CRM system is stated by SAP to be the largest in the world with 73 million customers. Reviewed weekly SAP Early Watch Reports and custom program reports to verify setups on systems.
• Worked with Basis team and development teams on performance tuning BW and ECC systems for continuing project work.
• Worked with IBM MDM Initiate team for performance tuning the database and recommended modifications of their SW to IBM development. Tuned the ETL conversion and verification code. Performed multiple restores and refreshes to fix data conversion errors through system go-live.
• Worked with the Basis team and SAP Corporate/Support to get exemption on installing the SAP Diagnostic agent on the database servers to eliminate potential security threats from the components that run as root and allows remote access to those components.
• Worked with senior management, InfoSec, Compliance and Internal Audit to write the Prod Data in Non Prod Security Controls document. Implemented: database listener firewalls to control access points to the database, enforcement of role based security with PL/SQL package that ran every 5 minutes checking for and fixing inappropriate grants, removal of certain privileges matching Security CVE notes, and modified puppet module with Linux team for hardening the Linux servers.
• Worked with InfoSec and Enterprise architecture on the design and review of Database Firewall and Database Audit products from Oracle and Imperva.
• Member of the Costco Information Center of Expertise. Worked with the Information COE and the DBE/DBA teams to develop: The Costco Database Security Policy, The Costco Database Architecture Policy and The Costco Database Backup Policy.
• Member of the Costco Infrastructure Center of Expertise. Worked with the Infrastructure COE and DBE team to develop the Engineered Systems Operational and Support Policy for the Oracle Exadata, Oracle ZBA and IBM Pure Scale systems.
• Worked with JDA consulting for certifying JDA databases on the Exadata and to merge the JDA database installation into a Costco formatted database installation.
• Designed multiple data center setup and worked with DBA team on installation and implementation of OEM 12c. Configured Oracle OEM agent for Single Instance, RAC and Exadata. Took the on-call for 8 weeks to work through the configuration of OEM to make the on-call sane. Worked with Enterprise monitoring team to integrate OEM into HP BSM with BSM plugin. Installed and configured management packs: Diagnostics, Performance, Configuration, Provisioning and Patch Automation, Linux.
• Designed, developed and deployed Auto Deployment database infrastructure monitors.
• Developed monthly Team plans and projects executed by DBE/DBA through RTC IBM Rational Team Concert . Managed ticket queue and direction of projects from a database perspective.

Confidential

Systems and Database Engineer

• Set the technical direction for the Infrastructure and Techops Teams.
• Designed and implemented the unified architecture and best practices for development with the SW Principal Engineers.
• Performed data center and system level review for post-acquisition of Jingle Networks.
• Designed new data center architecture for collapse of two data centers into one for a 1.6 million/year cost savings.
• Tested and reviewed servers, storage and networking from multiple vendors in their labs to determine the next server/storage platform for the company. Negotiated with the vendors to achieve optimal pricing.
• Designed dual public facing and storage 40Gb point to point network with server block and storage cells so that the application was spread across the building blocks to achieve 99.999 uptime.
• Designed and implemented new 40Gb point to point network and VOIP infrastructure in the New Jersey consolidated data center to handle 100 million calls per month. Engineered in QOS and VOIP analysis hardware for quicker troubleshooting.
• Researched and examined data centers in NY/NJ to determine next site for the collapsed data center. Performed onsite reviews of each potential data center vendor and their data centers.
• Provided data center cost models to finance to assist in data center selection and worked with data center vendors for power/cooling design and implementation.
• Reviewed contracts with legal and finance to eliminate previous poorly negotiated contracts and tracked/eliminated money that was being spent unnecessarily. Closed down excess data center, building and circuit capacity to save the company 50K per month.
• Worked with finance and legal to develop a Voice Circuit RFP and reviewed RFP responses along with worked with legal to review and negotiate contracts.
• Worked with finance and legal on the Oracle database contracts to eliminate the multiple contracts and combine into a single contract for greater flexibility while eliminating unnecessary licensing.
• Evaluated alternative Database vendors and architectures for Engineering. Authored recommendation document to C-Level.
• Worked with DBA team to bring the systems within contract compliance. Moved multiple RAC clusters to Primary/Standby configurations eliminating RAC.
• Performance tuned Oracle/MySQL/PostgreSQL/Redis databases/caches for the different voice platforms.
• Performance tuned PostgreSQL ZFS disk layout.
• Worked with other infrastructure engineers to virtualize the fleet with KVM and implement deployment automation with Chef and Puppet.
• Worked with Nuance Voice team and our development team for implementation of replacement VOIP Voice Recognition Advertising system.
• Built new data center infrastructure to replace whole fleet architecture for 3 million and delivered project on time and under budget.
• Built math models for management to determine when the Amazon cloud was or wasn't cost effective versus or own internal cloud infrastructure. Pulled multiple projects back in house based on this cost analysis.

Confidential

Principal Persistence Engineer

Providedbest practice methodologies, designed,architected,and implementedhighly scalable and highly available persistent storage systems to all business units and Affiliate companies. Utilized both depth and breadth of the interacting systems to assist software teams and business owners choose the appropriate path to achieve business unit and S-Team goals while maintaining costs and schedules.

Database Architecture and Administration

• Provided design, implementation and administration of Oracle/MySQL/PostgreSQL/DB2 database systems on physical, E-Commerce cloud and AWS cloud.
• Provided SW reviews and architecture designs for SW teams on data storage choices, from use of AWS infrastructure components to custom In-Memory caches Berkeley DB , relational databases and Hadoop infrastructures. Reviewed and designed data architectures relative to message transmission and SOA frameworks.
• Worked with SW development teams on design, implementation and use of Hibernate, Pig and Hive.
• Tested each Oracle version, features and created global init files for Amazon DBA teams to use on their systems.
• Performed regression suite testing on golden image patchset revisions to verify oracle bug fixes.
• Designed, tested, implemented, troubleshoot and administered local/remote materialized views, multi-master replication, Streams, Data Guard, Active Data guard and custom replication systems scaling single node systems to 550K TPS.
• Designed and implemented application level horizontally partitioned database systems.
• Worked with all DBA teams on making their databases Game Day ready. Zero Impact Data Center Fail-Over
• Provided classes to DBA Teams on various topics including RAC, Backup and Recovery, HA and Performance Tuning.
• Provided training to SDEs on Oracle Optimizer, Indexing Analysis, Partitioning and Partitioning at the SW level.
• Wrote various software programs for purging data, replicating data and migrating databases with near zero downtime.
• Created task based head count models for management teams for DBA administration.
• Helped teams in Database right sizing scaling exercises to eliminate 25 million in new expenditures each year.
• Developed Q4 Readiness SOPs for the DBA teams.
• Designed process for 32bit/64 bit upgrades and RHEL4/5 upgrades with minimal downtime for large portions of Amazon database fleet.
• Tested new Oracle products for determination of inclusion in our licensing: OID, TimesTen, Active Data Guard, Oracle Secure Backups, Real Application Testing and Database Vault.
• Provided support to DBA teams on specific database features where the DB Engineering team did not.
• Examined and tested new Database technologies including NoSQL architectures. Provided architectural reviews and performance tuning of those architectures.
• Maintained and extended the Virtual DBA internal website supporting 700 developers for self-service access to database monitoring, schema comparison, sql explain plan and index analysis.
• Provided vacation oncall coverage for DBA teams across the company.

Principal Software Reviews

• Performed 4 to 6 Principal Software reviews per year with other Principal Engineers for teams around the company.
• Provided input at initial design, during development and before go live. Some of the projects included: AWS SimpleDB, AWS Payments Services, AWS Mechanical Turk, Global Payments System HA Oracle Streams , Merchant Services Messaging Architecture.
• Provided Code reviews for a variety of applications in Ruby, Java, C and Perl.

On-Call rotation for the Merchant Services DBA Team

• Provided extensive root cause analysis and post mortems of all high severity events.
• Defined root cause setup in Remedy for proper disposition of tickets and responsible for resolution of 57 of all tickets for the Merchant Services DBA team.
• Performed 20 or more interviews per year for DBA/DBE/SDE across Amazon teams, provided training for new hires.
• Setup SOP documentation for monitors/ticket resolution and wrote code to replace SOPs with automated repair programs.

Project Planning and Scoping for Merchant Services DBA Team Projects

• Worked with management to integrate into the DBA planning all Software Development team's projects and laid out the detailed projects for the Database Architecture.
• Managed 82 tape libraries in 5 countries at multiple sites in each country and responsible for an additional 20 sites/affiliates in providing SW and Service for their backup systems.
• Responsible for World Wide backups and long term archiving at Amazon.
• Responsible for 3 System Engineers.
• Created detailed plans for a. 11.1 to 11.2 Upgrades, b. Grid/EM replacement of current monitoring infrastructure, c. ProductionizeDEVO, d. ODIN security project, e. Schema synchronization between PROD and DEVO, f. Creation of golden schemas for each database type, g. Partitioning project for MYO systems, h. Container development databases, i. Streams/Golden Gate HA databases, j. Increase Database Availability from 99.97 to 99.999.
• Maintained 25PB of cold storage on tape and 6PB of 30 day transient storage.
• Responsible for the OL-NFS fleet 1.5PB disk that served up global logging to all the teams for data analysis from their apps. Rewrote OL-NFS log administration code to eliminate 100 tickets per week in the fleet.
• Designed, tested and implemented new backup infrastructure utilizing large scale tape libraries which was the first 10G application at Amazon.
• Negotiated pricing and contractswith vendors for Tape libraries and media creating a new architecture that was 10x cheaper than the equivalent AWS S3 disk storage and contained more storage than S3.
• Tested all major vendors' backup software and worked with legal and procurement for 12 months on new Symantec 3 year unlimited license contract.
• Designed and wrote custom software to implement Game Day readiness of the backup systems.
• Negotiated contracts with Iron Mountain for disk and tape destruction world-wide.
• Defined and documented the Amazon Confidential Media Policy and SOX controls.
• Provided backup infrastructure and code for backups of Amazon Dynamo DB.

Confidential

• Responsible for 3 System Engineers.
• Responsible for defining the repair processes that the data techs used in all our Data Centers and Fulfillment Centers and the training of the personnel in all the facilities.
• Responsible for guiding the team in writing the software to maintain the spare parts pools at all facilities and maintaining the spare pools capacity at all facilities and working with procurement to order parts.
• Worked with the hardware vendors to maintain compliance with their training programs so that we could act as a VAR for part replacement and earn Amazon 3.2 million per year in part replacements while beating all our SLAs for repairing the servers.
• Worked with Hardware Engineering to create and implement new HWMON program and data analysis to examine hardware failures in the fleet.
• Worked with hardware vendors for in depth analysis of failures and fixes. Traveled to their manufacturing and development facilities for quality control.
• Managed invoicing for HP/Rackable spare parts and Iron Mountain invoices for off-site storage and destruction.

Confidential

• Global Call Leader for 5 years. One of twenty-two Global Call Leaders worldwide on call 2 days per month.
• Worked with Data Center engineering to examine different setups to decrease cost for tape and disk infrastructure.
• Created and provided output from my Mathematica models for tape libraries and human/tape archive processes.
• Worked with AWS management and financial directors to examine Disk versus Tape for cold storage long term retention of data .
• Negotiated contracts, tested new equipment, visited robot and tape media manufacturing facilities, evaluated new backup software and provided general direction in the area of Archive Engineering and long term storage for Amazon.
• Trained new Archive and System Engineers on backup SW and Tape Libraries.
• Designed and implemented Self Service backup system.
• Designed new Tape Backup Architecture that scaled to 6PB of backups per month.
• Designed andImplemented first 10Gb application at Amazon 2006 .
• Provided Oracle block/redo stream repair when systems crashed or became corrupt from Oracle SW bugs, HW problems or human error.Only external engineer to Oracle that Oracle Support fully supports the databases I repaired.
• Worked with DBAs, SDEs and management to implement the short term fix to get systems back online then would work with the teams on the longer term redesigns of their systems to eliminate problems in the future.
• Only Principal Engineer on call 365x24 for SEV1/2 Oracle/System problems globally at Amazon.com and its Affiliates.
• Global Call Leaders are to ensure that we drive to determining root and ensuring follow through on eliminating the root cause of any site impacting problems.
• Global Call Leaders are empowered to engage any and all personnel and to make any decision necessary to bring the site back to full health.
• Global Call Leaders are engaged based on each business unit's failure, SLAs or when there is an order drop outside of prediction that has not recovered in 5 minutes or there is more than 25 order drop that has recovered but root cause is not known within 15 minutes and for any DOS attacks.
• Visited IBM lab in AZ and worked with IBM Zurich engineering team on reliability models for tape.
• Visited Fujifilm manufacturing plant in MA and negotiated long term pricing with Fuji for LTO media.
• Visited and worked with Gemtrac on their new room based storage systems.

MYO Partitioning Project

• Designed plan for EU Partitioning expansion and worked with DBA team on implementation.
• Designed and coded new partition model with oracle partitioning for next phase of automated horizontal scalability.

Merchant Services Hardware Replacement Project

• Created capacity plan for the Merchant Service's Database fleet utilizing my Mathematica Models to project the next two years growth, hardware requirements and tuning opportunities.
• Worked with finance on the overall organization S-Team goals for business justification and modification to Amazon utilization goals for Databases.
• Worked with Infrastructure/Procurement Engineering to acquire 5.8 million in hardware replacement for all four regions NA, EU, JP, CN which was a 24 reduction in the overall hardware utilized by the organization while the growth of the org increased 47 YoY and database utilization increased by 70 YoY.
• Worked with the DBA team and SW teams to implement standby flip replacement of hardware in 4 months for 242 servers 1924 cores, 10TB of RAM, 580TB disk .

10g to 11g Upgrade Project

• Worked with Archive Engineering team on certifying 11g for backups with the latest Symantec NetBackup 6.5.
• Designed and implemented a plan to upgrade 228 primary databases for Merchant Services over 3 months.
• Developed the upgrade process and was able to decrease the outage time from 52 minutes to 20 minutes on average with the fastest upgrade being 16 minutes. Provided information to Oracle Development on cutting in half the upgrade time of the 12 minute catalog upgrade step.
• Performed simultaneous upgrades of up to 11 databases at a time and was able to decrease the overall outage experienced by the business by 93 .
• First team to complete all upgrades to 11g, 8 months ahead of anyone else.

Technological Leap Disruptive Engineering

• Examined alternative server architecturesor accelerators to achieve a 5x price performance gain over current technology.
• Traveled to vendor labs to perform quick 3 dayengineering assessment on whether the technology was viable.
• Examined and tested GPU, SSD, iscsi, 10G/40G Clusters, System-Z, Blue Gene, Disposable custom built servers, FPGAs, Game Consoles, ARM chips, Green Technology Data Centers DC Power and Water Cooled , High Temp Data Centers.

Distributed Data Center Software Analysis

• Examined how far the separate application components of the Amazon E-Commerce stack could be separated into smaller distributed data centers to affect the overall costing of our data center infrastructure.
• Tested multiple network wan emulator appliances. Selected PacketStorm devices and negotiated contract for purchase.
• Worked with PacketStorm development to modify their software to work with the size of our application and data center stack.
• Examined the effect on the top 10 applications of varying wan distances in 10 mile increments up to 500 miles.
• Documented usage of PacketStorm and assisted AWS to test out their various components under similar extended conditions.

Data Center Consolidation and Regional Implementation

• Planned and implemented movement of database and app servers between data centers and plan for movement of systems into new regions.
• Managed teams of DBAs for database flips or migrations such as the Amazon EU region NA to EU move 87 databases, 42TB in 3 weeks cross wan, Seattle Data Center evacuation for potential flooding 78 racks , VA data center consolidation 196 Racks in 5 weeks , and the Merchant Services CN region implementation.

Oracle RAC Design, Testing, Implementation and Management of Systems

• Worked with vendors and OLTP/DW teams to analyze current system and test multiple HW vendors' products each year for the next system design.
• Designed and implemented 16/24/32 node DW systems utilizing EMC Symmetrix/DMX and HP24000/Hitachi disk arrays and Ethernet or Infiniband interconnects. Systems varied in size from 10TB to 500TB.
• Designed 1PB DW with Infiniband interconnects and SSDs.

Hardware Engineering Hardware Design

• Worked with the DBA Community and hardware engineering to define the file system layouts for the new database servers.
• Performed benchmarking on the new servers to provide the baselines for my Mathematica models for capacity planning.
• Tested alternative hardware designs to assist HW Engineering in equipment choice.

HPUX to Linux Migration

• Revamped the project and completed the last 60 of Amazon systems in 6 months.
• Wrote new snapshot based processes that decreased 6 to 12 hour outages to 48 minutes or less including the Multi-Master systems with the fastest being 2 minutes of outage.
• Converted multiple single database systems to 4-node/8-node RAC as part of the migration.

Confidential

Independent Principal Consultant

• Performed general database and system administration on Oracle apps 11.0.3 Windows system for largest ATM provider in US.
• Setup backups and performed various recoveries from HW failure and application software failures.
• Provided training to developers on proper transactional management techniques.

Confidential

Senior Database Engineer

Team Lead for the 4 in house DBAs and Oracle Consulting DBAs.

• Performed tuning and analysis of Oracle EBS 11i system, OS, VERITAS, and Network for maximum 11i performance.
• Tuned and rewrote custom code from Consulting SW teams. Provided code review for 16 internal/external SW teams 90 developers .
• Wrote Automated Oracle Apps Batch job Controller to handle system workflow and Job execution of 100,000 jobs per dayto ensure revenue to the bottom line and eliminate DBAs watching system around the clock for job restarts. Eliminated 4 million/Quarter in Oracleconsulting.
• Performed tasks in the areas of server design and configuration, Oracle software installation, Oracle database creation, TAR handling, production control, tuning of the server, network, database, application, and web server, disaster recovery planning and testing, capacity planning, and project planning.
• Performed Upgrade of EBS 11.5.4 to 11.5.9. Worked with Oracle support on tuning and bug analysis for Oracle Contracts.
• Hired new DBA team. Trained and mentored DBA team members.

Confidential

Independent Principal Consultant

• Performed systems analysis and tuning on the GM OnStar Call Center application administered by EDS.
• Analyzed all queries within Siebel and their custom extensions for proper indexing and coding methodologies.
• Worked with EDSdevelopers to tune the Siebel application database and fix their custom extensions to Siebel.

Confidential

Technical Manager, West Performance Architecture

• Key engineer in repairing customer relations where customers were dissatisfied with their Oracle products. Worked with clients on plan to eliminate their problems and implemented the plan that fixed clients in less than week.
• Managed DBA teamsacross multiple clients in performing all aspects of upgradesto Oracle EBS from 10.6.1 to 10.7, 10.7 to 11.5.4, 11.02 to 11.03, 11.03 to 11.5.4 and 11.5.1 to 11.5.2-11.5.10. This included security implementation, disaster recovery implementation, configuration management, performance methodology, and platform migration with SAN environments.
• Patched, configured, analyzed and tuned Oracle EBS systems: 10.7, 11.x and 11i on Solaris, HPUX, AIX, NT, Tru64 UNIX, and Red Hat Linux.
• Analyzed, designed and implemented a new DW with Oracle Data Warehouse Builder for the 2nd largest US ISP provider in 6 weeks. Merged their new Atlanta acquisition into the Financial DW.
• Analyzed, designedand implemented a 60TB SAN for a Proteomics Y2H and Sequencing Lab/Research/DW/Web system. Worked with Proteomic scientist to redesign the data model to simplify and expand the information that was being tracked for easier analysis. Rewrote the LabTrack application code from a total JAVA implementation with Sybase to a mixed JAVA/PLSQLimplementation with Oracle and performance tuned the JVM, which decreased the amount of equipment necessary for the project from a Hot/Hot 48 processor DB system to a Hot/Cold 4 processor DB system and reduced the data foot print of the database by 60 , reduced transactions and network traffic by 75 and reduced the application server footprint requirement by 90 .
• Developed a 53 week plan for re-architecting a Drug Store e-retailer's IT processes. This included delivering 26 documents covering change control and configuration management, monitoring and capacity planning methodology, system architecture, implementation and migration to new hardware, training for developers and DBA's, and a company security policy and its implementation.
• Provided training to clients on: Advanced Queuing, Database Partitioning, Database Administration, Backup and Recovery, OPS/RAC, UNIX Performance Tuning, SQL Tuning, Advanced SQL/PLSQL, ANSI SQL, Database and Cache Architectures, and Server and Disk Configurations.
• Performed all related tasks in the areas of server design and configuration, Oracle software installation, Oracle database creation, TAR/SR handling, production control, tuning of the server, network, database, application, and web server, disaster recovery planning and testing, capacity planning, project planning, and much, much more.
• Analyzed, designed and tested various disk solutions EMC arrays, Compaq arrays, Sequent arrays, RSM2000s, Photon arrays, and Hitachi 5800s and 7000Es and backup solutions SRDF, Business Copy, Networker, Netback up, SQL Backtrack, EBU, Recovery Manager, and custom software to disk, to tape, to tape robot, and to CD jukebox for maximum performance and reliability and implemented appropriate solutions for a wide range of customers.
• Created a10TB DW database architecture and layout for a large book internet retailer. Optimized data loads for Ab Initio ETL tool. Performed query tuning and rewrite of Red Brick queries. Ported Red Brick database to Oracle 8i DW.
• Setup, configured and tunedweb servers: OAS 3.0.x, OAS 4.0.x, Apache, 9ias and iPlanet web.Troubleshoot and performance tuned JSP, CGI, JAVA, and DHTML and benchmarked JSP with JAVA cache/threads through OAS.
• Configured and tuned servers for use as database servers, file servers and web servers. Installed and configured Solaris, RHEL, VERITAS Foundation Suite andSun Cluster 3.0. Configureda Hitachi SAN withMcdata switches.Performed Daily maintenance activities for all UNIX/Linux servers.

Confidential

Senior Database Engineer

Team Lead for the 2 in house DBAs and the 2 contractor DBAs.

• Implemented Oracle ERP 10.7 from Mainframe based finance system.
• Performed extensive monitoring and tuning of databases and applications, especially Auto Invoice 60,000 invoices/300,000 lines per day , AR/GL Transfer 1.75 million lines per week , Journal Import, Recurring Invoice, Customer Merge, and creating queues, work shifts and queue balancing for book close performance for a transportation company.
• Worked with Appworx, cron, and custom coding for scheduling Concurrent Manager Jobs and external UNIX tasks.
• Worked extensively with Oracle AR development for balancing and data corruption issues in Oracle Apps.
• Performed production tasks with custom written scripts/programs and with Chain Link Migrator/Kintana and code source control in PVCS, CVS, and Perforce, migrations and set up of responsibilities, menus, report groups, concurrent programs and executables, value sets, alerts, packages and procedures, tables and indexes, RDFs, and shell scripts.
• Developed Failover plans for Company Oracle DR Failover.
• Performed multiple test runs of Y2K failover plans for all Open Systems Databases to cross country SunGard site.

Confidential

Senior Database Engineer

Team Lead for a cross functional DBA and System Engineering team including Ernst and Young contractors.

• Worked with a Team of developers on architecture, design, and implementation of an Insurance Call Center application.
• Worked with ESRI GIS vendor for customer location mapping for Call Center application.
• Designed and created ETL load programs for monthly US Postal Service Zip Code downloads.
• Wrote package for generating Sybase SQLAnywhere load from Oracle for migration to the end user's workstation to support PowerBuilder applications and localized data access. Worked with windows team on SMS deployment of finished database.
• Worked with a team of DBA's to implement advanced replication between Portland, OR and Amarillo, TX to create a never down Insurance Call Center infrastructure.
• Worked with a team of developers of migrate legacy data from the mainframe to Oracle 520GB/month for an Insurance/Marketing data warehouse. Optimized loads and packages for data cleansing. Integrated Oracle database with NCR Teradata. Wrote package for dynamic creation of partitioned tables with partitioned views in 7.3.4 and 8.0.3.
• Worked with a team of developers for enhancing and optimizing reporting from a large data warehouse with SAS, Brio Query, Crystal Reports, and Discoverer 3.1.
• Worked with a team of DBAs to create data marts from AR and GL to eliminate performance hits from DSS queries against production application systems.
• Worked with finance Director to create the canned reports for delivery to finance daily.
• Directed many different teams of DBA's, managing multiple production and development Oracle Applications 10.7, 11.0.x, 11.5.x /Custom databases 7.1.6, 8.0.x, 8.1.x, Informix, Sybase SQLAnywhere, and NCR Teradata 40MB - 5TB.
• Managed the NCR Teradata system.

Confidential

Senior Database Engineer

• Single DBE responsible for database architecture, design, implementation and administration.
• Performed bench marks andauthored analysis to C-Level management of the Sun server versus Sequent Numa-Q for complete re-architecture of Video Retailer's data center.
• Architected application data model for 4TB data warehouse. Designed and executed conversion from previous model with no application down time.
• Involved in designing, coding and implementing several customized reporting solutions in the area of Oracle Applications General Ledger and Accounts Payable .
• Upgraded database 7.0.13 to 7.3.4 and Oracle apps from 10.4 to 10.7 to move company to a more stable platform.
• Migrated databases from Novell Netware to SCO UnixWare.

Confidential

Database Engineer

• Single DBE responsible for the GPID manufacturing lines databases.
• Performed administration and tuning of 3 manufacturing line databases and master reporting DW.
• Wrote code to implement Oracle standby database before it was a product for Oracle for 15 minute fail over.
• Designed and programmed with packages and FASTech CELLworks a dynamic screen program for layout of forms and fields for easy modification of forms for the Phaser printerproduction line.
• Designed and programmed with packages and FASTech CELLworks a dynamic software program that allowed programs to dynamically determine their execution paths based off of manufacturing location and data within tables instead of hard coding an application.
• Analyzed and designed an application model with views and packages to completely hide the database structure from the application in order to move the application to a new data model with minimal re-coding.
• Wrote multiple modules in FASTech CELLworks: Tracking, Defects/Repair, and Test unit tracking.
• Wrote reports in InfoMaker for 3 manufacturing lines.
• Wrote multiple custom apps in PowerBuilder for the Engineering teams.