| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Renton, WashingtonPHONE NUMBER AVAILABLE (cell)EMAIL AVAILABLEView Candidate's Name 's profile on LinkedInProfessional SummaryOracle Exadata Architect, Apps DBA, Database Engineer, Persistence Engineer, Systems Engineer and General Technologist with 24 years of experience including:Extensive DevOPS, 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, Delphix Admin, Oracle EBS/Peoplesoft DBA, Oracle Weblogic Administrator, Database/Systems Administrator RAC/SI, Exadata Architect, Exadata Machine Administrator, ExadataVM Cluster/VM linux admin. MySQL/MariaDB and Aurora admin. ExaCC/ExaCS/Exadata Performance Analyst, Network Architect, Data Center Solution Architect and ETL Developer.Designed and utilized statistical models for Capacity Planning, Benchmark analysis and application testing to create deterministic systems ensuring scalability and uptime.Designed multiple ETL frameworks and processing for large scale DW and anlytic processing with R, AI and various custom programs to generate data sets for various reporting tools.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, 2018, 2019, 2020,2021, 2022, 2023RMOUG Abstract Reviewer 2013 TD, 2015 TD, 2016 TD, 2017 TD, 2018 TD, 2019 TD.GAOUG Abstract Reviewer 2017 TDExperienceDimensional DBA, LLC 2005 CurrentDBE/DBA/Exadata Systems Engineer/Exadata Architect/Cloud DBE/Cloud DBA/Apps DBA/Chief Technologist/Owner-Performing 138 week (4/2021 Current) Exadata Architect, Exadata/ZFS/ZDLRA/BDA Administration for 12th largest managed investment firm (Newport Beach, CA)-Performed as Service Owner/Architect of the Oracle Appliance platforms: 15 Exadata/ 4 ZFS/2 ZDLRA/4 BDA clusters-Provide design and security architecture to meet Finincancial and SOX compliance requiresments.-Provided Patch document/process and automation scripting for Exadata/ZDLRA patching and KVM patching of VM hosts and guest. Trained two offshore consulting teams on patching Exadata/ZDLRA.-Provided analysis and recommendation for consolidation onto VMs on Exadata.-Managed the Oracle Vertical and DBA Coordination meetings on Activities surrounding the Oracle appliances.-Worked with the Oracle Support SSC team on SRs surrounding the Oracle appliances.-Developed 2021/2022/2023 Work/Task plans in Jira/Wiki for the platforms.-Performed all tasks related to Exadata Machine Administrator.-Performed patching of Exadata/ZDLRA/ZFS appliances and patching the Dom0/Domu on the Exadata clusters.-Moved appliances into Quarterly patching cycle.-Supported DBA team in the 19c upgrades of the databases and Goldengate replication issues.-Performed security patching with rpm and uptrack updates to the Exadatas/ZDLRA.-Wrote puppet manifest and ansible playbooks for configuration of Exadata and Dom0/Domu.-Performed OEDA for Exadata X8M/X9M, ZDLRA x9M and config document for ZFS7.-Performed post install work for Exadata X8M/X9M, ZDLRA x9M, ZFS7 for Kerberos/AD/LDAP connectivity, sudo privs for DBAs and configuration/patching for GRID.-Provided Tier 2/3 support to the Admin Consulting firms and part of the oncall for the systems.-Worked with the Network team on troubleshooting NFS perf problems for the AFS/NFS databases and Goldengate data transmissions. Wrote analysis/monitoring scripts for the SFP light levels and worked with Network team on GetWell Project to uplift the Exadatas to 100G Data network.-Worked with OEM Service owner to eliminate non-actionable Pager-Duty alerts and to modify the alert thresholds for actionable alerts.-Worked with DBAs for perf tuning VMs, Systems and databases.-Performed 148 week (03/2021 - current) Oracle/MSSQL Architect, OCI/Azure Architect, Oracle/MSSQL DBA for a multi-bank/Federal Reserve (Charlotte, NC)-Managed Oracle, MSSQLand MySQL databases for 5 banks, 1 insurance company and the Federal Reserve Settlement System.-Replaced on-prem DBA team with our companies offering for managed DBA services.-Provide Financial and SOX compliance for the Os and databases.-Patched Oracle/MSSQL/MySQL systems. Created automation scripts to assist the patching and ensure that patching completed within the outage window. Previously patch windows were blown for each patching. Currently patch window has shrunk to completion with 5hrs on patching both production RAC clusters together.-Performed deployment of schema and code to Dev-PROD for Oracle/MSSQL/MySQL.-Performance tuned SQL-PLSQL/T-SQL code.-Migrated MSSQL databases to Azure VMS and Azure SQL.-Migrated Oracle RAC databases to Exadata VMs in OCI.-Migrated Mysql to Aurora DB in AWS.-Upgraded 11g/12.x databases to 19c.-Two-person oncall team.-Architect for Databases in Azure/OCI/AWS migrations.-Worked with automation team on delivery of MSSQL in Azure.-Installed MongoDB for new dev team search project.-Performed day to day management of MongoDB.-Negotiated with OCI Cloud team on licensing and movement of Databases into OCI.-Worked with other Architects on SW deployment in Azure/OCI/AWS.-Moved Oracle databases to OCI and MySQL databases to Aurora on AWS..-Worked with C-Level on Database cloud differences and costing between the clouds while also presenting Tri Cloud architecture.-Performed 60 week (05/2022 11/2023) Exadata Machine Administrator/Oracle RAC DBA (San Francisco)-Performed system analysis for performance and space utilization.-Maintain SOX compliance scripts for Hr/Financial Data.-Wrote space cleanup scripts for Domus.-Performed backups and restores of databases for standard refreshes in Peoplesoft/Maximo environments.-Responded to tickets, OEM and ASR alerts.-Opened and Managed Oracle SRs.-Performed 260 week (7/2018 7/2023) Exadata/exalytics Architect, DW Architect, Exadata/Exalytics Administration, OBIA and Oracle Apps DBA/Peoplesoft Administration, Project Support, HCM, Documentation and Transition to Shared services Team for County Government and management of R-Studio Pro. (Seattle, WA)-Performed all tasks related to EBS/Peoplesoft Administration.-Designed and Wrote PL/SQL and python code for loading LDAP data into the database.-Upgraded DW Databases from 12.2 to 19.10.-Worked with ODI developers for connectivity to Oracle HCM Cloud for downloading data into the On-Prem DW.-Setup POC for Goldengate HCM Cloud to on-prem.-Performed analysis of Oracle Autonomous Database for replacement of ON-Prem DW.-Setup Kerberos/AD connectivity on Exadata/Exalytics to the Oracle Database.-Performed installation, configuration and administration of R-Studio PRO.-Performed setup and implementation of OEM 13c with associated plugins for Exadata, EBS and OBIA.-Wrote extended monitoring scripts for OEM for Oracle apps and database.-Upgraded python and R versions on the servers.-Setup Goldengate for Oracle to Azure Cloud.-Setup Real Application Security (RAS) for Peoplesoft (HR) data in EDW, providing row and column level-controlled access to restricted PII implemented through security groups, ACLs and roles. Wrote RAS CLI scripts to migrate RAS setup between environments.-Rewrote R python scripts for analytics team to improve performance.-Performed all tasks related to Exadata/Exalytics Machine administrator.-Wrote puppet modules for management of configs of Oracle DB, Oracle Weblogic, SVN and Kerberos setup.-Worked with Oracle Platinum Services for patching the Exadatas/Exalytics.-Tested and Implemented IB network connectivity from Exalytic to Exadata connectivity.-Performed bug tracking and problem/resolution with jira.-Wrote PL/SQL procedures so that Tableau and Power BI could operate under the RAS architecture.-Wrote PL/SQL procedure to fix bug in VPD setup in EBS for metadata row flip data from patching.-Wrote Pl/SQL ETL transforms for data security requirements.-Performance tuned Materialized Views.-Analyzed Concurrent jobs and performance tuned custom code.-Upgraded OBIEE from 12.2.1.4 to OAS 5.5/5.9.-Upgraded OBIEE from 12.2.1.3 to 12.2.1.4.-Built out 18.x/19.x In-Memory databases on the Exalytics.-Researched and applied patches for problems encountered by the business/developer teams for EBS/Peoplesoft/OBIA.-Performed OBIA, ODI, RAS integration to Microsoft 360 AD for SSO.-Wrote AD360 Extraction code for 24 AD attributes for use in the RAS architecture.-Implemented Hot Backups for all the databases using RMAN. Implemented schema level backups for the OBIA/OBIEE repositories utilizing expdp.-Performed application/Database analysis of each environment to determine environment deviations and problems relative to the setups. Corrected the deviations to the Fusion configurations.-Converted the JVMs in each environment from Sun to JRocket for a 28% boost in application performance.-Modified JVM settings for better memory utilization in the JVM and memory utilization on the server.-Reconfigured Production database server to actually use the memory available on the Exadata and increase load performance by 36%.-Tuned queries and database structures to meet 7 second SLA for queries.-Created 56 documents to train the DBA Team on Administration of the Exadata/Exalytics, Environment, Backups, Recovery, Install, Upgrades and Patching OBIA Full Stack, RAS Security Implementation and Admin, Partitioning, HCC, Advanced Compression Strategy, Application Security.-Built 2 Complete OBIA Environments from scratch.-Tuned the In-Memory databases for better application performance.-Wrote and Implemented shell scripting for automated cleanup of file systems.-Modified RAS Code and OBIEE to utilize LDAPS for secure communication.-Wrote PL/SQL statistics collection package being called from ODI to properly gather and set statistics for consistent performance.-Wrote Ansible playbooks for SW deployment and patching.-Performing 182 week (5/2019 3/2022) Exadata Architect, Exadata Machine Administrator Oracle Consulting (Suitland, MD/Bowie, MD)-Performed all tasks related to Exadata Machine Administrator.-Setup monitoring of Exadata with OEM plugins, splunk and Solarwinds.-Wrote extended monitoring scripts for the OIS security requirements for blacklisted executables and services.-Wrote load routines PL/SQL and python for system configuration to be available for BI Publisher reports.-Wrote baseline generation program with monitoring to verify system configuration hasnt changed with AIDE and custom code and puppet automation for config maintenance.-Performed Exadata initial analysis for security setup and Support Guidelines for Exadata. Provided recommendations to remediate problems with current setup.-Implemented changes to ssh to use better encryption algorithms for eliminating POA&M deviation.-Performed all patching activities each Quarter DEV/TEST/PROD without Platinum Services for 10 Exadata Clusters including Dom0/Domu, GRID and Database patching.-Setup VM clusters.-Performed System design, OEDA configuration for 4 new X8-2/X8-8 clusters.-Baselined system performance and wrote code to continuously test performance against the baseline and send notification if system drifts in performance.-Performed Exadata upgrades from 12.x/18.x to 19.x for CELL/Compute/GRID. Wrote scripting and documented complete process.-Setup and configured Oracle R Enterprise/ OML4R for analytics data processing of Census DW system.-Worked with Developers to tune their code and built new code using R-Studio with check-in to Gitlab/SVN.-Performed bug tracking and problem/resolution with jira.-Setup and configured LDAP for user logins.-Wrote implementation and monitoring scripts in python for system administration activities.-Configured email on the servers.-Configured ASR for automatic Service Requests for HW parts replacement.-Opened and worked SRs for HW and SW failures.-Performed HW repairs of all components of the Exadata.-Setup and configured RMAN/Netbackup for backups with RMAN/Netbackup for databases and Netbackup for OS file systems.-Configured Splunk for snmp and file system data collection for monitoring and auditing.-Provided DBA team with solutions to multiple problems with email from within PL/SQL, DBFS and memory settings on the database and systems.-Performed DOD Security hardening of all Exadatas components.-Defined/Performed Linux security Baseline for Exadatas-Worked with Oracle support to develop proper Virus Scanning SW implementation for Census Bureau Exadatas-Wrote installation scripts to install scanner and Bigfix on Exadata as non-root user. Modiifed vendors scripts to make the install and operation work as non-root user.-Performed analysis/implementation to remove all 3rd party SW running as root to non-root installs.-Provide DBA team daily assistance with problems and SRs for the databases.-Provided performance tuning analysis from Hardware stack to the application stack.-Provided analysis to management for acquiring web teams Exadata/ZFS X7 appliances.-Performed 20 week (04/2021 08/2021) Oracle Exadata/PCA/ODA Admin and DBA for a 30th largest investment firm (St. Peterburg, FL)-Managed Oracle Exadata/PCA/ODA and provided all DBA support for the databases on those appliances.-Ran the 2021 DR test for the primary client databases.-Wrote automation scripting to verify all systems are ready for DR and that all services and client SCAN and tns pointers are correct.-Provided oncall and daily support to all client databases.-Provided troubleshooting, analysis and solutions to long ongoing problems at client.-Performed 60 week (May 2020-July 2021) AWS Oracle Database System analysis and Application/Database Design Scaling for online mobile bank (Sao Paula, Brazil)-Rewrote SQL procedures for PostgreSQL custom app.-Analyzed Oracle/MSSQLServer/Postgres/MySQL databases running on EC2 AMIs and RDS/Aurora in Amazon Cloud.-Reviewed monitoring of system with splunk and OEM. Recommended changes to OEM and splunk for complete monitoring of system.-Verified security setup/rpms at the OS layer.-Verified OS configurations for running different databases on Linux.-Analyzed Database and queries for all aspects of performance bottlenecks and recommended modifications to queries, indexes, init parameter changes and replication.-Analyzed database init parameters, analyze jobs, etc. to determine best practice setup.-Analyzed last 3 major outages on the system and provided root cause analysis for the outages.-Examined patching process and patch levels.-Provided recommendation on scaling the system 4x over the next 12 months, both at the database and application layer.-Performing 29 week (4/2020 10/2020) Data Center Architect Fortune 100 Insurance Company-Met with stakeholders from all application teams and business divisions to collect information on all the systems.-Examined all data stored in the BMC Helix system for configuration management.-Developed plan by business unit and by application for migrating from NYC to AWS/Oracle/Google Cloud.-Architected and Designed replication system enhancements for the database systems, Oracle, MSSQL Server, Sybase, MySQL and Postgresql.-Worked with project management team to design schedule and present to CIO.-Worked with development teams to rearchitect some applications for higher availability and lower latency to a distributed cloud architecture.-Worked with operational teams on migrating monitoring to a multi-cloud monitoring architecture and for filling gaps in the current monitoring architecture.-Setup/Configured GoldenGate to decrease downtime for move to the Cloud and to replace custom replication.-Trained DBA team on GoldenGate-Performing 244 week (2/2016 8/2020) OBIA for Oracle Apps DBA with ODI performance tuning engagement for Fortune 500 Coffee Retailer (Seattle, WA).-Performed POC for MSSQLServer in AZURE cloud for DW components to server PowerBI connections.-Architected Golden Gate Solution for Integration of OTM data into EDW. Provided configurations and monitoring setup for implementation by DBA team.-Setup and implemented Cassandra Databases for Index Searches.-Setup and implemented Mongodb for PO Document searches.-Tested and Implemented IB network connectivity from Exalogic to Exadatas-Implemented OEM and splunk monitoring for the Exadata.-Setup OBIA jobs in Control-M-Created Tested ODI and Goldengate setup to test ODIs new Goldengate integration.-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 POC for moving OBI application servers and Data Marts to Azure Cloud.-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 couldnt be modified to perform within appropriate timeframes.-Instantiated databases and Performance Tuned X-6 Exadata for ODI loads.Performed 24 week (2/2019 5/2019) DB2/SQL Server Migration to Oracle.-Performed analysis DB2/SQL Server Tables, Views and T-SQL/SQL PL for problems in code migration.-Created DDL files for DB2/SQL Server 12K+ Tables, Views translated in Oracle DDL.-Created and manually converted DDL 1200+ T-SQL/SQL PL procedures and functions.-Configured new server for Oracle.-Installed/Configured Oracle Grid/DB 19c and configured for OLTP.-Post Performance tuned system for converted applications.-Performed 4 week (2/2019 2/2019) Oracle Consulting Engagement Cloud Architect for ExaCC x-7 migrate to the on-prem cloud.-Worked with Exadata Architect to perform fleet analysis for vm sizing and scaling along with database consolidations of multiple PDB per CDB.-Had extensive meetings with client DBA about the apps and the databases to determine consolidation targets. Examined 77 databases that were to be migrated by Oracle Consulting and 154 databases that were to be migrated by the client to ensure performance on migration as they were landing on the same Exaccs.-Built schedule to allow both teams to work together on the platform to meet project timelines.-Examined Golden Gate 2way/3way Active-Active configs and errors currently existing in the fleet that Oracle consulting was going to be responsible moving during the migration.-Wrote process to handle the migration of the Golden Gate configs, not normally handled by Oracle Consulting.-Performed 105 week (11/2016 11/2018) remote MSSQL Server/Oracle/Cassandra performance tuning and management engagement for a Fortune 2000 Insurance/Banking firm.-Performed analysis of DBMoto versus Golden Gate for DB2/SQL Server Replication.-Setup CDC replication with DBMoto from AS400 to MSSQL Server and MSSQL Server to MSSQL Server. Reduced ETL Jobs by 24%.-Performed a Delphix POC for MSSQL Server and Oracle databases.-Setup/Configured and Managed 12 Cassandra Databases.-Provided all areas of Database Administration and performance tuning of Windows Server 2008R2/2012/2014, MSSQL Server 2008/2008R2/2012/2014/2016, iscsi and VMWare.-Performed/Managed backups with Commvault.-Troubleshot and Performance tuned replication problems with MSFT base replication.-Performance tuned procedures, SSIS packages, built missing indexes, and removed unused indexes/Foreign Keys reducing runtimes by 25%.-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 migration on multiple EDWs.-Performed tuning and analysis of Load jobs on Oracle EBS system. Rewrote PL/SQL routines to decrease runtime by 73%.-Performed analysis of the MSSQL DW on the Azure Cloud.-Tested Cassandra and MongoDB in the Azure Cloud.-Performed 112 week (8/2016 10/2018) 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.-Architected Puppet Oracle Deployment Architecture.-Built multiple Sandbox Puppet Masters.-Reversed Engineered Manual processes to create spec documents for puppet coding.-Configured and performed 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.-Configured and 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.-Configured and 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.-Performed 4 week (11/2018 12/2018) Oracle Consulting Engagement VM/Database performance tuning on x-7 ExaCC. Performed VM fleet configuration analysis. Performed Database setting and Application analysis. Collected and analyzed OS Watcher and AWR data along with live system analysis. Made recommendation for VM configuration, PDB moves, VM/Database memory settings, Query tuning, HCC/Compression implementation, etc.-Performed 7 week (02/2018 04/2018) Oracle Consulting Engagement Technical Review and Performance Tuning Recommendations for largest Fast Food Chain. (Oak Brook, IL)-Reviewed Database, SQLNet, ODI and OBIEE Configurations.-Reviewed RHEL6, VMWare, Network, and Pure Storage Configurations and Architectures.-Reviewed AWR Reports, alert.logs, ODI and OBIEE logs.-Reviewed current patching for Database and all infrastructure components.-Made recommendations for POC test of scale out to 950 users for new OBIEE dashboards to modify the OBIEE settings for memory and number of connections. Test and rollout to 950 stores was successful.-Made recommendations: to double the network connections as I/O was hitting the limits of a single 8Gb FCOE connection; Modifications configuration parameters on the Pure Storage and the Database to match Best Practices, VMWare changes to maximize I/O thru put and NUMA Memory Configuration; Database init parameter and RHEL6 changes to use full amount memory available, Query tuning changes to top 10 worst queries; ODI and OBIEE configuration changes for JVM.-Performed 6 week (12/2018 02/2018) Oracle Consulting Engagement Technical Review and Performance Tuning Recommendations for Fortune 500 Communications Technology Company. (Chicago, IL)-Reviewed Database, SQLNet, ODI, OBIEE and Goldengate Configurations and Architecture.-Reviewed UEL7, OVM, Network, and Storage Configurations and Architectures.-Reviewed AWR Reports, alert.logs, ODI, OBIEE and OVM logs.-Reviewed current patching for Database and all infrastructure components.-Reviewed open Sev1 SRs.-Built POC test case to simulate the database hangs happening in PROD.-Made recommendations: for 12 single bug patches to be applied, to Database init parameter and RHEL6 changes to use full amount memory available, Query tuning changes to top 20 worst queries; ODI and OBIEE configuration changes for JVM; to create 2 SOPs for production hangs and performance problems; SQLNET changes for large scale data transfers for Active DG standbys, ODI and Goldengate.-Performed 6 week (9/2017-10/2017) Exadata OVM Server/Database Performance Engagement on x-4/x-5/x-6. Examined configuration of Oracle VM Server on Exadata compute nodes. Examined VM configurations of Domus. DBIROM/Resource manager configs. Collected OS Watcher, Exawatcher and AWR information for each system/database. Performed live system analysis. Made recommendations/modifications to VMs, Databases, Query tuning and Resource manager/init tuning.-Performed 7 week (6/2017-8/2017) 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 4/2017-6/2017) 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 01/2017-3/2017) upgrade Test Lab Build for Consulting firm (Seattle, WA).-Setup accounts for AWS, Azure and Google clouds and performed build, upgrade and config task in each cloud.-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 MongoDB, Cassandra, PostgreSQL, MySQL, Marklogic databases.-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.-Setup puppet/chef/ansible infrastructure for delivery of upgraded components.-Performed 24 week (3/2016-10/2016) 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 (11/2014-07/2015) EDW engagement for a Fortune 500 US Based Telecommunications 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 |
