Business Intelligence Data Warehouse

MICHAEL FOSTER

****@*************.***

408-***-**** Cell

PROFESSIONAL SUMMARY

Dedicated and persistent, particularly in addressing client concerns, with the expertise to select and implement the most appropriate technology efficiently based on experience. Being a team player is important to me, always striving to open communication channels.

Fully engaged in building cloud and AI based solutions with a specialization in databases (AWS RDS, AWS Redshift, Snowflake, Oracle, PostgreSQL/Aurora/RDS), DW, Big Data/Data Lakes. I have spent the last seven years in AWS’ cloud focused on delivering scalable cloud-based solutions, which included OLTP with/ELT pipelines & providing pre-processed Data Lakes & Data Warehousing environments positioned for Data Analytics & ML.

Extensive experience with LLMs, prompt engineering, AI based stacks. Utilization of AI/ML to optimize solution development and implementations by doing pair and vibe based development using LLMs.

Current heavy, hands-on experience as DataOps Engineer / Developer, using JIRA, Agile, GitHub Terraform, a wide array of AWS services, enterprise quality database products, and development languages like Python & PL/SQL and many more. I have also functioned as an AWS Administrator/SysOps, DevOps Engineer, AWS Solutions Architect, Database & Linux Administrator, and Production & Development DBA.

This diverse and deep experience gives me the ability to work in many different capacities to accomplish goals. My guiding MO is “my knowledge is your knowledge” and as such I am adept at communicating technological concepts to many levels of audience both verbally and in the written form.

Embracing Continuous Integration & Continuous Delivery tools and concepts wherever possible for the last several years.

Intimately involved in developing and support of large-scale Big Data pipelines covering the entire process flow from provisioning and managing ingress mechanisms (using Python, Airflow, Kafka, S3, Glue, ECS/Docker, Athena), ingesting/ETL/ELT into DW, DW warehouse production support, and security and cost-effective archiving of multi-TB/day.

Thorough knowledge of security mechanisms (on premise and AWS cloud based) available at the networking, identity management, operating system, database (RBAC & DAC), and application levels, assure guarantee safekeeping of proprietary information, along with single sign-on applications / federated authentication & MFA.

More than twenty years of experience provisioning, installing, upgrading, patching, tuning, and production administration of various Oracle stacks – including EBS, Oracle Enterprise DB w/OEM, Oracle App Server supporting Oracle Forms/Reports and OBIEE also worked most of the Oracle stacks as a Developer.

Extensive practical day to day administrative and development experience with each of the following Operating Systems: UNIX dialects: AWS Amazon Linux, RedHat Linux, Ubuntu, Solaris, HPUX, AIX, and Windows Server, and VMS.

Many years of scaling, replication, HA, DR, RPO, RTO experience with Oracle Golden Gate, DR (Data Guard), HA (RAC), and AWS (such as AWS EC2, RDS & ELB / ALB, and various OSes, Docker, and others.

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. Last five years I have used the Agile methodology with integrated tool sets like JIRA and Github/Gitlab.

Several years hands on DevOps experience with AWS cloud creating applications using S3 (including life-cycle management/cost control), IAM, EC2, AWS RDS (many DB dialects), Spark, Presto, Redshift, Snowflake, CI/CD automation, ELB, Lambda, Terraform, Concourse, Flyway, CloudFormation, Auto Scaling, Direct Connect, Data Pipeline, Kinesis, AWS CLI, and Python scripting / application development.

Recent and considerable experience designing, developing, tuning, AWS RDS / Redshift, Snowflake & 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.

Extensive experience and command of documentation tools like – Confluence, Gliffy, Draw.IO, Readme Markdown, Visio, MS Project, Excel, Word, and PowerPoint.

Significant exposure to social media, Government, Web/E-Commerce, Big Pharma, Oil, Public Sector, Utility / Power, Inventory, Order Mgmt., MRP, Manufacturing Execution, Scientific, Engineering, Retail, Power, Support Systems, and financial industries.

Many years in the trenches architecting, and implementing infrastructure, including performing capacity planning (cloud and on-prem), and performance analysis for compute, SANs, Storage Appliances, and networking components to support large ERP based systems (both OLTP and DSS/Data Warehouses).

Formal academic training with the AWS ML stack, AWS Glue, AWS Sagemaker Data Wrangler, Sagemaker, PyTorch, TensorFlow and ML in general, strong enough math background to understand the many facets of ML – (up to Differential Equations). And heavy hands 6 years current experience with a large set of AWS services that could come into play in a ML pipeline.

Amazon AWS, Snowflake, Oracle and Linux Certifications and Others

Amazon AWS Database Specialty Certification (April 2023)

Snowflake SnowPro Core Certified (2022)

Apache Druid & Imply Certifications (Druid Basics and Druid Ingestion & Data Modeling) (2022)

Terraform Associate Certified (from Hashicorp) (2022)

Amazon AWS Big Data Specialty Certification (2018)

Amazon AWS Certified SysOps Administrator Associate (2018)

Amazon AWS Certified Solutions Architect Associate (2018)

Amazon AWS Certified Developer Associate (2018)

Oracle Certified Professional Database Administrator – OCP certified with ALL the following Oracle Enterprise Database versions: 12c, 11g, 10g, 9i, 8i, 8.0 and 7.3 (1998 through 2017) OCP certified on 7 versions

Oracle Certified Professional E-Business Suite R12 Applications Database Administrator (2017)

Oracle Certified PL/SQL Developer (2002)

Linux+ Certified System Administration (2006)

Skills and Tools Summary

AI Tool and Experience Summary

LLMs Open AI Suite, Anthropic (Claude), Cursor AI, Wispr Flow.

Operating Systems & Container Administration

AWS Linux, ECS, Docker, Docker-Compose, Kubernetes, VMWare vSphere, HP UX / AIX / Solaris /Oracle LINUX, LINUX (RedHat RHEL 2,3,4,5,6, CentOS, Amazon LINUX / Windows Server / Mac OS / VMS /, Oracle VM Server / Manager, Sun, HP, IBM, Compaq, Dell, EMC, Hitachi

SysAdmin, SysOps, DevOps in Cloud & Web Hosting Environments

Snowflake, Redshift, Amazon AWS Services: IAM, EC2, Route 53, S3, S3 Glacier, EBS, EFS, VPC, Security Groups, SNS, SQS, AWSCLI, RDS/MySQL, PostgreSQL, Athena, NoSQL/DynamoDB, Spectrum / Glue / Lake Formation, Matillion, AWS Lake Formation, AWS EMR Hadoop / Spark / Presto & Hive, CloudFormation, CloudWatch, ECS, EKS (Kubernetes/K8s), & Airflow.

OpenAI Prompt Engineering, Terraform, Concourse, Flyway, Ansible, GoDaddy, Word Press, MS Office 365, GCP / Google Cloud Platform, AWS / Amazon Web Services, OCI / Oracle Cloud Infrastructure (PaaS, IaaS, SaaS)

Applications Administration, Security, Scheduling, Monitoring, Alerting and Development

Administrating, Architecting, and Developing - AWS Services, Serverless, Micro-Services from console, AWS CLI & AWS API / SDK (Python, Java, Scala, PHP, Bash), AWS Secrets Manager, AWS Parameter Store, AWS KMS

Linux/crontab, Apache Airflow, AWS Batch, Kubernetes, DataDog, AWS CloudWatch, CloudTrail, & EventBridge

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

Server Administration, Big Data, Data Lake, Database Ingestion, Data Engineering Tools, +Application Server Administration and Development

Snowflake, AWS Redshift / S3 Spectrum, DynamoDB, node.js, AWS EMR / Hadoop / Spark / Scala / Hive, Kafka, Kinesis, Parquet / ORC, Alation, Dataiku, AWS Glue, ETL, MapReduce, Cloudera

RDS MySQL, MariaDB, Aurora, PostgreSQL, Oracle, SQL Server, MongoDB

Oracle Enterprise Database Server Versions 5,6,7,8,8i,9i, 10g, 11g R2, 12c, Oracle RAC 9i, 10g, 11g & 12c, 19c

Oracle Enterprise Manager (OEM), Grid, ASM, ADDM, AWR, ASH, Oracle Tuning Advisors, SQL Profile

Oracle Application Server, WebLogic

SQL Server, Oracle Developer, Oracle Designer, ERWin & /ERStudio, BI Publisher

APEX, Toad, SQL Developer, JSON, YAML, ORDS, SQL, PL/SQL, Oracle Forms, Oracle Reports, AIM, Pro*C / OCI, PHP, MyAdmin

Database Related Tuning

Snowflake (Search Optimization, Cluster Keys, Materialized Views), & Redshift (Cluster / Slice tuning with extensive sort key, and distribution key analysis) and SQL profiling for both products.

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,

Oracle & PostgreSQL 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, Methodologies

3rd Normal Form for OLTP, Star and Snowflake designs for Data Warehouse, Slowly Changing Dimensions(SCD), used ERWin, ER/Studio and Oracle Designer over the years for database modeling, perfectly adept at new design from scratch as well as shoe-horning in retrofits – with both OLTP and Warehouse designs.

Agile using Jira, and Github

Database Fault Tolerance and Backup Technologies

Snowflake Time Travel, RDS Aurora / Postgres PIT Restores

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

IDPA DDBoost / Data Domain / Avamar

BCV Splits, EMC Data Domain / DD Boost, TSM / TDB Tivoli Backup, Veritas NetBackup, Legato Backup, Transparent Data Encryption / TDE, Oracle Wallet / KeyStore, SSL / TLS, Multi-Factor Authentication

Web Design, Interface and Development

HTML, XHTML, XML, CSS, JavaScript, Node.js, Java, Scala, Python, jQuery, HTTP, HTTPS, React, WordPress, REST API Development with NodeJS, Express, VSCode

VM, Development Languages, Code Management & CI/CD ETL/ELT, Pipeline Tools & Scripting

GitLab, Gitlab Flow, GitHub, Terraform, Concourse, Flyway, VMWare, VirtualBox, Vagrant, Ruby, Ansible, Korn, Bash, Perl, Python, DOS, PL/SQL, SQL, SQLPlus. Java, JavaScript, Visual Basic, C, C++, Toad, SQLDeveloper, Putty, VNC, Python, Pro*C, DNS, AWS CloudFormation, Docker / Kubernetes, Pentaho, Matillion, DBT & Talend, PySpark/EMR.

Project Management, And Documentation Tools, ITIL Service Management / ITSM

MS Office - Word, Project, Excel, Visio, Outlook, PowerPoint, Service Now, Remedy, HP Service Manager/ Service Center, JIRA Software (Core) and JIRA Service Management / Confluence, MS Teams

PROFESSIONAL EXPERIENCE

Pyramid CI April 2024 to Current

AWS Senior Data Engineer @ Duke Energy Nuclear Division

2024-2025 Open AI / Anthropic Claud Sonet 3.7 – Utilizing LLMs for Prompt Engineering to substantially expedite Software Engineering activities across a broad range of services.

2024 Developed AWS based operational database solutions (AWS Redshift, Aurora RDS PostgreSQL) by porting on-prem legacy using an array of tools. Mostly CI/CD based automations including extensive experience with Terraform, Github, Concourse, & Flyway.

2024-2025 Developed AWS based Analytics tools and solutions based on a Hudi Data Lake and Redshift. Heavily utilizing Redshift Spectrum, Redshift PL/SQL, SQL, AWS Lambda / EventBridge, AWS Glue & Python.

Dreisbach Enterprises Part-Time Intermittent Sparse Work (2006 – 2024) Technical Lead, Linux Administrator and Oracle Administrator

2024 Developed cost effective failover capability into RHEL 8.9 and Oracle 19c on-prem Standard Edition – Oracle Data Guard like functionality without the Oracle Enterprise price tag. Rapid AI development primarily implemented with reliable bash scripts. Required extensive RHEL knowledge (rsync etc.), & Oracle RMAN / archivelog apply with active database recovery disconnect. Gained further experience large VMWare Clusters, and Pure drive arrays.

Providing Oracle Database and RHEL Linux System Administration services, including installs, upgrades, tuning, RMAN backups, recovery in a VMWare, & Dell / EMC environment.

2018 – moved RMAN backups to Dell/EMC IDPA / DP4400 and DDBoost. 2021 implemented Avamar file system backups, performed DR testing.

Early on analyzed Client’s hardware needs and supplied / procured and setup (either myself and or coordinated) all Dell Server hardware (servers and disk arrays). This has swelled to about 6 Dell PowerEdge Servers and 2 drive arrays over the years) to support the Clients growing business and IT demands. More specifically, I have ported and upgraded Oracle and Redhat Linux to a new Dell 2950 production server used to run the company’s main application (a shipping & warehouse management database and application server).

Upgraded from Oracle 8i to 10g R2 RAC (standard edition) and upgraded Redhat Linux 2.1 AS to Redhat Linux 4.3 AS and setup RMAN database backups.

2014 & 2016 – Implemented and supported Oracle Data Guard for DR and some reporting using Oracle 11gR2 standby snapshots. Upgraded RHEL to 6.6 and then to 6.8. Installed and administrated MySQL databases for small proprietary DBs on RHEL 6.6.

Tuned Oracle and application processes, including but not limited to the SGA/buffer cache, shared pool, log buffers, and redo-logs to fit the Client’s load, SQL Profiling etc. Developed technical documentation for all the existing systems. Upgraded Client’s Oracle DBMS from 10gR2 to 11gR2 and later from 11gR2 to 12gR2,

Mphasis May 2023 to March 2024

AWS Solution Architect & Lead Technical Developer @Cigna / Evernorth Accoutable Care

Projects goal: Improve the quality, efficiency, and cost of healthcare to millions of people in the US.

Technical Lead / Architect on the Evernorth Accountable Care account, supporting the development of a completely new ENAC system to improve managed care.

Worked on all database phases of development and DBA work with on-prem and AWS based services utilizing PostgreSQL, SQL, PL/PGSQL, Python, AWS S3, Cloudwatch, EventBridge, Lambda, AWS Steps, Github, Confluence, Qlik Replication & Gitbash.

Lead Sub-System Team on the database side from inception through sandbox, dev, sys/QA, to prod deliverables (PROD releases staged from Oct 2023 to March 2024). Including relational logical design and physical implementation, developed programming logic in PL/PGSQL in sophisticated, claim cost calculation sub-system, workflow and case management sub-systems. All OLTP based systems. I was instrumental in designing and implementing their in-house solutions for most of this, including cost calculations, payments, workflow, and case / exception management.

All work scoped and tracked using Agile methodology with Jira, Github, Liquibase (for DB change management, and pipeline deployment) and other related tools. Extensive PostgreSQL experience with JSON, and inter-database communication via Qlik replication and or moving JSON between DBs.

Capital Group Sept. 2022 – March 2023

Senior Cloud Data Engineer

Worked in the Common Data Platform (CDP) group engineering & developing cloud-based ingestion platforms.

Part of a small team that Developed and standardized for reuse about 50 different ingestions (or more, 8 or 10 completed by me) that supported down-stream consumers.

The stack we used day to day was mostly AWS based and included AWS Aurora RDS / PostgreSQL for OLTP, and Snowflake for warehousing using Python, MWAA / Airflow, Lambda, SNS, S3, Glue, Terraform, Github, Docker, JIRA, Confluence and DBT.

My role varied day to day from Developer / DBA / DevOPS / Solutions Architect.

Gained further extensive experience with AWS, AWS RDS, PostgreSQL, advanced SQL, DBT including Jinja2 Macros, Airflow, Lambda, Python, and AWS Glue, Athena and PostgreSQL remote views using Foreign Data Wrappers (sharing data in real-time between databases and clusters).

Standardized data lake, ingestion, and database nomenclature to be consistent across the landscape.

Dockerized our local DBT environment for easy creation and standardization of development environments across the Team.

Designed, socialized, and implemented consistent RBAC role based “least privilege”, supporting multiple applications and databases.

Charter Communications

Senior Cloud Solution Architect March 2022 to July 2022

Support and development using Apache Druid / Imply dialect (an open source, real time, time based, data warehousing product), extensive experience with built-in Druid’s Kinesis and Kafka integration and an array of nodeJS applications dockerized and orchestrated with AWS ECS.

Druid executes most queries against terabyte ranges of data in the sub-second timeframe.

Performed Druid data source development and used ancillary AWS services for development and support (AWS S3, EC2, ECS, ASG, Event Bridge, Lambda), gaining extensive experience with DataDog, and Gremlin for monitoring and attack simulation.

Enhanced applications that front-ended Druid using in NodeJS/Express with RESTful. Extensive work with NodeJS/Express/JavaScript in the AWS cloud.

Extensive use of Mac OS / MacBook Pro Client, and VSCode and many helpful VSCode plug-ins and Gitlab, and Gitlab Flow for SCM, & CI/CD in concert with Terraform for build and deploy.

The environment supports ingestion of petabytes of data with billions of upstream events inbound to Druid via Kafka, in very short units of time.

Pfizer & Quest Diagnostics (Via Tata Consultancy Services –TCS) July 2018 – March 2022

Senior Systems Engineer/Cloud Solution Architect

Supporting Quest Diagnostics for TCS – Feb 2022 – March 2022

Performing data warehousing development and DBA activities using Snowflake and Matillion (ETL), Snowpipe, with GitLab Flow CI/CD.

Working in the Life Sciences division of Pfizer for TCS – July 2018 thru Feb 2022

Nov 2021 to Jan 2022 - Transferred within Pfizer to Cloud Operations group on the high visibility ModFac project in the TCS Hyper-Care group. Project involved migration of about 2700 on-premise servers to AWS within a very aggressive timeline (3-4 months) – lift and shift to EC2. My primary responsibility is development of automation to minimize time and effort required for pre and post server migration tasks & reducing time/effort and allow scaling to multiple 100s of servers migrated per week. Automating all aspects of pre and post migration support using SQL (query CMDB/Oracle DW), Python/AWS Boto3 to query AWS, & Ansible, Bash and PowerShell with other mostly command line versions of stack tooling to script / automate.

September 2018 through Oct 2021, providing database, application, and infrastructure development support in the AWS cloud and on premise, mainly in the AWS Big Data and Data Warehousing space (Redshift & Snowflake).

Built an array of applications & workflow processes to support TCS / Pfizer Data Warehousing:

Automated Provisioning of End Users with the correct permissions and notification of provisioning (Python, AWS Boto3, Selenium API)

Designed and implemented self-operating Workload Management and Cluster Performance Monitoring, Automated Corrective Actions and Alerting (with extended usage history), (Python, AWS Boto3, Redshift Views, EC2, SNS)

Implemented simple and cost-effective rollout of a Responsive Data Archival and Restoration Solution to Manage & Minimize Archived Data Cost (Python, Open-Source API, S3 Life Cycling & Event Notifications)

On-Boarding New Data Sets & Vendors (Workflow Process Development, & Mentoring)

Constantly Improving Cost Benefit - By Implementing New Approaches, Node Types, Resizing, and Feature Rollout

Played significant role (Primary Snowflake DBA/Architect for RWD) in multiple migrations to Snowflake and day to day Snowflake administration and pipeline development,

In the Data Warehouse vertical line of business (LOB), I supported several 100+TB Snowflake and Redshift clusters, of various sizes up to 40xDC2.8xlarge and later RA3.16xlarge clusters Redshift, in production and non-prod environments, to provide easily accessible, scalable, and secure results.

In the OLTP vertical LOB I was involved in porting mainly Oracle on-prem to EC2 (Oracle, or Postgres) Amazon Linux and migrating some Oracle to RDS (Postgres, and Oracle) depending on what the Application team chose as their target environment.

Was a primary contributor in the development and the support of large-scale Big Data pipelines into cloud-based Data Warehouses (Redshift and Snowflake) covering the entire process flow from provisioning ingress mechanisms (S3 etc.), ingesting/ETL/ELT into DW, AWS Lake Formation, DW warehouse production support, and security and cost-effective archiving multi-TB/day for the Read World Evidence domain.

Developed EMR based process that pre-processed and created new aggregated datasets, for some of Pfizer’s RWD data using Python, PySpark, EMRFS & S3DistCp.

Nov 2020 - We/I migrated from a 36xdc2.8xlarge AWS Redshift cluster to 10xRA3.16xlarge Redshift cluster now in production, saving the Client over $250k in annual license fees, with near equivalent performance increase storage scalability. Involved in rigorous benchmarking prior to migration to contrast and compare Redshift RA3 to Snowflake on a large 100TB+ active data warehouse. Although Snowflake tried to be competitive, in the end Redshift’s more mature product allowed much easier cost controls, and a significant advantage in compute resources per dollar. Lower demand, less active data warehouses would have been more favorable to Snowflake.

Developed an array of Python (using, selenium API for automation, boto3, and PySpark for statistical analysis), based programs, automation for provisioning, and governance tools to make the overall administration process more efficient, faster, less error prone and less tedious.

Substantial Snowflake and Redshift workload management and alerting experience enhanced both Snowflake’s and Redshift’s (WLM & QM Rules) built-in workload management capabilities substantially.

Considerable experience cloning, restoring, resizing, changing node types using both AWS CLI and AWS RDS & Redshift console, and using RDS, Snowflake Time Travel / Zero-Copy Clones etc.

Designed, and developed, automated ticketing process and account provisioning using Python & Selenium API for provisioning new, existing user accounts and privileges, streamlined the process by 80%. Used both Micro Focus Service Manager and JIRA for incident, request catalog, change requests, and CMDB/CI (ITSM functions). 2021 rewrote automation in Java / Selenium API for HP SC upgrade to Micro Focus Service Manager (ITIL request catalog tickets).

Responsible for S3 allocations/provisioning, IAM account provisioning, and partner sharing. Heavy exposure to policies, roles, encryption etc. at all AWS levels. Assisted, documented processes, and mentored people with access challenges (AWS CLI, S3 Browser, SQLWorkBench, Pg/SQL, Python/Boto3/psycopg2 and others).

Implemented Redshift Spectrum external tables together with AWS Glue to archive data out of Redshift to S3 – allowing limited accessibility after archive.

Delivered written and verbal analysis of many of the many projects & tasks I was involved with – Conducted Monthly Readout via Webex and provided substantive written results and statuses.

Created extensive shared library of “how to” documents and on demand SQL scripts for a large # of administrative tasks.

2021 Designed and implemented a solution to control S3 archive costs via S3 Life Cycles, Glacier and restore script templates for data archives in S3 that was often restored from S3 Glacier to the target database environment – saving the Client big money / $$$ per year over standard S3 storage class.

HD SUPPLY, FL August 2017 – November 2017

Senior Systems Engineer/ Cloud Solutions Architect & Oracle Architect

Performed AWS migrations during ports from on premise Oracle enterprise databases to AWS RDS/Aurora/PostgreSQL & Redshift. Setup and productionized Hadoop/HDFS Spark jobs for data wrangling and DW feeds. For small OLTP Oracle to AWS RDS application migrations used AWS SCT and AWS 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. Extensive use of Python and Bash for scripting.

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.

Used Service Now for ITSM functions (RFC, Request Catalog servicing, Incidents, CMDB etc.).

GULF STREAM Aerospace, Savannah, GA Nov 2015 – April 2017

Oracle Systems Engineer/Cloud Solutions Architect

Provided production DBA services for large very active on-premise Oracle Enterprise databases, split between SAP based Oracle databases and non-SAP respectively using versions 12.1.0.2 and 11gR2 of Oracle’s Enterprise Database product. Also provided SQL Server support during on-call rotation.

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 (OEM) 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.

City of West Palm Beach, FL Feb 2015 – Sept 2015

Senior Oracle Systems Engineer/ Architect

Oracle EBS R12.1 Application/Systems Engineer and Solaris Admin, supporting all activities related to the EBS R12 Application Engineer 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 city of West Palm Beach through an Oracle LMS audit, providing consulting and technical services to comply and minimize costs.

VERIZON COMMUNICATIONS, FL Jan 2014 – Dec 2014

Senior Oracle Systems Engineer/Architect - Verizon Communications – Tampa Florida – Jan 2014 to Dec 2014

Performed in a number of roles 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 Verizon’s proprietary AI network service system.

Installed Oracle 11gR2 RAC 11.2.0.3. Installed and provisioned 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, security management, and kernel tuning to support the software stacks. Assisted with data warehousing, and DW pipeline design and development. Relied on Pentaho for ingestion pipeline development and ER Studio for visual star/snowflake schema design.

Installed 12c RAC in SIT, built 5TB DB with RMAN (development environment); used transportable tablespaces TTS for some cloning operations &

Contact this candidate