Oladapo Jegede

Lawrenceville, Georgia, *****

ad1m04@r.postjobfree.com

+1-917-***-****

PROFESSIONAL SUMMARY

Motivated and experienced Database Engineer with 7+ years of IT experience and 4+ years in Cloud environment, Dedicated and highly skilled Oracle and PostgreSQL Database Administrator with extensive experience in supporting Oracle on EC2 and Postgres RDS in AWS. Seeking a challenging role that leverages my Oracle and PostgreSQL expertise, AWS cloud proficiency, and DevOps skills to optimize database performance, migration, and infrastructure. Skilled in supporting, automating, and optimizing critical deployments in AWS, Strong knowledge of AWS infrastructure. Proficient in Infrastructure as Code using Terraform, CloudFormation, using Git as code source. Technological Skills

Database Management: Installation, Configuration, Creation, and Cluster Administration of PostgreSQL; Expertise in Tablespaces and Schema Objects.

Data Management: Backup and Recovery strategies, including Transaction Log Backups and Point-in-time Recovery.

Performance Enhancement: Proficient in SQL Query Optimization for improved database performance. Security and Compliance: Specialized in Data Encryption (SSL/TLS, GSSAPI), Compliance Standards, and Network Security,

Operating Systems: Proficient in Linux, with extensive troubleshooting skills and technical documentation. Scripting & Automation: Skilled in Python, Bash, SQL scripting, Terraform, JSON, YAML, and Automated Testing.

Cloud Infrastructure: Hands-on experience in AWS (EC2, IAM, CloudWatch, ELB, and EBS) with a focus on high-availability architecture.

DevOps & Methodologies: Agile Practices: Familiarity with Agile Methodologies, including Jira, fostering a collaborative environment.

Continuous Integration & Delivery: Expertise in CI/CD, Version Control (Git/GitHub), Automation Frameworks (Ansible, Jenkins), and Containerization (Docker, Kubernetes). Infrastructure & Deployment

Service Orchestration: Application Deployment, Monitoring, and Alerting using Prometheus, Grafana. Infrastructure Optimization: Configuration Management, Incident and Change Management, Cloud-native Development.

Bachelor’s Degree (Urban and Regional Planning)

Licenses & Certifications

AWS Certified Solutions Architect – Associate - Amazon Web Services (AWS) PROFESSIONAL EXPERIENCE

Education

Volusion, TX.

CLOUD DATABASE ENGINEER (REMOTE) April 2021 - present

• Install, configure, and maintain Oracle and PostgreSQL database instances on various platforms.

• Create and manage database clusters, tablespaces, data files, and schema objects.

• Perform regular database backups and implement recovery strategies.

• Analyze and fine-tune SQL queries for optimal performance.

• Monitor and optimize database performance, identifying and resolving bottlenecks.

• Implement and manage high availability solutions, such as Oracle Data Guard, Oracle Real Application Clusters (RAC), PostgreSQL Streaming Replication, and Logical Replication.

• Plan and execute disaster recovery procedures to minimize downtime.

• Manage database security, including user access controls, role-based privileges, and data encryption.

• Ensure compliance with industry standards and regulations related to data security also Plan and execute database patching, version upgrades, and apply critical security patches as needed.

• Migrate data and schema structures during version upgrades.

• Perform capacity planning to ensure scalability and efficient resource allocation.

• Collaborate with development teams to optimize database design and query performance.

• Implement Infrastructure as Code (IaC) principles using Terraform for database infrastructure provisioning.

• Implement and maintain data replication and synchronization mechanisms to support distributed environments. Created and maintained technology infrastructure, automation tools, and configuration management systems.

• Setup and build and also troubleshoot AWS infrastructure various resources, VPC EC2, S3, IAM, EBS, Security Group, Auto Scaling and RDS following best practices.

• Apply Auto Scaling and Elastic Load Balancer to create a high availability and fault tolerance application.

• Deploy Instance scheduler to save over 70% cost on our test servers.

• Launch and configure RDS instances and DynamoDB tables for application, Perform full AMI backups for all production instances with critical workloads.

• Implemented identity and access management solutions using AWS Organization and IAM.

• Designed and deployed scalable and fault-tolerant resources in AWS, leveraging AWS CLI and CloudFormation templates.

• Implemented security best practices in AWS, including MFA, encryption, and network security measures.

• Demonstrated expertise in IaaS using Ansible and experience with enterprise scheduling tools.

• Hands-on experience with Amazon MGN (Application Migration Service) and Groovy scripting language.

Wolters Kluwer, MD.

AWS CLOUD DATABASE ENGINEER January 2019 - March 2021

• Collaborated with clients to analyze their workflows, identifying opportunities for technological enhancements and process efficiencies.

• Designed and deployed scalable, highly available, fault-tolerant, and reliable resources in AWS, leveraging hands-on experience with AWS CLI, CloudFormation, S3, EC2, and IAM.

• Led aspects of migration journeys, leveraging tools such as CART, ADS, Migration Evaluator, DMS, and CloudEndure to assess, mobilize, and migrate workloads.

• Implemented AWS best practices for security, including access key rotation, multi-factor authentication

(MFA), role-based permissions, and the configuration of security groups, NACLs, and S3 bucket policies.

• Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.

• Maintaining custom vacuum strategies at table and database level.

• Configured BART for Incremental backups, implement retention policies and point-in-time recovery requirements for large-scale Postgres deployments.

• Designed and implemented table partitioning for handling very large tables.

• Performance improvements leveraging on EXPLAIN and EXPLAIN ANALYZE to identify and fine- tune SQL queries, also Optimize postgresql.conf for performance improvement.

• Ensure night Crontab jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.

• Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.

• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.

• Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing

• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.

• Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking.

• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.

Brontech Solutions, MD.

ORACLE DATABASE ADMINISTRATOR (REMOTE) January 2017 - December 2018

• Performed database administration tasks such as creating and managing database instances, tablespaces, data files, and schema objects.

• Implemented backup and recovery strategies, including regular full and incremental backups, as well as database point-in-time recovery.

• Monitored and optimized database performance, analyzing performance metrics, identifying bottlenecks, and implementing tuning techniques.

• Implemented database security measures, including user access controls, role-based privileges, and data encryption.

• Planned and executed database maintenance tasks, such as patching, upgrading, and applying critical security patches.

• Troubleshot and resolved database issues, investigating and resolving errors, performance issues, and data corruption problems.

• Implemented and maintained high availability solutions, such as Oracle Data Guard and Oracle Real Application Clusters (RAC), ensuring continuous database availability.

• Conducted capacity planning and resource utilization analysis to ensure scalability and efficient resource allocation.

• Designed and implemented database backup and recovery strategies, ensuring data integrity and minimizing downtime.

• Collaborated with development teams to optimize database design, schema structures, and SQL query performance.

• Implemented and maintained database replication and data synchronization mechanisms to support distributed environments.

• Implemented database auditing and compliance controls to meet regulatory requirements.

• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

• Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

• Experienced in configuration of ASM for RAC and NON- RAC environments.

• Experienced in Data Center migration of databases to prepare the proof of concept, DB migration procedures and scripts, developed templates that include check list for migrating the databases.

• Perform Database upgrades, migrations; take logical exports from the QA, DEV etc instances and importing the data on to the production systems etc.

• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.

• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.

• Expertise in PL/SQL, SQL, and UNIX Shell Scripting (Implemented UNIX Scripts using CRON JOB for Day-to-Day activities and Windows Task Scheduler).

• Extensively worked on setting up auditing in many databases we supported

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

• Monitored and managed installed systems to ensure optimal availability and performance.

• Built resilient and efficient 3-tier architecture for customer applications, following AWS best practices and conducting architecture and infrastructure reviews.

• Leveraged Terraform to provide and manage AWS infrastructures, ensuring consistency and efficiency.

• Optimized cost by utilizing reserved instances, selecting appropriate EC2 instance types, implementing S3 storage class and lifecycle policies, and leveraging autoscaling capabilities.

Contact this candidate