Uploaded File
add photo
IHEANYI
iheanyicc@gmail.com
240-898-7759
Orlando, FL 32801
MariaDB DBA/ Cloud Engineer
8 years experience W2
0
Recommendations
Average rating
48
Profile views
Summary

I have 8 years total experience with Database Administrator which includes 3 years on cloud engineering/ administration experience, working on AWS cloud infrastructure databases with the ability to manage and maintain highly available databases ensuring their security. Comfortable leveraging DevOps configuration management, CI/CD and other DevOps tools. Creative, multi-tasker, and team-oriented professional with strong interpersonal and documentation skills.

Experience
MariaDB DBA/ Cloud Engineer
Information Technology
Mar 2019 - present
  • Provisioning and configuring new RDS instance of MariaDB, MySQL and DynamoDB using Terraform from latest environment to production.
  • Upgrading RDS instance with Terraform.
  • Performing database code vulnerability scan with Visual Code Grepper.
  • Testing and detecting malicious update SQLs that are passed in the database.
  • Maintain the integrity of database Identify and Access Management.
  • Working with the database engineering team to examine, validate and set up proper parameter groups for databases.
  • Database User maintenance from creating user, granting, access, revoking user and deleting.
  • Designed and implemented Unified CloudWatch agent monitoring screen.
  • Designed and implement DMS service monitoring alerts.
  • Troubleshooting instances when there are connection issues.
  • Auditing RDS instances using CloudWatch and CloudTrail.
  • Test, monitor and deploy newly provisioned MariaDB databases to meet the scalability and performance requirements of application team before handing it over to the application team
  • Testing and automation of MONyog monitoring tool to reroute all deadlocks to the proper application team.
  • Working with developers and application to ensure their change deployment is successful
  • Granting Elevated access to functional user and accounts.
  • Encrypting instance both in transit and at rest.
  • Troubleshoot slow databases and recommending capacity management solutions.
  • Setting up live replication from Oracle to MariaDB using AWS Database migration service.
  • Migrating data from one environment to another and on prem to the cloud.
  • Experience working with Lambda function and API
  • Assists with incident response and troubleshooting both in P1 and P2 calls during an outage
  • Experience decommissioning and retiring databases in AWS
  • Experience conducting a root cause analysis (RCA) in production environments.
  • Experience evaluating and resolving Production incidents in AWS cloud environments and its application.
  • Create and document any newly developed routine solution and publish it as MOP for approval by management.
  • Experience using cloud watch to build an effective monitoring dash board.
  • Experience providing support for application deployment with the rollback plan.
  • Documenting all technical processes and changes that were newly implemented
  • Removing and adding global secondary indexes and secondary indexes for better query operations.
  • Troubleshooting MariaDB instances, identifying deadlocks, slow queries, long queries and working with application team to optimize those queries.
  • Experience in working with AWS resources like IAM, EC2, EBS, S3, ELB, VPC, ECS, Lambda, Route53, Auto Scaling, Cloud Watch, Cloud Trail, SQS etc.
  • Patching ECS clusters to update new AMI and close down any vulnerabilities.
  • Configuring the Continuous integration and Deployment (CI/CD) of the code on to AWS cloud
AWS AWS EC2 AWS S3 Cloudwatch Continuous Integration Data Replication DBA Elastic Load Balancer MySQL Oracle Database Maintenance MariaDB MS Visio
Remove Skill
MySQL/ Cloud Database Administrator
Information Technology
Aug 2018 - Mar 2019
F.L. MySQL/ Cloud Database Administrator
  • Created, configured, upgraded, and maintained Amazon Aurora databases on AWS environment.
  • Launched and Setup Aurora with read replicas for scalability.
  • Setup Aurora cross regional read replica for disaster recovery.
  • Upgraded Aurora cluster and enabled parameter groups for updates.
  • Managed and monitored Amazon Redshift cluster of data warehouse.
  • Installed and configured MySQL Percona servers on EC2 instances and performed periodic database software upgrades and patches.
  • Suggested tools and processes for identification and management of database infrastructure components.
  • Performed backup and recovery of production databases using Mydumper/ Myloader.
  • Performed database operations such as security standards, backup and recovery, data migration etc.
  • Proposed and implemented database and/or SQL performance tuning, planning, configuration, scaling, and capacity management.
  • Implemented disaster recovery and contingency plans related to their area of the infrastructure availability zone.
  • Reviewed capacity, usage, and performance of assigned technologies for core system based on business metrics.
  • Understands performance thresholds and analyzed and interpreted data to determine issues.
  • Made recommendations to ensure optimal performance and reliability for mission critical and global enterprise systems which have direct impacts to the company's bottom line and customer perception.
  • Identified opportunities for improvement and provided recommendations to leadership for established procedures and SLAs.
AWS AWS EC2 Data Migration Database Backups Database Upgrades DBA Disaster Recovery MySQL Performance Tuning Data Warehousing SQL SQL Server
Remove Skill
MySQL/ MariaDB Database Administrator
Information Technology
Dec 2012 - Aug 2018
Baltimore, MD
Pharmacy M.D. MySQL/ MariaDB Database Administrator
  • MySQL database administration, installation, configuration and maintenance on Linux and Windows
  • Implementation of MySQL stored procedures, triggers and views.
  • Created a mirror image of production environment for disaster recovery with Route 53 sets, IAM roles, Elastic IP address, EC2 key pairs, Launch Configurations and Security groups.
  • Migrated MySQL database from on premise to AWS Aurora.
  • Configured and Launched MySQL Aurora and restored on premises data.
  • Enabled Amazon Simple Queue to ensure capturing the writes and draining the queue to write to the EOFSTOPTHEINPUTEOF
AWS AWS EC2 DBA Disaster Recovery MySQL Triggers Windows MariaDB
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Software Developer and Security
University of Maryland University College
Certifications
AWS Certified Solutions Architect- Professional
AWS SKILLS
Skills
AWS
2021
8
AWS EC2
2021
8
DBA
2021
8
MySQL
2021
8
MariaDB
2021
7
Disaster Recovery
2019
6
Triggers
2018
5
Windows
2018
5
AWS S3
2021
1
Cloudwatch
2021
1
Continuous Integration
2021
1
Data Replication
2021
1
Database Maintenance
2021
1
Elastic Load Balancer
2021
1
MS Visio
2021
1
Oracle
2021
1
Cloud Infrastructure
0
1
Continuous Deployment
0
1
Data Migration
2019
1
Data Warehousing
2019
1
Database Backups
2019
1
Database Upgrades
2019
1
Devops
0
1
Performance Tuning
2019
1
SQL
2019
1
SQL Server
2019
1