SUMMARY

• 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 PB+ systems and high-availability mission critical production business solutions, COTS and custom, utilizing architectures 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, ASO, Linux/AIX/Solaris 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.
• NWOUG Board of Directors 2017
• RMOUG Abstract Reviewer 2013 TD, 2015 TD, 2016TD and 2017 TD.
• GAOUG Abstract Reviewer 2017 TD.

TECHNICAL SKILLS

Clearances: Public Trust 8/2016

SQL Databases: Oracle 6.x - 12cR1/R2 (OPS/RAC/Exadata), MySQL/InnoDB, MariaDB, PostgreSQL, MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016, Informix Dynamic Server, Sybase, SAP MaxDB, Teradata, DB2, Netizza, SQLite, Derby, MongoDB, HSQLDB, Essbase, TimesTen, RedBrick.

NoSQL Databases/Caches: Berkeley DB/Sleepycat, Cassandra, MongoDB, Redis, Memcached, HBase, CouchDB.

Oracle Database Technology: Exadata (dcli, cellcli, exachk, dbmCLI, ipmitool, kfod, ibv devices, ibv devinfo, mstflint, ibstat, ibstatus, perfquery, env test, listlinkup, smpartition, ibdiagnet, ibdiagpath, ibdump), EHCC, ASM, asmlib, Golden Gate 11g/12c, Grid Control (srvctl/crsctl/RACcheck, olsnodes), ASM, RAC/OPS, ocrdump, Oracle Multi-Tenant Database, Data Guard/Active Data Guard, OEM 9i/10g11g/12c, emcli, repvfy, agtvfy, omsvfy, OEM 10g/11g/12c Management Packs Diagnostics, Performance, Configuration, Life Cycle, Provisioning and Patch Automation, SQL Tuning Advisor, StatsPack, AWR, addm, ASH, Linux; TDE, ASO, Oracle OLAP, ODM, Oracle Context/Intermedia Text/Text, exp/imp, Oracle Data Pump, OWB, ODI, SQL*Loader, Snapshots/Materialized Views, Multi-Master Advanced Replication, Oracle Streams, Partitioning, SQL*Plus, SQL*NET, adrci, tkprof, trcsess, dbms monitor, dbms stats, dbms resource manager, CPUs, PSUs, Bundle Patches

AWS: EC2, S3, EBS, RDS PostgreSQL, RDS MySQL, RDS Aurora, DynamoDB, Elasticache, RedShift, Route 53, Elastic Load Balancing, EMR, Cloudwatch, Management Console

Azure: VM, SQL Database, DocumentDB, Redis, HDInsight, Storage Service, File Service

Google: Compute Engine, Container Engine, Cloud Storage, Cloud Bigtable, Cloud Database, Cloud SQL

VM Ware: ESX 4.0-4.1, ESXi 4.1-6.0

Citrix: XenServer 6.0-7.0

XenServer: 1.0-4.4

Oracle VirtualBox: 3.2-5.1

Oracle VM Server: 2.2-5.1

Oracle Solaris Zones: 10.x-11.x

Hardware and Operating Systems:

Oracle/Sun: Exadata x3-2/x4-2/x5-2, Oracle Enterprise Linux 5.x-7x, Sparc10 - E15K, SunOS, Solaris 2.4 - 10, Sparc T4-2/Sparc,T5-2/Sparc, Solaris 11, Sun Cluster 2.x-3.x

Cisco: Cisco UCS 510x B200M3/B230M2 VM Ware 4.5 -5.4, RHEL 5.x-7.x, MS Windows 2008/2012, OEL 5.x-7.x, Centos, Debian

IBM: X-series, RS6000, SP2, AIX 4.3-7.0 RHEL 3.x - 7.x, Debian, Centos, SUSE, MS Windows 2008/2012, OEL 5.x-7.x, Oracle VirtualBox, VMWare, Citrix Server, Solaris x86, Oracle VirtualBox

DELL: R210-R910, Win2000/2003/2008/2008 R2/2012/2012 R2, RHEL 3.x-6.x, Debian, Ubuntu, Centos, SUSE, OEL 5.x-7.x, Oracle VirtualBox, VMWare, Citrix Server, Solaris x86, Oracle VirtualBox

Compaq: 2500 - 7000, Win2003/2008, Win2000, NT 3.51, 4.0, NT Cluster, MS Windows, Novell Netware, SCO UnixWare, OS/2 Warp

DEC: Alpha, OpenVMS and Tru64 UNIX

HP: BL460c, DL360/5 - DL580/5, 9000/889, K, L, and N class servers, HP-UX 10.20, 11.0, RHEL 2.x-6.x, Debian, Ubuntu, Centos, SUSE, MS Windows NT/2000/2003/2008/2008 R2/2012/2012 R2/2016, Oracle VirtualBox, VMWare, Citrix Server, Windows Cluster, Solaris x86, Oracle VirtualBox

Sequent: Numa-Q, Numa-Q PtxDynix, SE70, PtxDynix

Disk Subsystems/SANS: Oracle ZFS Backup Appliance, Pure Storage, TinTri, Netapps FAS8000/FAS6000, EMC VBlock, EMC Symmetrix, EMC DMX, EMC Clariion, Hitachi - 5800, 7000E, 9960, and USPV, LSI, Equalogic, Copan, Sepaton, Data Domain, Blue Arc, Compellent, Winchester Systems, D-Link, HP Storage Works, Sun, Compaq, Coraid, DELL PowerVault

SAN/Interconnect Switches: McData Director 6064, Brocade 5100, Qlogic SanBox 9000

InfiniBand Switches: Sun Datacenter Switch 36, Sun Datacenter Gateway 36, Qlogic 12000, Mellanox MTS3600

Network Switches: Cisco Catalyst 4948Methods and Techniques: Development Life Cycles Agile Extreme Programming, Scrum, Scrum-ban, Waterfall, Spiral, RAD, Six Sigma, Rational Rose Unified Process, Shainin System, Coad/You'redon Method, Rumbaugh Method

Software and Tools: Oracle Designer, Power Designer/Power Designer DW, CA Erwin Data Modeler, SQL Developer, SQL Navigator, Oracle Data Integrator, Name server, Business Objects, PowerBuilder, InfoMaker, OAS, Oracle 9ias, Oracle Fusion, Oracle Gateway for Teradata and DB2, BTEQ, Teradata FastLOAD/MultiLoad, PGP, ssh, VNC, Toad, Remedy, Service Now, JIRA, IBM Rational Team Concert

Linux/UNIX Tools: snoop, tcpdump, snort, wireshark, traceroute, arp, dig, awk, gawk, sed, ifconfig, netcfg, nslookup, nsupdate, finger, rpm, git, rsync, sudo, top, vmstat, iostat, nfsstat, sar, netstat, portmap, strace, truss, sundiag, tar, ssh, scp, rcp, rlogin, rsh, ftp, ping, telnet, grep, fgrep, ps, pstree, screen, script, diff, sdiff, chattr, bzip2, gzip, gunzip, cpio, dd, crontab, cvs, svn, dmesg, chattr, chmod, mkdir, cd, rm, du, df, dump, e2fsck, fsck, fdisk, find, free, fuser, halt, hostname, hexdump, od, hwclock, kill, killall, last, logrotate, lsattr, lspci, last, lsmod, modprobe, md5sum, mount, umount, more, mkfs.ext3, mkfifo, mknod, nice, renice, pwd, passwd, quota, swapon, swapoff, sysctl, tail, tee, touch, useradd, userdel, usermod, vi, vim, uname, uptime, wget, cat, zcat, multipath, udevadm, iptables, ntp, smit, chkconfig, service, svcadm, svcs, snmpget, ssh-keygen, imageinfo

Windows Tools: SQL Server 2008/2012/2014 Management Studio, SQL Server 2008/2012/2014 Tuning Advisor, SQL Server 2008/2012/2014 Profiler, Remote Desktop, RedGate SQL Suite, MS Visual Studio 2015, PSSDiag

Languages: PL/SQL, Python, HTML, Perl, korn shell, bash, FASTech CELLworks, PowerScript, Boreland Delphi/Pascal, C, C++, Java, JCL, COBOL, ISM

Other: Hadoop, Pig, Hive, Flume, R, RODM, GFS, AFS, Performance Tuning, Bench marking, GIS, Document Storage

Compliance Standards: HIPAA, PCI

DW, DSS and OLAP:

Reporting: Tableau, Cognos, OBIEE, Oracle Discoverer, Brio Query, Crystal Reports, SQL Developer

ETL Tools: Golden Gate 11g/12c, DBMoto 8.5, Informatica, Oracle Data Integrator, Pentaho Kettle, Oracle Warehouse Builder, Ab Initio

Servers: Oracle Express Server, Red Brick

Techniques and Methodologies: Data Warehouse/Data Mart Design and Implementation, Partitioning, OLAP, Star Schema, Snow Flake Schema, Bit Map Indexing

Backup Software: Symantec NetBackup and Backup Exec, SQLSafe, IBM TSM, Avamar, Legato Networker, Amanda, Bacula, BakBone, NetVault, CommVault, BMC SQL-Backtrack, EBU, RMAN, Oracle Secure BackupsTape Libraries/Backup Appliances: Sun L40, L700, L1400, SL500, SL8500, Storage Tek PowderHorn, HP ESL9595, MSL5060, FalconStor, Data Domain.

HA: Exadata, RAC, Data Guard, Active Data Guard, Golden Gate, Oracle Streams, Oracle Advanced Replication (Multi-Master), Oracle Materialized Views, Red Hat Cluster, VERITAS Cluster, Sun Cluster, HACMP, Distributed/Partitioned Databases, Quest SharePlex, MSSQL Server Cluster.

Monitoring and Administration: Enterprise Manager/EM Grid Control 9i/10g/11g/12c, HP BSM, Tivoli, Nagios/Cacti, Xenos, Zabbix, Open NMS, BMC Patrol, Quest Foglight, Big Brother, Puppet, Chef, Aris Defrag, Bradmark DBGeneral, UC4, Chain Link Migrator/Kintana, Appworx Scheduler

EBS: 10.x, 11.x, 11.5.1 - 11.5.10, System Administration, Installation, Cloning, Patching, Accounts Receivable, Payables, Global Accounting, Assets, Order Entry, Build of Material, Engineering, Project Accounting Core, Project Accounting Contracts, General Ledger, Alert, Multi-Org, HR, Payroll, Work Flow, Capacity and Field Service.

Other Third Party Applications: Delphix, Oracle MetaSolv M6, SAP CRM/BW/ECC/Portal/Payer Direct/Governance/Solution Manager, JDA, IBM MDM Initiate, IBM FileNet, LabVantage, Oracle MDM Site Hub, Informatica MDM, PeopleSoft, Siebel, JD Edwards, Lawson, Great Plains, and Baan.

PROFESSIONAL EXPERIENCE

Confidential

DBA/DBE/Chief Technologist/Owner

Responsibilities:

• Performing 68 week OBIA for R11/R12 EBS with ODI performance tuning engagement for Fortune 500 Coffee Retailer (Seattle, WA).
• Tuned database for load performance with a 50x improvement in performance.
• Reviewed Exadata X5 setup for Oracle 12c. Implemented huge pages and tuned networking for data transit.
• Implemented a variety of tuning parameters and modifications to the Database Resource Plans.
• Performance tuned SQL and worked with the Oracle Support onsite team to fix bugs in OBIA.
• Modified ODI setup for memory and JVM on app server and provided hints for the ODI knowledge modules.
• Examined system architecture and recommended combining the X4-2 and X5-2 Exadata to maintain SLA performance of OBIEE reports. Worked with Oracle Platinum services for combination of the Exadata.
• Setup fixed routes for backup path to VDC data center.
• Performed system analysis on ORA-600/ORA-7445 on Compute Nodes and Storage Nodes. Opened/Worked SRs to root cause and patching.
• Developed and tested Transportable Table space scripts for merging databases. Implemented data cut over plan.
• Mentored and trained developers on query tuning and backfill process structures.
• Created new RAC 12c databases for TEST and DEV on X4 and X2. Ported data between databases and setup expdp backups for key points in the project to protect from load disasters.
• Performed query analysis on 40K queries for determination of correct partitioning strategy, indexing, materialized views and OLAP cube build for tables.
• Performance tuned OBIEE queries in EBS R12 standby.
• Wrote PL/SQL procedure for controlled statistics collection.
• Wrote Pl/SQL procedures implemented into ODI for replacement of ODI jobs dat couldn’t be modified to perform within appropriate timeframes.
• Performing 43 week remote Puppet automation engagement for USDA (Washington DC) for all Oracle SW components, databases and related packages or SW required for code deployment and RHEL6/RHEL7 configuration.
• VM deployment utilizing puppet, Artifactory, Github, RHEL/OEL repositories, Docker and OpenStack on Citrix, Oracle VirtualBox and VM with OEL 5.x-7x, RHEL 5.x - 7.x, Windows 7, Windows Server 2008R2/2012.
• Performed with Puppet setup/configuration of RHEL6/7 servers for Oracle, 11g/12c client deployments, 11gR2/12cR1/R2 Oracle ASM/Grid/DB server and PSU patching.
• Performed with Puppet setup/configuration of RHEL6/7 servers for Oracle Weblogic 12c and Webtier components.
• VM builds and SW installation and configuration using Vagrant, Docker and Puppet.
• Performing 33 week remote MSSQL Server performance tuning and management engagement for a Fortune 2000 Insurance firm.
• Provided all areas of Database Administration and performance tuning of Windows Server 2008R2/2012/2014, SQLServer 2008/2008R2/2012/2014/2016, iscsi and VMWare.
• Performance tuned procedures, SSIS packages, built missing indexes, and removed unused indexes/Foreign Keys reducing runtimes by 25%.
• Setup CDC replication with DBMoto from AS400 to MSSQLServer and MSSQLServer to MSSQLServer. Reduced ETL Jobs by 24%.
• Wrote procedures for data purging and purged 16 years of data in Stage and Preload batch areas reducing processing time by 28%.
• Performed 6 week Technical Review and performance tuning of AWS RDS for PostgreSQL for Devops Company (Seattle, WA)
• Reviewed SDLC and recommended changes for pre-deployment into on-premise cloud and benchmarking before deployment into AWS.
• Recommended move out of RDS and into EC2 based PostgreSQL for better performance manageability.
• Recommended design review changes to take into account public cloud infrastructure.
• Recommended testing on on-premise physical to compare to testing in the Cloud.
• Recommended index structural changes and function based indexes. Reduced runtime of queries from ~4sec to 10ms.
• Wrote plpgsql function/trigger for un-nesting of array datatype fix batch process dat was never completing to run and now completes in 45 minutes.
• Performed 6 week remote Installation and Configuration Solaris RAC Build for Finance Firm (NY, NY)
• Performing all tasks related to Solaris administration on a six node stretch RAC cluster utilizing dNFS over a Netapps MetroCluster.
• Performing setup and configuration of 6 Node Stretch RAC cluster on Solaris utilizing dNFS.
• Provided client with hardening recommendations for Solaris, Oracle 12c and Cisco IOS.
• Performed 7 week upgrade Test Lab Build for Consulting firm (Seattle, WA).
• Upgrade RHEL 6.x RAC cluster to RHEL 7.x RAC.
• Upgraded Oracle RAC system 12.1.0.1 to 12.1.0.2 on RHEL 7.x.
• Upgraded Oracle Database EE 12.1.0.1 to 12.1.0.2 on RHEL 5.x-7x, OEL 5.x-7.x, Solaris x86.
• Built 2 Node Solaris x86 Oracle 12c cluster utilizing dNFS.
• Upgraded OEM 12.1.0.4.1 to 13.1.0.0 on RHEL 6.x-7.x, OEL 6.x-7x and Solaris x86.
• Setup automated monitoring with Nagios, Zabbix and OEM.
• Configured DNS and NTP servers.
• Setup and configured RMAN, Bacula, Amanda, Netbackup and Commvault backups.
• Implemented upgrade and installation tasks through coding and configuration in puppet.
• Performed 12 week remote Data Center Move engagement for Fortune 1000 Telecommunication Company (Coppell, TX).
• Provided design and training for Delphix setup and implementation for Oracle, SQL Server and MySQL.
• Provided prime consulting team and presented to end client alternate data move methodology utilizing Oracle Data Guard, SQL Server Warm Standby and MySQL Replicas to eliminate 100s of manual steps per database and decrease downtime from hours to minutes.
• Wrote Bash scripts for fleet searches of SW installations/ running processes to compare to task list for project.
• Performed 45 week EDW engagement for a Fortune 500 US Based Telecommunication’s company (Allen, TX).
• Performed system analysis and worked with Infrastructure Architects to scope out Oracle Solaris RAC Cluster and Linux DELL RAC cluster with a new Pure Storage SAN.
• Built and managed Solaris and Linux clusters for duration of project. Built Oracle 12c Dev (Virtualized), Test (3 Node RAC) and Prod (4 Node RAC).
• Trained System Engineers and DBAs on Red Hat, udev and multi-path install of ASM.
• Trained DBAs on Golden Gate, RAC, TDE, security infrastructure and Materialized View Replication.
• Designed and delivered disaster recovery plan utilizing Oracle Standbys in Chicago DC.
• Implemented backups with Netbackup/RMAN, Incremental/Full and incremental forever along with Data Domains.
• Carrier and Engineering New Data Implementation Project:
• Performed all tasks as the Mentor Architect for both projects. Mentored 4 architects to work with the Carrier &Engineering portion of the business to properly define data elements and data model to convert the M6 Meta Solve System and other related Order systems into the EDW.
• Worked with client DBA team to setup Golden Gate for Oracle to Oracle replication and worked with Informatica Admins for setup of Power Center replication from DB2.
• Took over code components dat the client ETL team couldn’t meet the project schedule on. Wrote 3500 lines of PL/SQL code dat generated 120K lines of PL/SQL code for a 192 historical type 2 tables from the delta Golden Gate data. Wrote multiple 2000+ line PL/SQL packages to perform standard business logic transformation from the historical data into the Dimensional Model. Provided developers performance tuning and query modification porting Cognos and Spotfire queries from Teradata to Oracle.
• 58TB Teradata to Oracle conversion project:
• Performed analysis on all tables, indexes, views, procedures, macros and security setup.
• Performed code modifications to the programs for Data Model conversion from Teradata to Oracle and converted all objects.
• Built 83 new schemas in Oracle system and ported the code base into the Oracle system from Teradata.
• Installed Golden Gate for Teradata and Golden Gate for Oracle and implemented cross communication, along with Oracle Data Integrator 12.1.2.
• Implemented Golden Gate for transporting Type 2 tables and utilized ODI 12c for tables dat were Type 1 nightly load tables. Performance tuned loads in Golden Gate and ODI.
• Worked with and modified code for the Informatica Dev team to port Informatica workflows from Teradata to Oracle.
• Ported four schemas and trained the junior consulting DBA team the process for data movement and object conversion.
• Installed and configured R for Oracle connectivity with RODM. Tested R routines used for Teradata reports against the Oracle database.
• Performed 8 week remote Performance/ Equipment engagement for a Fortune 1000 US Credit Bureau (Chicago, IL).
• Analyzed and recommended different equipment configurations for a 4/8 Node RAC clusters to replace a 120TB DB2 Mainframe EDW.
• Worked with client’s Architects, System Engineers, Network Engineers, Virtualization Engineers, Storage Engineers and DBAs to performance tune every component for both virtualized and physical equipment utilizing the actual workload from the production systems to benchmark configurations and guarantee a 2 year growth estimate.
• Worked with DBAs/ Developers on performance tuning the application.
• Trained System Engineers on installation of ASM on Red Hat with udev rules and multi-pathing and DBAs on RAC configurations.
• Performed 6 week assessment/project planning engagement for Fortune 500 US based Telecom (Allen, TX).
• Assessed cost, data model and system efficiency, effect on current and near future projects.
• Provided specific plan and equipment comparison/ design to move from a Teradata EDW to Oracle EDW to eliminate expensive appliances along with evaluating the companies personnel’s participation in the plan instead of a completely contractor based project.
• Performed 26 Week Test Lab Build for Consulting firm (Seattle, WA).
• Setup accounts for AWS, Azure and Google clouds.
• Built out servers in Public Cloud with RHEL 6.x-7.x, OEL 6.x-7.x, Solaris x86 10.x-11.x, Centos 7.x, Windows 2008R2, SUSE 11.x.
• Built out servers in private cloud with Citrix Server, VM Ware, Oracle VMBox, Oracle VM Server for x86, Xen and KVM. Deployed VMs with RHEL 6.x-7.x, OEL 6.x-7.x, Solaris x86 10.x-11.x, Centos 7.x, Windows 2008R2, SUSE 11.x.
• Installed, deployed and configured Oracle Database EE 11.2.0.4 and 12.1.0.1.
• Installed, deployed and configured OEM 12.1.0.3.1.
• Installed, deployed and configured MongoDB, Cassandra, PostgreSQL, MySQL
• Implemented upgrade and installation tasks through coding and configuration in puppet.
• Performed 47 week database and systems engagement for a Fortune 19 retailer (Issaquah, WA).
• Took client from 2 Oracle databases to over 150 Oracle databases across 20 Modernization projects as the Database Platform of choice with private cloud, dedicated equipment and Oracle Exadata.
• Assisted Linux/AIX team in writing puppet module for building SAP/Non SAP RAC/Single Instance systems, testing of configurations for both physical and virtual servers and porting puppet modules to AIX RAC.
• 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.
• Setup and tested Delphix Database Virtualization. Trained the Test Data Management Team on its usage.
• Authored client Oracle Database Specification document including lun layouts, AIX, VM Ware and Linux OS configurations, packages list, users/groups, directory structures and SW layouts, sudo privileges for DBAs/DBEs.
• Tested and recommended Exadata X3-2/X4-2 for the future platform of choice.
• Performed all tasks related to Exadata Machine Administration.
• Installed /Configured OBIEE 11.1.1.7 for comparison to Cognos. Provided developers support in examining feature differential and query tuning in Oracle.
• Installed/ configured OUD POC. Created automation for system admin tasks and tested deployment into Dev, Test and QA fleet. Tested performance and scaling. Recommended for acquisition in next contract purchase cycle.
• Over 6 months, evaluated 1000 resumes, interviewed 72 DBA/DBE candidates of which client made offers to 12 candidates and 4 DBAs/1 DBE accepted the offers.
• Built 6 RAC clusters and migrated SAP databases for the CRM, BW and ECC landscapes. Converted all SAP systems to TDE (encrypted table spaces) with BRSPACE, upgraded databases from 11.2.0.3.0 to 11.2.0.3.7 and designed/modified DNS database server names to standard c-name architecture for standby flips and future move to the Exadata. Worked with Oracle ACS SAP COE to verify RAC systems were built to SAP specifications.
• Worked with Linux/Cisco Engineering team to get RAC physical servers working across Cisco Frames.
• Worked with VM Ware/ Network Engineering teams to get RAC to work on VM Ware. Tested setup with Basis team. Went through multiple rehearsals of conversion of landscape systems to RAC and implemented RAC for the production landscapes.
• Member of Architecture team to examine public versus private clouds. Performed benchmarks of AWS systems for apps and databases.
• Worked with the IBM MDM Initiate/ IBM FileNet team on install and configuration of databases.
• Worked with WebSphere team on connectivity for IBM applications.
• Worked with multiple DEV teams on data model designs and writing PL/SQL procedures/packages for ETL.
• Benchmarked ASO with TDE and column level encryption versus no encryption. Worked with Enterprise Architecture to write the Database Security Encryption Standards document requiring TDE 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.
• Trained Java developers on connecting, working with Oracle and DB2 versus Oracle differentials.
• Trained the Data Modeling team on differences of Oracle to DB2/Netizza /MS SQL Server. Determined best practices of dealing with Oracle systems based on current processes on DDL code generation from Power Designer.
• Reviewed thousands of SAP notes to create SOP for the DBA team to work within the bounds of SAP rules while properly administering systems from an Oracle perspective allowing uniform administration of all Oracle systems.
• Took over backups from Basis/Accenture teams for SAP project databases to meet compliance requirements, project sustainability and eliminate problems with their current setup. Took over system refreshes from Accenture team for SAP databases cutting time by 75% 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 and ASO, Linux scripting, PLSQL and SAP on Oracle.
• Installed and implemented Oracle OEM 12.1.0.3.4 for 150+ database fleet.
• Designed and reviewed new Oracle backup code dat utilized RMAN instead of exports.
• Worked extensively with the Enterprise Backup Team, 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.
• As Enterprise Architect authored document on Schema as a Service (SaaS) and Database as a Service (DaaS). Implemented SaaS and DaaS, decreasing schema and database deployment from 8 days to less TEMPthan an hour.
• Performed HIPAA audits and security enhancement of systems to meet all compliance requirements.
• Upgraded 2 Oracle Standard Edition RX databases to Oracle Enterprise Edition by use of materialized views.
• Performed 20 week installation and replication engagement for Delphix for the largest Cruise Lines in the world, (Seattle, WA).
• Installed Delphix on Cisco blade servers with VM Ware 5.x and migrated all databases from old Delphix Server.
• Cleaned up problems with the backup configurations of the databases on Linux and AIX.
• Installed and Configured Delphix Replication servers in Florida.
• Trained the DBA/Unix/Storage team on the Delphix system and operations management of database on Linux/AIX.
• Performed 36 week Database/System analysis on a 4 node RAC cluster for Mobile Market client (Seattle, WA).
• Managed database systems until client DBAs could be hired.
• Trained DBA team and assisted in their 11g upgrade and Red Hat 5.x to 6.x OS upgrade.
• Trained System Admins on RHEL used for databases versus Ubuntu used for app servers.
• 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 of the 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 Fuji Film Global 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 2 week remote troubleshooting and patch analysis support for Global Institutional Investment firm (Boston, MA).
• Performed 24 week analysis/performance tuning an 8 node RAC system for the second largest Internet Ad retailer (San Jose, CA).
• Made recommendations for changes to the Database and OS parameters along with portioning changes to tables.
• Examined NFS Netapps Storage and worked with Netapps Engineering on changes to configuration for a 23% performance boost.
• Examined ETL load code and modified code and processes decreasing load times by 77%.
• Performed 20 week database/system analysis and Data Center move engagement for the largest Internet IP Telephony provider (Holmdel, NJ).
• Reviewed future projects and direction with team and provided training to the database team on different technologies and Oracle 11g.
• Designed and performed regional data center move of database systems from NJ to NY with less TEMPthan 2 minutes of downtime.
• Performed 3 week remote data block level repair, database recovery and data extraction from 10g database dat was down from corruption without backups for an equipment manufacturer (Ellijay, GA).
• Performed 2 week remote system analysis and system repairs on EBS11.5 for large golf club manufacturer (Moline, IL).

Confidential, WA

Database Engineer

Responsibilities:

• 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 ONE Command install and 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 Exadata balancing memory to flash performance trade-offs.
• Worked with Oracle ZBA Engineering /Oracle ACS Platinum Services to design InfiniBand network for a ZBA SAN along with optimal performance design to achieve 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, DBA activities and data model designs.
• Designed and Implemented Exadata/ZBA Database Backup architecture. Architecture implemented utilizing 3 InfiniBand networks for the multiple Exadatas and an Infiniband network for the attached TSM Backup system for offsite tape storage to create a ZBA SAN.
• Benchmarked Exadata for future use as the replacement of the 140TB EDW IBM Mainframe. Tested Exadata features: EHCC, Flash Cache, Smart Scan Predicate Filtering, Smart Scan Column Filtering, Storage Indexes.
• Migrated Oracle SAP Databases CRM (25TB), BW (10TB) and ECC (12TB) to Exadata X4-2. Migrated ODS (25TB) and ETL (40TB) 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 Non PROD. Prepared plans for migration of rest of fleet to the Exadata.
• On migrated database moved tables to EHCC where beneficial.
• Performed all tasks related to Exadata Machine Administration. Performed system, network and database administration for 4 Exadata X3-2 and X4-2 systems (11.2.0.3.22 BP22 and SAP Bundle Patch Sep2013, 11.2.0.4.6 BP6 and 12.1.0.1.3 BP3 ) along with the 2 ZBAs, multiple management, jump and gateway servers along with the InfiniBand 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 forward looking projects with Cloudera Hadoop and Exadata systems. Examined VM Oracle databases for rapid ETL/BI construction /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 issues for Oracle 11g/12c RAC on VM Ware/Linux, Linux Physical and AIX. Built 21, 3- 6 Node RAC: 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 issues for 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 Basis team to ensure systems worked.
• Worked with the Test Data Management team on evaluation of database virtualization solutions including Oracle, Delphix, VM Ware and EMC. Worked with Delphix Sales and Engineering team on sizing systems and training for Costco personnel. Worked with VM Ware 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/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/SAP Corporate/Support for exemption on use of SAP Diagnostic agent on database servers eliminating security threats from components dat 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 to the database, enforcement of role based security with PL/SQL package dat checked for and fixed 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: Costco Database Security Policy, Costco Database Architecture Policy and Costco Database Backup Policy.
• Member of the Costco Infrastructure Center of Expertise. Authored the Engineered Systems Operational and Support Policy for the Oracle Exadata, Oracle ZBA and IBM Pure Scale.
• 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 new OEM 12c (12.1.0.3.4) systems. Installed and registered all agents with new system. 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, Seattle, WA

TEMPPrincipal Systems and Database Engineer

Responsibilities:

• Set the technical direction for the Infrastructure and Techops Teams.
• Designed and implemented the unified architecture and best practices for development with the SW TEMPPrincipal 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 dat the application was spread across the building blocks to achieve 99.999% uptime.
• Designed and implemented 40 Gb point to point network and VOIP infrastructure in the New Jersey consolidated data center to handle 100 million calls per month. Engineered 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 dat 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 Database vendors DB2/Oracle and architectures for Engineering. Authored recommendation document to C-Level.
• Installed/Configured OBIEE 11.1.1.3 and Cognos 8.4 for developer team comparison of features for Mobile app reporting. Assisted developers in testing features and converting SQL reports into each tool for business review. Prepared system level and licensing comparison for C-Level.
• Installed/Configured ODI 11.1.1.3, IBM Datastage 8.7 and Pentaho Kettle 3.9. Worked with Developer team on classifying feature and performance differentials and prepared system level and licensing 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 infrastructure engineers to virtualize fleet with KVM and implement 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 architecture for $3.75 million and delivered project on time and under budget.
• Built math models to determine when the AWS cloud was/ wasn’t cost effective versus our internal cloud causing migration many projects back in house based on cost analysis. Migrated DEV projects to the AWS cloud.

Confidential, Seattle, WA

TEMPPrincipal Persistence Engineer

Responsibilities:

• Provided design, implementation and administration of Oracle/MySQL/PostgreSQL/DB2/Memcached/Sleepycat database systems on physical, E-Commerce cloud, AWS cloud and Affiliate systems.
• 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.
• 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 patch set 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 32/64 bit upgrades and RHEL 4/5 upgrades with minimal downtime.
• Tested new Oracle products for determination of inclusion in our Oracle licensing: ASO with specific testing of Oracle S3 backups, OID, TimesTen, Active Data Guard, Oracle Secure Backups, Real Application Testing, Database Vault, Golden Gate and ODI for replacement of Materialized View replication across the fleet.
• 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 written in perl supporting 700+ developers for self-service access to database monitoring, schema comparison, SQL explain plan and index analysis.
• Provided vacation on call coverage for DBA teams across the company.
• Performed 4 to 6 TEMPPrincipal Software reviews per year with other TEMPPrincipal Engineers for teams around the company.
• Provided review at initial design, development and go live. Projects included: AWS SimpleDB, AWS EBS, AWS Payments Services, AWS Mechanical Turk, Global Payments System HA (Oracle Streams), Merchant Services Messaging Architecture, AWS Glacier, AWS Import/Export, AWS SQS
• Provided Code reviews for a variety of applications for teams across the company in Ruby, Java, C++ and Perl.
• Provided extensive root cause analysis and post mortems of all high severity events.
• Defined root cause setup in Remedy and resolved 57% of all tickets for 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 automated repair code to replace manual SOPs.
• Performance tuned OBIEE 10.1.3.4 for 8TB data mart. Memory settings and parameters for OBIEE server configuration. Modified report construction on shifting workload to database server from middle tier. Explain plan analysis for all running reports and recommendation for new indexing and SQL rewrites. Setup alerts for long running reports.
• 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.
• Installed/Configured 11.1.1.3 for developers to test new features. Developed plan for 10.1.3.4 migration to 11.1.1.3, upgrade versus fresh install/data port. Installed/Configured ODI 11.1.1.3 for data port and tuned historical loads.
• Created detailed plans for a.) 11.1 to 11.2 Upgrades, b.) Grid/EM replacement of current monitoring infrastructure, c.) Productionized Development Environment, d.) ODIN security project, e.) Schema synchronization between PROD and DEV, f.) Creation of golden schemas for each database type, g.) Partitioning project for MYO systems, h.) Container development databases, me.) Streams/Golden Gate HA databases, j.) Increase Database Availability from 99.97 to 99.999.
• Responsible for 3 System Engineers.
• Responsible for World Wide backups and long term archiving at Amazon.
• 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.
• Designed, implemented and managed Solaris 10.x/Sun 3.x clusters for ACSLS control of SL8500 libraries.
• Maintained 25PB of cold storage on tape and 6PB of 30 day transient storage.
• Responsible for the OL-NFS fleet (1.5PB disk) dat 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 10Gb application at Amazon.
• Negotiated pricing and contracts with vendors for Tape libraries and media creating a new architecture dat was 10x less expensive TEMPthan AWS S3 disk storage and contained more storage TEMPthan S3, while also being 3x less expensive TEMPthan Glacier Storage and would be profitable 4x as fast.
• 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.
• Responsible for 3 System Engineers.
• Responsible for defining the repair processes dat 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 to maintain VAR status for part replacement, earning Amazon $3.2 million per year, 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.
• Global Call Leader for 5 years. One of twenty-two Global Call Leaders worldwide on call 2 days per month.
• Global Call Leaders are engaged based on each business unit’s failure, SLAs or when their is an order drop outside of prediction dat has not recovered in 5 minutes or their is more TEMPthan 25% order drop dat has recovered but root cause is not known within 15 minutes and for any DOS attacks.
• 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 to ensure dat we drive to determining root cause and ensuring follow through on eliminating the root cause of any site impacting problems.
• Only TEMPPrincipal Engineer on call 365x24 for SEV1/2 Oracle/System problems globally at Confidential and its Affiliates.
• 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.
• Performed Oracle block/redo stream hex editor repair from corruptions caused by system crashes, Oracle SW bugs, HW problems or human error. Only external engineer to Oracle dat Oracle Support fully supports databases repaired by this method.
• Designed and Implemented first 10Gb application at Amazon (2006).
• Designed new Tape Backup Architecture dat scaled to 6PB of backups per month.
• Designed and implemented Self Service backup system.
• Trained new Archive and System Engineers on backup SW and Tape Libraries.
• 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.
• Worked with AWS/Finance VPs to examine Disk vs Tape for cold storage (long term retention of data).
• Created and provided output from my Mathematica models for tape libraries and human/tape archive processes.
• Worked with Data Center engineering to examine different setups to decrease cost for tape and disk infrastructure.
• Visited IBM lab in AZ and worked with IBM Zurich engineering team on reliability models for tape at high temp.
• 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.
• 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.
• Created Mathematica Models capacity plan for the Merchant Service’s Database fleet project the next two years growth, hardware requirements and tuning opportunities.
• Worked with finance on the business justification and changes to Amazon S-Team 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).
• 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 upgrade process decreasing the outage time from 52 minutes to 20 minutes on average with fastest upgrade being 16 minutes. Provided information to Oracle Development to cut the catalog upgrade time from 12 min to 6 min.
• 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.
• Examined alternative server architectures or accelerators to achieve a 5x price performance gain over current technology.
• Traveled to vendor labs to perform quick 3 day engineering 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.
• Examined how far the separate application components of the Amazon E-Commerce stack could be separated into smaller distributed data centers to effect 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 for 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 various components under similar extended conditions.
• Planned and implemented move of database/app servers between data centers and 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.
• Worked with various vendors (Teradata, Greenplum, Netizza, HP, Sun, Dell, IBM, 3PAR) 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/64 node EDW RAC systems utilizing EMC Symmetrix/DMX and HP24000/Hitachi disk arrays and Ethernet or InfiniBand interconnects. Systems varied in size from 10TB to 1PB.
• Designed 1PB DW with InfiniBand interconnects and SSDs.
• Worked with the Amazon DBA Community and hardware engineering: defined file system layouts and hardware requirements 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.
• Revamped the project and completed the last 60% of Amazon systems in 6 months.
• Wrote new snapshot based processes dat 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, Portland, OR

Independent TEMPPrincipal Consultant

Responsibilities:

• Performed database and system administration on Oracle EBS 11.0.3 Windows system for largest ATM provider in US.
• Implemented backups and performed various recoveries from HW failure and application software failures.
• Trained developers on proper transactional management techniques.

Confidential, Englewood, CO

Senior Database Engineer

Responsibilities:

• Performed tuning and analysis of Oracle EBS 11i system, Solaris OS, VERITAS, and Network.
• Configured Veritas Cluster SW for proper failover groups for a 4 node cluster.
• Tuned/ rewrote custom code for SW teams. Provided code review for 16 internal/external SW teams (90+ developers).
• Wrote Automated Oracle Apps Batch job Controller for system workflow and job execution of 100,000 jobs per day to ensure revenue to the bottom line and eliminated $4 million/Quarter in Oracle consulting for system monitoring.
• Performed tasks in the areas of server design and configuration, Oracle software installation, Oracle database creation, SR 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/bug analysis for Oracle Contracts.
• Hired new DBA team. Trained and mentored DBA team members.

Confidential, CO

Independent TEMPPrincipal Consultant

Responsibilities:

• 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 EDS developers to tune the Siebel application database and fix their custom extensions to Siebel.
• Worked with System Admin team for performance tuning of Solaris database servers.