SUMMARY

• Working the western US on - site or anywhere remote as a Hands-On Cloud DevOps Engineer, Solutions Architect, DBA and or Mentor.
• I am an AWS Certified Solutions Architect & Developer, Oracle Certified DBA and Oracle Certified EBS DBA R12 with more than 25 years of large & medium - Enterprise Corporate Information Systems experience, focused on enabling cloud-based solutions for the last few years.
• Additionally, many years of experience providing cloud and on-premise based enterprise solutions for OLTP & several Big Data / Data Warehousing stacks with integrations, making consistent and major contributions from hands-on, technical lead, team, and individual contributor perspectives in a wide array of vertical markets.
• Strong communication & presentation, business process development, problem solving and organizational skills.
• Significant exposure to Social Media, Government, Web/E-Commerce, Oil, Public Sector, Utility / Power, Inventory, Order Mgmt., MRP, Manufacturing Execution, Scientific, Engineering, Retail, Power, Support Systems, and Financial industries.
• Several years hands on experience with AWS cloud-based networking, application, CI/CD automation, ELB, CFN, Auto Scaling, Direct Connect, Data Pipeline, Kinesis, DB backups, DB read replicas, DR, security (IAM, and credential management via console, AWS CLI, and Python API)
• Recent and considerable experience designing, developing, tuning, AWS RDS / Redshift & Oracle based large scale OLTP databases, & Data Warehouses. Strong understanding of relational design, and star schema design (fact and dimension entities) from both the logical and physical perspectives. Many years of experience with very large transactional databases, heterogeneous feeds PL/SQL / ETL / ODS / Client facing Data Mart design and hands on implementations, both on premise and AWS Cloud.
• Many years in the trenches architecting, and implementing infrastructure, including performing capacity planning, and performance analysis for compute, SANs, Storage Appliances, and networking components to support large ERP based systems (both OLTP and DSS/Data Warehouses).
• Multiple years of LAMP stack (Linux, Apache, MySQL, PHP/Python, WordPress) experience as a DBA, Linux Sys Admin / Cloud SysOps, & Developer on-premise and in the AWS cloud.
• More than twenty years of experience provisioning, installing, upgrading, patching, tuning, and production administration of Oracle’s Fusion stack, (stack used with Oracle Enterprise Business Suite), including AIM methodology, Oracle Enterprise Database versions 6.0 thru 12c, Oracle Application Servers (WebLogic 12/11/10, & Oracle AS 10g, 9iAS) and related products (Oracle APEX, Oracle Forms, Reports, Discoverer, Oracle Enterprise Manager / OEM) and integrating with Windows Server Active Directory environments.
• Extensive experience and command of documentation tools like - Visio, MS Project, Excel, Word, and PowerPoint.
• More than twenty+ years of day to day administrative and development practice with each of the following Operating Systems: UNIX, Redhat Linux, Solaris, HPUX, AIX, Windows Server, and VMS.
• Ability to work in many different capacities to accomplish goals (e.g. Team Member, Administrator, Developer, Project Manager / Lead, Architect, QA, Presenter, Mentor etc.). My knowledge is your knowledge.
• Considerable Project Management, and Scheduling experience with a thorough understanding of the steps necessary to complete a large complex DW, and or Oracle Applications (e.g. EBS Financials etc.) migration, installation, or custom Oracle development project.
• Many years of AWS & Oracle DR, HA, and replication technologies (such as AWS RDS & ELB / ALB, RAC, Data Guard, & GoldenGate).
• Thorough knowledge of security mechanisms (on premise and AWS cloud based) available at the networking, identity management, operating system, database and application levels, assure guarantee safekeeping of proprietary information, along with single on applications / federated authentication.

TECHNICAL SKILLS

Operating Systems Administration: HP UX / AIX / Solaris / Linux (Redhat RHEL 2,3,4,5,6, CentOS, Oracle Linux, Amazon Linux) / Windows Server / Mac OS / VMS / VMWare / vSphere, Oracle VM Server / Manager, Sun, HP, IBM, Compaq, Dell, EMC, Hitachi, Amazon

Cloud & Web Hosting Environments: Amazon AWS (IAM, EC2, Route 53, S3, Glacier, EBS, EFS, VPC, Security Groups, SNS, SQS, CLI, RDS/MySQL, PostgreSQL, NoSQL/DynamoDB, Redshift / Spectrum / Glue, AWS EMR Hadoop / Spark / Hive), GoDaddy, Word Press, MS Office 365, Google cloud, Oracle Cloud (PaaS, IaaS, SaaS)

Applications Administration and Development: Administrating, Architecting, and Developing - AWS Services, Serverless, Micro-Services from console, AWS CLI & API/SDK, SAP DBA, Oracle Applications e-Business Suite (EBS)Releases 10.x, 11.0, 11i, R12.1 & R12.2, OBIEE, Discoverer, Business Objects, Extreme Volume OLTP, 100 Terabyte Warehousing solutions, ETL development, Oracle Application. Server 3, 4, 9i, 10g R2, 11g, WebLogic, Apache, Tomcat, Node.js

Database and Application Server Administration and Development: Redshift / Spectrum, SnowFlake, DynamoDB, node.js/Parquet, Hadoop / Spark / Hive RDS MySQL, MariaDB, Aurora, PostgreSQL, Oracle, SQL Server, Oracle Enterprise Database Server Versions 2,3,4,5,6,7,8,8i,9i, 10g, 11g R2, 12c, Oracle RAC 9i, 10g, 11g & 12c, 12c DBasS, Oracle Enterprise Manager (OEM), Grid, ASM, ADDM, AWR, ASH, Oracle Tuning Advisors, SQL Profile, Oracle Application Server 3, 4, 9i, AS 10g, AS 11g, WebLogic, SQL Server 2008, 2012, 2016, DB Administration SSMS, T-SQL, SSIS, Oracle Developer, Oracle Designer, BI Publisher, Work Flow, APEX, Toad, SQL Developer, JSON, YAML, ORDS, SQL, PL/SQL, Oracle Forms, Oracle Reports, AIM, Pro*C / OCI, PHPMyAdmin

Database Related Tuning: Infrastructure - Host Server Provisioning / Tuning, Networking Design, Storage Array Design, Application Tuning - Algorithm Design / Re-design, Workflow Design Refactoring, SQL / View Tuning - Optimal Index Definition, w/AWR, SQL Profiling, Explain Plan, Redshift Cluster / Slice tuning with extensive sort key, and distribution key analysis, vacuum and analyze stats, Oracle based tuning with Statistics Optimization, Partitioning, Memory Optimization (PGA, SGA), Optimizing IO Patterns and RAID Strategies for Desired Load

Oracle Support Tools, Installs, Migrations, Upgrades, Patching & Platform Conversion: runInstaller, dbca, dbua, adop, adpatch, OPatch, MOPatch, BRTools, exp/imp, expdp/impdp, SQLLoader, PL/SQL, RMAN

Data Modeling / Relation Design: 3rd Normal Form for OLTP, Star and Snowflake for Data Warehouse, and Operational Data Store Design Patterns

AWS & Oracle Related Backup / Recovery, High Availability, Replication, and Security: AWS Recovery Point Object/Recovery Time Object (RPO/RTO) Analysis using RDS, & Redshift Snapshots, RAC HA, Oracle Data Guard Failover, HP Service Guard, RMAN, VMWare, Golden Gate, BCV Splits, EMC Data Domain / DD Boost, TSM / TDB Tivoli Backup, Veritas NetBackup, Legato Backup, Transparent Data Encryption / TDE, Oracle Wallet / KeyStore

Web Design, Interface and Development: HTML, XHTML, XML, CSS, JavaScript, Node.js, Python, jQuery, HTTP, HTTPS, PHP, WordPress

VM, Development Languages, Tools & Scripting: VMWare, VirtualBox, Github, Vagrant, Ruby, Chef, Korn, Bash, Perl, DOS, PL/SQL, SQL, SQLPlus. Java, Visual Basic, C, C++, Perl, Toad, SQLDeveloper, Putty, VNC, Python, Pro*C, DNS, AWS CloudFormation

Project Management, And Documentation Tools, ITIL Service Management / ITSM: MS Office - Word, Project, Excel, Visio, Outlook, PowerPoint, Service Now, Remedy

PROFESSIONAL EXPERIENCE

Senior Cloud Solutions Architect & Oracle DBA / Developer / Architect

Confidential

Responsibilities:

• AWS Redshift, and Aurora/Postgres/MySQL, data migrations and tuning techniques using AWS Snowball (for large DWs), S3, SCT, and or DMS from very large multi-terabyte Oracle DW and smaller MySQL OLTP databases, scheduled load automation, addressing design features, application ports, performance, and security domains.
• Note: Redshift was developed by Amazon using PostgreSQL - so some features are common to both. Note I have lots of previous Ingres experience, which is a clone of PostgreSQL or vice versa. As a result, my PostgreSQL 8, 9, and 10 experience is excellent. Formally trained in Ingres.
• Amazon AWS Service experience with (IAM, EC2, S3, EBS, EFS, Route 53, Python, PHP, PostgreSQL, MySQL, WordPress, Apache, Amazon Linux 2 LTS, CFN, CloudFormation, Elastic BeanStalk, SNS, SQS, Lambda etc.) 2015-2018
• Microsoft hosted, office-based tools 1990-2018
• Oracle VirtualBox - numerous Linux based VMs supporting mainly Oracle based POC technical stacks 2011-2018
• VM deployments automated with Ruby, Chef and Vagrant

Senior Cloud Solutions Architect & Oracle Architect / DBA

Confidential, Orlando, FL

Responsibilities:

• Performed AWS migrations during ports from on premise Oracle enterprise databases to AWS RDS/Aurora/PostgreSQL & Redshift. For small OLTP Oracle to AWS RDS migrations used SCT and DMS.
• A larger Oracle to Redshift migration used SCT and SCT extraction agents to S3 with S3 to Redshift copies.
• Extensive Redshift tuning of clusters / slice management, table sort key and distribution analysis and implementation.
• Used Redshift WLM to manage queue and execution queues. Provisioned dev, QA and production AWS & Redshift environments (authentication and authorization) including networking and security definitions by working with corporate networking and security teams.
• Executed technical project design, infrastructure design and provisioning, testing and implementation, including production rollout, change management (CAB & Service Management), documentation, and team communication / coordination.
• Created and completely automated Oracle 12c Data Guard Snapshot Standby databases Dev/QA/Prod.
• Project required skills with the following skills (but not limited to) Linux Administration (package installs, bash scripting…and more), VMWare, Oracle 12c/11g DB administration, installs, Data Guard, SQL etc. configuration and operations management.
• Also upgraded IAM/OID to 11g integrating with Microsoft AD Enterprise.
• Supported EBS 12.1.0.3 (patching, admin etc.) in a Linux RHEL / Oracle RAC environment and assisted with OEM 13c upgrade from 12c.

Senior Cloud Solutions Architect & Oracle DBA / Architect

Confidential, Savannah, GA

Responsibilities:

• Architected and implemented an on premise 20TB Oracle Data Warehouse to AWS Redshift migration.
• Designed and implemented large Oracle data extracts by using Oracle external tables to create a series of pipe “|” delimited flat files.
• Used an AWS Snowball appliance to transfer the approximately 25TB of flat files to AWS S3.
• Worked with Gulfstream networking and security teams to provision AWS dev, QA and production environments to meet corporate standards for user / data security, reliability and scalability.
• Used SCT (Schema Conversion Tool) to migrate DDL from on premise Oracle to AWS Redshift. Scripted S3 copies to Redshift database tables managed via Redshift WLM (both initial load and daily loads).
• Implemented daily loads from on premise to AWS using AWS Data Pipeline to S3 and built-in SNS / notification feature.
• Performed Redshift cluster / slice tuning, table sortkey and distkey definitions to enable performant & cost-effective dev, QA and production AWS Redshift life cycle cloud environments.
• Also provided production DBA service for Oracle on-premise and MySQL, PostgreSQL, DynamoDB in the AWS cloud in a large hybrid enterprise environment comprising 120 production instances and 2X that in development, QA, and other type instances.
• The on-premise Oracle Enterprise databases were a split between SAP based Oracle databases and non-SAP respectively using versions 12.1.0.2 and 11gR2 of Oracle’s Enterprise Database product.
• Performed database upgrades, PSU patching, license management, database cloning / duplication and Oracle Home cloning. Supported SAP stack patching and quarterly OS patching.
• Created and supported several RAC and many Active Data Guard instances, both JFS2 and ASM based, in AIX (870 IBM Frames) and Linux VMWare/Intel hosted environments, and Oracle Database Appliance environments, connected to stand alone JBOD, or EMC VPLEX / VMX & VNX storage tiers on premise.
• Used EMC Data Domain / DDBoost based storage appliances and strategies integrated with Oracle RMAN backups.
• Implemented and supported Data Guard instances, and Golden Gate replication. Performed WebLogic 11 & 12 provisioning and administration.
• Used Oracle Enterprise Manager 12.1.0.3 and later OEM 13c for corporate wide support, blackout window definition and alert distribution, corrective actions, and assisted with OEM 13c upgrade. Rotated to DBA-ON-CALL one out of every eight weeks providing 7x24 support. Provided regular weekend / night maintenance support for systems mentioned.
• Enabled and supported Transparent Data Encryption across several Oracle databases. Heavy Korn, Bash, and Python scripting during most support activities.
• Thoroughly documented processes and procedures and mentored less senior personnel. Presented to all corporate levels via the governance hierarchy, architectural and process documents using verbal, and written communication tools including.
• MS Office, MS Project, MS Visio, WebEx, Jabber & SameTime / Notes, Used Remedy/SRMS and later Service Now for Incident, Requests, Work Order and CRQ remediation.

Senior Oracle DBA / Architect

Confidential, Palm Beach, FL

Responsibilities:

• Oracle EBS R12.1 Application DBA, Oracle DBA, and Solaris Admin, supporting all activities related to the EBS R12 Application DBA role and lite Oracle CC&B support.
• My activities include support for Oracle production, test & development database environments, Solaris administration.
• EBS patching with adpatch, DB patching, cloning (Rapid Clone, RMAN cloning), refreshes, & user administration and all trouble shooting activities; OEM, performance tuning, and database backups via RMAN & TSM / TDP. Installed EBS R12.2 (Fusion/WebLogic stack) in a sandbox for user testing and assisted with configuration. Support DBA activities on the cities GIS / PostgreSQL / PostGIS databases (production, QA, Dev), Node.js / javascript.
• Supported the Confidential Palm Beach through an Oracle LMS audit, providing consulting and technical services to comply and minimize costs.

Senior Oracle DBA / Architect

Confidential - Tampa Florida

Responsibilities:

• Performed in a number of roles (mainly Oracle Development DBA) for the largest communication company in the US.
• Initially installed Linux & provisioned four RHEL 6.5 nodes to support the group’s development Oracle RAC DB environment that supported Confidential ’s proprietary AI network service system.
• Installed Oracle 11gR2 RAC 11.2.0.3. Installed and provision five RHEL 6.5 nodes to support the team’s application server tier.
• Worked with Developers tuning very high transaction rated DB related applications - extensive PL/SQL & SQL development and support. Instrumental part of the team that installed OBIEE on a couple of the app servers and provisioning the database to support OBIEE and a Fusion stack.
• Linux support included RPM, and security management, and kernel tuning to support the software stacks.
• Supported MySQL with installs and administration on RHEL platform for light weight databases.
• Worked in Confidential Standard Operating Environment (SOE) for development, offshore development, user acceptance, performance, and production (including DR). SOE platforms, which, up to production, were ESXI / VM / vSphere 5.5 based Linux environments.
• Production environment was hardware based.
• Provided provisioning support using VMWare data stores, and VMs with vSphere console. Primary resource in provisioning shared storage for Oracle RAC with vSphere 5.5.
• Performed and supported proprietary application maintenance, development and tuning with timely version rollouts / change management for mainly database related activities. This involved using a highly customized and integrated code management system / service request system, CVS / IPM based.
• Additionally, heavily utilized and administrated VNC, Putty suite, SQLDeveloper/Toad, Korn and Bash Shells, Oracle Enterprise Manager, Oracle RAC command line utilities (crsctl, srvctl, asmcmd), RMAN, and logical backup (exp/imp and expdp/impdp) to address the team’s and my activities.
• The main application that I supported was Confidential 's proprietary network surveillance application - which provides Confidential with the ability to monitor, identify events, alert & alarm, root cause analysis with correlation and generally help to resolve internal network, and topology problems.
• This application did not monitor Confidential 's Client devices - only Confidential owned resources. Rolled out (installed, configured, and administrated including WebLogic) OBIEE 11g, and APEX with the latest release to reporting and analytical requirements, provisioned OAM 11g with mod osso.
• Installed 12c RAC in SIT, built 5TB DB with RMAN (development environment); used transportable tablespaces TTS for some cloning operations & imports of production data; assisted Development team with application upgrade process (debugging and tuning PL/SQL packages) and testing / verification with 12c. Supported GoldenGate replication for uni-directional reporting instance.
• Many tasks required extensive Korn, Bash, and or Python scripting.