Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Richmond Opare

Belmont,NC

Summary

Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives.

Professional with strong background in managing and optimizing database systems. Proven track record in data security, performance tuning, and disaster recovery. Collaborative team player focused on achieving results and adapting to changing needs. Skilled in SQL, database design, and automation, with reliable and flexible approach to challenges.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Lead Cloud Database Administrator

Prudential Financial
07.2019 - Current
  • Using SSL with PostgreSQL DB Instance
  • Importing data into Amazon RDS PostgreSQL
  • Setting up read only Read Replicas (master/standby) in and across AWS Regions
  • Understanding and Setting up parameter groups and features
  • Monitoring the activity and performance of an AWS RDS DB instance with cloud watch.
  • Backing up and restoring DB instances from on premises DB to AWS
  • Managing upgrades of the PostgreSQL database version from 9.5,10 to 11.
  • Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques.
  • Expert level of PostgreSQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.
  • Experience with PostgreSQL Monitoring tools
  • Coordinated with technical teams for installation and testing of upgrades and patches.
  • Assisted in implementation and maintenance of security and data encryption technologies.
  • Maintained detailed technical documentation of database architecture and modeling as per business requirements.
  • Collaborate to develop conceptual and detailed development plans, and work with internal and external resources to drive the plans to completion
  • Provide advice and counsel to the developers regarding the most complex aspects of database methodologies
  • Provide analysis, design, and peer-reviews for new work and legacy overhauls
  • Assist with regular network security and penetration tests
  • Manage performance of MySQL deployments and optimize SQL queries
  • Manage MySQL database and Manage migrations and upgrades.
  • Provide technical support for database technologies to various development teams.
  • MySQL Enterprise Auditing for security purposes.
  • Refresh Dev/Test environment with Production data
  • Facilitated knowledge sharing, conducting training sessions for junior DBAs and developers on best practices.
  • Optimized database operational efficiency by implementing automated backup and recovery procedures.
  • Streamlined database deployments, automating processes to accelerate development cycles and reduce errors.
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
  • Developed scripts and processes for data integration and maintenance.
  • Ensured high availability and disaster recovery capabilities, establishing and testing robust backup and failover strategies.
  • Streamlined data retrieval and processing, designing and optimizing complex SQL queries for business intelligence.
  • Facilitated seamless migrations and upgrades, meticulously planning and executing database changes with minimal impact on users.
  • Advanced database security posture, leading successful initiative to encrypt sensitive data at rest and in transit.
  • Reduced operational costs by identifying and decommissioning underutilized database resources.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.

Open Source DBA

HORIZON BLUE CROSS BLUE SHIELD OF NJ
10.2018 - 06.2019
  • Setting up Amazon RDS PostgreSQL and creating instances.
  • Understanding of instance classes, storage types, and Provisioned IOPS in Amazon RDS.
  • Setting up high availability and failover support for AWS RDS PostgreSQL
  • Understanding of RDS within a VPC.
  • Working knowledge of AWS security groups
  • Managing PostgresSQL Database Access / Roles
  • Using SSL with PostgreSQL DB Instance
  • Importing data into Amazon RDS PostgreSQL
  • Setting up read only Read Replicas (master/standby) in and across AWS Regions
  • Understanding and Setting up parameter groups and features
  • Monitoring the activity and performance of an AWS RDS DB instance with cloud watch.
  • Backing up and restoring DB instances from on premises DB to AWS
  • Managing upgrades of the PostgreSQL database version from 9.1 to 11.
  • Understanding the best practices for PostgreSQL DB instances
  • Configure and monitor numerous MongoDB instances and replica sets
  • Automate routine tasks with your own scripts and open-source tools
  • Solve production problems and participate in a 24x7 on-call rotation
  • Improve database backups and test recoverability regularly
  • Study the database needs of our applications and optimize them using Mongo DB
  • Maintain database performance and capacity planning
  • Write documentation and collaborate with technical peers online
  • Performance tuning for high throughput.
  • Architecting high availability servers.
  • Optimized database performance by monitoring health and implementing tuning recommendations.
  • Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
  • Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.

Senior Database Administrator (MySQL)

ALC
05.2017 - 10.2018
  • Deploy and maintain complex MySQL environments such as, Multisource replication, Master-slave and GIT Replication.
  • Ensure uptime through precise monitoring implementations, good change management and incorporation of best practices.
  • Develop automation tools surrounding monitoring, performance and capacity planning. Responded to database problems and issues relating to applications and systems.
  • Maintained system documentation relating to application architecture, assembling and technical platforms.
  • Participated in learning of interfaces with systems for resolution of application problems.
  • Suggested improvement processes for increasing efficiency of applications and current processes.
  • Assisted in testing, upgrading and development of new and current database servers.
  • Coordinated with external vendors for tracking of routine incidents and operational problems.
  • Developed new architecture components in collaboration with storage administrative teams.
  • Provided technical assistance on installation and maintenance of database software components and related upgrades.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
  • Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
  • Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
  • Worked with the engineering team to implement new design systems of databases used by the company.
  • Effectively configured MySQL Replication as part of HA solution.
  • Designed databases for referential integrity and involved in logical design plan.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
  • Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
  • Proficiency in Unix/Linux shell commands.

Open Source DBA

UNITED HEALTH GROUP (OPTUM/OFE)
10.2017 - 09.2018
  • Tuned Various MySQL option file parameters like Innodb buffer pool log buffer to enhance performance.
  • MySQL Enterprise Auditing for security purposes.
  • Refresh Dev/Test environment with Production data.
  • Configure MySQL replication for High Availability
  • MySQL Enterprise Monitor (MEM 2.1 -3.0) and add database for monitoring.
  • Shell Scripting to check error log
  • Benchmarking, profiling queries to see where the time being spent.
  • CPU, I/O and MEMORY test suing SYSBENCH to compare database performance on different boxes.
  • Configure Galera Cluster (Active – Active multi master) MySQL replication
  • Convert /Move InnoDB type tables from shared tablespace to file per table to achieve max performance.
  • Experience with EC2 /RDS Database instances on Amazon Web Services
  • Installed / Configured S3 bucket to directly write backups to s3 bucket on AWS.
  • MyQL tools like MySQL Workbench,TOAD, for MySQL, MySQL migration toolkit, SQLyog and Monyog.
  • Provided technical Support to around 140 instances of MySQL 5.0, 5.1, 5.4 and 5.5 running on 50 Production/QA/Dev Linux servers with Centos 4.x and 5.x and around 10TB of data on direct Storage. Some tables with more than 500 million rows. This includes master-master and master-slave configurations, as well as, testing MySQL Cluster.
  • Performed DB profiling and optimization; analyzed and proposed schema changes to PostgreSQL databases as needed.
  • Proactively monitored activity, utilization, exceptions and database health; deployed appropriate improvements; automated repetitive tasks.
  • Configure and monitor mongo DB clusters in Dev, Ga and Production
  • In multiple environments and participate in a 24x7 on-call rotation
  • Improve database backups and test recoverability regularly
  • Study the database needs of our applications and optimize our capabilities
  • Participate in schema design and query tuning for applications
  • Maintain database performance and capacity planning
  • Write documentation and collaborate with technical peers online

MySQL & PostgreSQL DBA

Real Page Inc. Texas
11.2015 - 08.2017
  • Supported dozens of MySQL databases running on all versions 9.0- 9.4, 9.5 5.1, 5.5, 5.6.5.7 on a 24x7 basis.
  • Administration, installation/configuration, development, version upgrades, data migration, backup and recovery, replication, disaster recovery, performance monitoring & tuning, index optimization, shell scripts, database development, writing stored procedures & triggers.
  • Performed a variety of PostgreSQL& MySQL tasks related to problem resolution and monitoring, administration, availability, performance and security.
  • Configured MySQL multi-source replication to back up multiple servers to one single server to merge table shards and consolidate data.
  • Provided technical Support to around 140 instances of MySQL 5.0, 5.1, 5.4 and 5.5 running on 50 Production/QA/Dev Linux servers with Centos 4.x and 5.x and around 10TB of data on direct Storage. Some tables with more than 500 million rows. This includes master-master and master-slave configurations, as well as, testing MySQL Cluster.
  • Performed DB profiling and optimization; analyzed and proposed schema changes to PostgreSQL databases as needed.
  • Proactively monitored activity, utilization, exceptions and database health; deployed appropriate improvements; automated repetitive tasks.

System MySQL DBA (SDBA)

AT&T Research Lab
01.2014 - 10.2015
  • Installed, upgraded, optimized, troubleshot, performed root cause analysis on, and maintained MySQL servers versions from between 5.0 to 5.6, distributions from Red Hat, CentOS, and Ubuntu MySQL releases, Percona Server with XtraDB.
  • Setup, troubleshot, and fixed backups and restore data using tools such as Mydumper, Myloader, Mysql enterprise backup, and PerconaXtrabackup.
  • Implementation of MySQL stored procedures, triggers, and views.
  • Provided technical Support to around 120 instances of MySQL 5.0, 5.1, 5.4 and 5.5 running on 50 Production/QA/Dev Linux servers with Centos 4.x and 5.x and around 10 TB of data on direct Storage. Some tables with more than 500 million rows. This included master-master and master-slave configurations, as well as, testing MySQL Cluster and the administration of the PCI database environment using PCI General appliance.
  • MySQL tuning/optimization for InnoDB, MyISAM.
  • Participated in oncall rotation answering pages for trouble issues.
  • Performed with data migrations on MySQL RDBMS.
  • Used MySQL Enterprise backup and recovery tools including 3rd party backup solutions.
  • General Linux system administration tasks included configuration, troubleshooting of services such as Apache, Postfix.

PostgreSQL & MySQL DBA

Goldman Sachs & Co
09.2009 - 11.2013
  • Provided administrative database security by protecting the database and creating and managing users.
  • Provided system management role by troubleshooting, reviewing and monitoring database performance.
  • Performed general DBA duties (install software, create databases, table spaces, add redo log files, manage storage, and performance tuning).
  • Performed daily database backup of development and test environments; use production data to refresh development and test schemas for testing.
  • Managed MySQL on Windows, Linux & UNIX.
  • Implemented and maintained database security with roles and system privileges.
  • MySQL tuning/optimization for InnoDB, MyISAM.
  • Familiarity with approaches to database backup, recovery, PITR, and Disaster Recovery in general.
  • Experience building and configuring Streaming Replication, replication-slot, and cascading replication on PostgreSQL releases 9.4 and 9.5.
  • Performed a variety of PostgreSQL & MySQL tasks related to problem resolution and monitoring, administration, availability, performance and security.
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.

Education

Bachelor of Science - Accounting, Computer Science

New Jersey City University
Jersey City, NJ
12.2012

MBA - Management Information Systems

St. Peters University
Jersey City, NJ
05.2015

Skills

  • Open Source & Cloud DBA with over 10 years of high-level experience with MYSQL, PostgreSQL, AWS and working knowledge of MongoDB database administration
  • POSTGRESQL TOOLS: NAVICAT, PGADMIN, PGCLUU, POSTGRESQL MAESTRO, PEM (POSTGRES ENTERPRISE MANAGER), NAGIOS, ZABBIX, COMMAND-LINE-BACKUP-TOOLS SUCH AS PG_DUMP, PG_DUMPALL, PG_BASEBACKUP AND BART (Backup and Recovery Tools)
  • MYSQL TOOLS: MYSQL ENTERPRISE MONITOR (MEM), NAGIOS, ZABBIX, COMMAND-LINE-TOOLS SUCH AS (MYSQLADMIN) MYSQL DUMP, MYSQL ENTERPRISE BACKUP, PERCONAXTRA BACKUP, CLUSTER CONTROL, Patroni, Barman
  • MONGODB TOOLS: MongoDB Compass,Mongo Robo, Mongodump, mongorestore, Mongoimport, Mongoexport
  • O/S PLATFORM: WINDOWS VISTA, XP, 2000, 98, 95, SQL
  • PLUS ORACLE LINUX/UNIX (REDHAT/UBANTU) AND SAN
  • Code debugging
  • SQL proficiency
  • Cloud database services
  • Agile methodology
  • Python
  • Writing queries
  • Scripting for automation
  • Ansible automation
  • Cloud automation
  • Cloud Watch
  • Enhanced Monitoring
  • DMS

Certification

  • Oracle 11G Oracle Certified Associate (OCA)
  • MySQL 5.6 Oracle Certified Professional (OCP)
  • M102: MongoDB for DBAs (MongoDB University)
  • AWS Certified Developer Associate
  • AWS Certified Solutions Architect Professional

Timeline

Lead Cloud Database Administrator

Prudential Financial
07.2019 - Current

Open Source DBA

HORIZON BLUE CROSS BLUE SHIELD OF NJ
10.2018 - 06.2019

Open Source DBA

UNITED HEALTH GROUP (OPTUM/OFE)
10.2017 - 09.2018

Senior Database Administrator (MySQL)

ALC
05.2017 - 10.2018

MySQL & PostgreSQL DBA

Real Page Inc. Texas
11.2015 - 08.2017

System MySQL DBA (SDBA)

AT&T Research Lab
01.2014 - 10.2015

PostgreSQL & MySQL DBA

Goldman Sachs & Co
09.2009 - 11.2013

Bachelor of Science - Accounting, Computer Science

New Jersey City University

MBA - Management Information Systems

St. Peters University

Similar Profiles

CREATE PROFILE
Richmond Opare