Iheanyi Chukukere

adyo5c@r.postjobfree.com ***- ***-7759

Profile

I have 10 years total experience with Database Administrator which includes 4 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.

EDUCATION

University of Maryland University College, Adelphi, MD

Bachelor of Science, Software Developer and Security

SKILLS SUMMARY

SECURITY: Vulnerability scan OWASP zap 2.7.0, Visual Code Grepper (VCG), E-Authentication, Identify and Access Management, Risk Management Framework, DMZ installation, IDS/IPS installation and update, Firewalls installation and update, Disaster Recovery plan, Elevates access approval.

AWS: EC2, RDS, S3, Glacier, SQS, SNS, SES, CloudFormation, VPC, IAM, Route53, EBS, DynamoDB, Lambda, Kinesis, CloudWatch, Cloud9.

CERTIFICATIONS

AWS Certified Solutions Architect- Professional.

AWS SKILLS

Cloud computing on the AWS: Taking full advantage of AWS Availability Zones (AZ) and regions to design highly available and fault-tolerant architecture in the cloud.

Launching EC2 instances and using Auto Scaling to automatically scale in/out based on demand and schedule, and load balancing with the classic ELB and ALB.

Launching fully managed No-SQL database like DynamoDB, RDS Database Instance in multi-AZ for automatic failover and creating read replicas and cross region read replicas.

Creating billing alerts, using Trusted Advisor to access VPC performance and suggest improvements, monitoring EC2 metrics using CloudWatch, and user logs and API calls using CloudTrail.

User management using IAM and adhering to AWS and Security best practices; enabling MFA authentication, assigning permission to groups, and creating roles.

Database migration using the Database Migration Service, and VM migration using VM import/Export, encrypting instance and migrating data to it.

Storing data on S3 and using lifecycle management to move old and infrequently Accessed data to Glacier.

DNS service, regional load balancing and failover with Route 53, data caching with ElastiCache, web content caching with CloudFront and automatic cloud infrastructure launch and updates with CloudFormation.

Launching and Securing VPC, VPC peering, Route tables, Target group, Static and Elastic IPs etc.

DATABASE SKILLS

Database Administration, Development, Design, Maintenance, Production support of relational databases, MySQL Database server installation, upgrade and migration

Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities

MySQL Backup and Recovery using tools like Mydumper, MySQL enterprise backup and Percona Xtrabackup, Innobackupex Proficient

Installed, upgrade, optimize, troubleshoot, and perform root cause analysis on MySQL server versions from 5.5 to 5.7 distributions

Import/Export, Database optimization with the help of explain plan.

Database Migration from MyISAM format to InnoDB Proficient

MySQL Master Slave Replication configuration and Slave server configuration

Good analytical, problem-solving skills, verbal and written communication skills

Areas of Technical Knowledge

•Database: MySQL 5.5/5.6/5.7. & 8.0

•Operating Systems: Ubuntu, Linux, Unix.

•Programming Languages: SQL, Shell, Python, Terraform.

•Database Tools: QL Loader, Mysqldump/mysqlimport, Percona Tool kit Xtrabackup, Innobackupex, Mydumper.

•Monitoring Tools: MySQL enterprise, DPA 7, Monyog, PMM

•Client/ Server Communication Tool: ODBC, JDBC, Putty etc.

EXPERIENCE

Walt Disney Parks and Resorts Technology Orland, FL 03/2019 – Present

Cloud Data Engineer/ DBA

Provisioning and configuring new RDS instance of MariaDB, MySQL, Aurora MySQL and DynamoDB using Terraform from latest environment to production.

Installed Postgres 12 from scratch using docker and Implemented logging for monitoring in Postgres.

Setup user change password assigning roles in Postgres database Restore and recovery of Postgres.

Provisioned Postgres Aurora in Dev, Stage and Prod.

Troubleshoot and tuned PostgreSQL in Aurora and created materialized views.

Recovery of database when main database corruption occurs using point in time recovery in Postgres

Database migrations from Oracle to MySQL, and MariaDB to PostgreSQL.

Troubleshoot and performed PostgreSQL performance tuning.

Develop architectures to migrate data and entire databases heterogeneously.

Performance tuning and recommendations to existing database deployments

Upgrading RDS instance with Terraform.

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.

Creating VPCs, Route Tables, Private and Public Subnets, NAT Gateways, Security Groups etc.

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.

Experience working with Redis Clusters from provisioning to upgrade and configuration.

Working with developers and application to ensure their change deployment is successful

Develop scripts to automate the deployment of resource stacks and associated configurations

Utilize native Azure services to meet the firm’s technology and resiliency requirements.

Drive Identity and access and configuration management, and monitoring strategy for Azure

Lead design process for network connectivity to Azure.

Establish and implement monitoring and management infrastructure for both availability and performance management.

Configure PCI and PII CloudWatch general log to drain to kinesis then splunk.

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

Develop scripts to automate the deployment of resource stacks and associated configurations

Utilize native Azure services to meet the firm's technology and resiliency requirements.

Drive Identity and access and configuration management, and monitoring strategy for Azure.

Lead design process for network connectivity to Azure.

Establish and implement monitoring and management infrastructure for both availability and performance management.

Provisioned Azure RDS database using terraform.

Worked extensively with terraform to create MySQL and MariaDB databases, wrote all modules including main.tf and variables.tf

Worked extensively to resolve terraform issue such as resource locking.

Worked extensively on chef, create cookbooks to install MySQL, Oracle from scratch using pet-workspaces.

Attaching ec2 nodes to chef-client, resolving issues regarding to node runlist.

Experience in create EFS disk using terraform and attaching ec2 instances.

Worked extensively in Encrypting EBS storage, creating snapshot, add and drop volumes.

Worked with S3 buckets for storing database backups.

Orange Theory Fitness, Boca Raton, F.L. 08/2018- 03/2019

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.

Rite Aid Pharmacy, Baltimore, M.D. 12/2012- 08/2018

MySQL/ MariaDB Database Administrator

MySQL database administration, installation, configuration and maintenance on Linux and Windows

Implementation of MySQL stored procedures, triggers and views mainly for CMS databases.

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.

Configure MySQL Datapine reporting tool.

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

Database.

Performed MySQL Replication setup and administration on Master-Slave and Master-Master

Experience using Percona tools for better support to perform variety of MySQL system tasks and Capacity Planning

Responsible for troubleshooting and problem solving of MySQL database

Worked with development teams for database related changes and requests

Partitioned tables to improve query performance & Dockers.

Performed SQL tuning using EXPLAIN plan, tuning configuration parameters for optimal database performance

MySQL database Upgrade from version 5.0/5.1 to 5.5/5.6/5.7

Setup, troubleshoot, fix backups and restore data using tools such as Mysqldump, Percona Xtrabackup and Innobackupex

Performed disaster recovery analysis and testing on MySQL databases to comply with business requirements

Designed database structures, created indexes, views and partitioned tables for optimal performance

Enabled binary logging on MySQL Servers.

Altered database structures and schemas as needed and Resolved deadlock issues mainly on InnoDB tables.

Changed password for users, killed sessions and granted privileges

Participated in On-call rotation every few weeks.

Contact this candidate