Robert Dodoo
*******@*****.*** 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