Candidates About

 

Matthew Parker

Professional Summary

Database Engineer, Persistence Engineer, Systems Engineer and General Technologist with 24 years of experience including:

·         Extensive technical, data architecture and systems architecture background architecting, engineering, implementing, monitoring, end-to-end performance tuning and troubleshooting complex, highly scalable, low latency, RAC 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 AD groups, LDAP, OID, OUD, TDE, 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 RAC/SI, 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, 2017 TD, 2018TD.
• GAOUG Abstract Reviewer 2017 TD

 

Experience

 

Dimensional DBA, LLC                                                                                                                               2005 – Current

DBA/DBE/Chief Technologist/Owner

 

·         Performing 91 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 RAC primary and SI standby.

-          Wrote PL/SQL procedure for controlled statistics collection.

-          Wrote Pl/SQL procedures implemented into ODI for replacement of ODI jobs that couldn’t be modified to perform within appropriate timeframes.

·         Performing 65 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/12cR2 Oracle ASM/Grid/DB server and PSU patching along STIG compliance and TDE and OID setup and configuration.

-          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 55 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 T-SQL procedures for data purging and purged 16 years of data in Stage and Preload batch areas reducing processing time by 28%.

-          Wrote T-SQL procedures for migrating tables from int to bigint for EDW.

-          Performed analysis of DBMoto versus Golden Gate for DB2/SQL Server Replication.

·         Performed 7 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 view of the system.

-          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 that 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 12 week upgrade Test Lab Build for Consulting firm (Seattle, WA).

-          Setup AWS Redshift and AWS Auroa POC. Performed basic benchmarking of Cloud versus Cloud systems and on-premise database systems.

-          Upgraded 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.

-          Implemented/upgraded Golden Gate 12.2.

·         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 TDE and Materialized View Replication.

-          Designed/Implemented Golden Gate Active-Active replication for Metadata Customer Maintenance.

-          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:

o    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.

o    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.

o    Took over code components that the client ETL team couldn’t meet the project schedule on. Wrote 3500 lines of PL/SQL code that 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:

o    Performed analysis on all tables, indexes, views, procedures, macros and security setup.

o    Performed code modifications to the programs for Data Model conversion from Teradata to Oracle and converted all objects.

o    Built 83 new schemas in Oracle system and ported the code base into the Oracle system from Teradata.

o    Installed Golden Gate for Teradata and Golden Gate for Oracle and implemented cross communication, along with Oracle Data Integrator 12.1.2.

o    Implemented Golden Gate for transporting Type 1/2 tables Performance tuned loads in Golden Gate.

o    Worked with and modified code for the Informatica Dev team to port Informatica workflows from Teradata to Oracle.

o    Ported four schemas and trained the junior consulting DBA team the process for data movement and object conversion.

o    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 two-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 company’s 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.

-          Implemented/upgraded Golden Gate 12.1.

·         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 every project gets their own database server and own private database.

-          Designed and implemented Golden Gate DB2 to Oracle, SQLServer to Oracle and Oracle to Oracle replication. Active-Passive and Active-Active.

-          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 that 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 than 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 than 2 minutes of downtime.

·         Performed 3 week remote data block level repair, database recovery and data extraction from 10g database that 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).

 

Costco Wholesale Issaquah, WA                                                                                                         06/2013 – 06/2014

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 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