Robert Dodoo

ad3adh@r.postjobfree.com 470-***-****

Strategic Multi-cloud Solution Architect driving innovation through the design and deployment of high-performance on-prem and multi-cloud infrastructure (AWS, OCI, and GCP). Adept at translating complex technical challenges into tangible business outcomes.

Relevant Technical Skills Database (OCI/GCP) Skills

VPC, RDS,ECS, EC2, CloudEndure, Lambda

CloudWatch, CloudFront, CloudTrail, CloudFormation

SQS, SNS,SES,S3,SnowMobile,EBS,EFx

DynamoDB, ElasticSearch, Networking, Backups

AWS Code Pipeline, Code Build, Code Deploy

Route53,S3,Python,Elastic Cache, Bitbucket

Data Security, Backup & Recovery

Standby/Failover Administration

Database Administration - Oracle 19c

Performance Tuning & Capacity Monitoring

Oracle RAC & ASM Administration/Installation

Oracle Patching and Upgrades

Oracle OEM provisioning and agent deployment

OCI Autonomous Database Administration

GCP Mysql Monitoring and Administration

Professional Experience

Manhattan Associates - Cloud Services

January 2021 - Present

Solution Architect AWS (Data)

Led teams to architect, design, develop, and implement Cloud solutions (Amazon Web Services and OCI) encompassing multiple specializations, platforms, and technologies.

Deployed the AWS Cloud Intelligence dashboards to provide Executives, directors, and other individuals within the CFO’s line with great insight into our AWS environments, allowing them to better understand and control the costs of delivering our services.

Created custom IAM policies, roles, and user management for delegated users within AWS-specified regions

Created AMIs for mission-critical production servers for backup.

Application and data migration from OCI to AWS cloud - AWS MAP

Proactively monitored resources and applications using AWS CloudWatch including creating alarms to monitor metrics for service lie EBS,EC2, ELB, RD, S3

Provisioned cloud networking architectures in a DEV/QA/PROD environment, utilizing Virtual Networks, VPN, Express Route/Direct Connect, Network Security Groups, and Load Balancers.

Ensure the project team proactively identifies and troubleshoots critical issues, maintains and prioritizes project issue lists, suggests solutions, and escalates when appropriate.

Exercise discretion to determine optimal and efficient designs for multiple areas of the software system.

Managed large and complex databases or clusters of databases in OCI and AWS Cloud Environments

Coordinate development of optimal database solutions to complex problems with cross-functional (DEV/QA) teams.

Manage planning and documentation of database server designs and DB management best practices to ensure system scalability, security, performance, and availability.

Identify critical business, technical, and/or operational issues and drive issues to closure.

Develop internal guidelines and create/implement best practices to ensure projects are on schedule and within budget.

Oversee the facilitation of technology and skills knowledge transfer and the relationships with database software vendors regarding issues and the implementation of solutions.

PNC Digital Transformation and Optimization - Remote 2018 – 2021

Database Engineer

Led a team of network, storage, and systems admins in collaboration with Oracle support to rehost enterprise fraud repository databases from on prem into Oracle 18c autonomous and semi-autonomous databases to with near-zero downtime.

Architected BBVA fraud data integration with PNC enterprise fraud repository, deployed AWS VPC’s, subnets (private and public) configured Network access control lists, security groups, and provisioned Oracle databases on multiple EC2 instances

Migrated multiple on-prem BBVA databases (sql server, oracle, mysql) from into EC2 instances with Oracle engines using native tools as well as SCT and DMT resulting in significant cost savings

Encrypted database volumes to improve security.

Provisioned High Availability of these databases by deploying replica EC2 in different AZ’s.

The Standard Retirement Services - Pittsburgh, PA

Oracle Database Administrator 2007-2009

Supervised the Installation and Configuration of Oracle 10g software on LINUX

Created databases and developed procedures to migrate and refresh databases between the development and production environments

Worked with application developers and users as a first line to solve problems and provide solutions to programming questions and offer possible solutions and consulting services

Performed various DBA Maintenance task using SQLPLUS such as rebuilding indexes, validating constraints, reorganizing tables

Performed backups on a regular basis for safekeeping and recovery purposes using Oracle Backup utilities including, the Import and Export utilities and the recovery manager (RMAN)

Created Users, assigned Privileges and Roles using SQLPLUS and SQL developer

Apply Oracle Critical Patch Update (CPU) patches on our databases every quarter

Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4 – 11.1.0.6

Education

Clarion University, Clarion, Pennsylvania

B.S., Management Information Systems

Advanced Proficiencies and Platforms:

Win, Linux Red Hat, Oracle Linux

Tools

OEM,SQL Developer, Oracle Toad, SAS SQLPLUS, AWS Cloud Watch, Performance Insights, MySQL Work bench

Contact this candidate