Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Tosin Ajayi

Hanover,MD

Summary

11+ years of experience in providing 24 7 production support of Oracle Databases, running in diverse environment including Solaris, AIX, HP UX, Linux. Currently working as a Senior Database Administrator at Apprio Inc, managing Databases running on-premises and in cloud. In parallel, leading the teams across the globe to help resolve complex challenges related to DB performance, Dataguard, OEM 13.4 ,SQL Tuning etc. Supported various mission critical production applications in Financial, T and Healthcare environment with expertise in performance tuning and troubleshooting of database issues and driving to solutions and setting up database backup strategies. .Familiar with Database Patching (RU, PSU, Bug Fixes), configuration , Real Application Cluster and implementing best practices. Performance monitoring/tuning/troubleshooting of Databases and services running on AWS. Also 6 months of Exposure in Mongo DB administration.

Overview

12
12
years of professional experience

Work History

AWS Administrator

Apprio
Woodlawan, MD
07.2019 - Current
  • Database size: 25 – 200+ TB | Supporting over 500+ Oracle Databases
  • 7 Production Support Environment, managing 500+ Oracle Databases running on Exadata, and providing ON-Call Support on rotational basis
  • Aligned DBA for Bank’s Tier-1 application
  • Supporting Production Oracle Databases running on Exadata
  • Supporting Database quarterly PSU Patching
  • Performed rolling Grid Infrastructure upgrade from 11.2.0.4 to 12.1.0.2
  • Implement and enforce database security to meet PCI requirements.
  • Migrated development/production Oracle databases to AWS RDS.
  • Implement and enforce database security to meet PCI requirements.
  • Migrated development/production Oracle databases to AWS RDS.
  • Assisted in developing consistent distributed databases by using shading and replication on AWS platform.
  • Achieved HA (High Availability) and FT (Fault Tolerant) for AWS EC2 Instances using AWS Technologies like: EC2, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), VPC, Subnets.
  • Worked with IAM to manage users and groups using IAM by assigning individual policies and roles to each user and group as per requirements.
  • Plan and implement backup, recovery solution using RMAN.
  • Plan and develop contingency solutions for supported databases.
  • Perform ASM Installation, Migration & Configuration as per the requirements.
  • Migration of Non-ASM standalone database to One Node RAC.
  • Migration of Databases to Oracle Exadata machines using datapump import.
  • Creation and setup of physical standby databases and oracle active Dataguard on exadata machines.
  • Designed, implemented SSL/TLS on Oracle databases for network encryption of data; Generated wallet, keystore, and imported certificates into wallets.
  • Manage RAC environment for Day-to-Day Database administrator, performance tuning.
  • Securing stored data using oracle transparent data encryption by installing TDE wallet and creating encrypted tablespaces and storing sensitive data in encrypted tablespaces.
  • Integrating Terraform with AWS
  • Performed database rolling upgrades and PSU patching.
  • Provide support for day-to-day database maintenance activities; planning & scheduling the changes.
  • Enforce and maintain database audit and security standards for PCI standards.
  • Develop and implement high availability, scalability and disaster recovery solutions dataguard, replication, streaming & golden gate as per the application's business needs to meet the required SLAs.
  • Database performance monitoring, tuning to optimize overall response times.
  • Performed online database reorganizations as required to improve database performance.
  • Administer all physical and logical database and storage structures.
  • Reviewing and resolving database backup and OEM alert reports on daily basis.
  • Support for Development, Stage and Production databases hosting business critical applications.

Oracle Database Administrator

CSRA
Columbia, MD
07.2016 - 06.2019
  • Database size: 500G – 5+TB | Supported 300+ Oracle Databases
  • Worked in 24
  • 7 Production Support Environment
  • Managed 300+ Oracle Databases running on Unix and provided ON-Call Support on rotational basis
  • Aligned DBA for Rx Application
  • Supported and managed 5+ DBs (11g 2 Node RAC) including production and development with DB Size Ranges from 500G to 2TB
  • Worked on Multiple DB Performance issues and provided instant solutions/ fixes to application team
  • Supported DB refresh activities using RMAN and EXPDP/IMPDP
  • Installation of Oracle 12cR1 (With Multitenant Architecture i.e., CDB and PDB) Database on Oracle Linux
  • Database Up-gradation of 11.2.0.4.0 to 12cR1
  • Supported Data Warehouse 11g RAC database
  • Administration of Oracle 11gR2 RAC (3 Nodes and 5 Nodes), RAC-1 Node and Oracle Restart databases
  • Installed Oracle 11g/12c DATAGUARD on PROD Environments
  • Worked on Various DB and SQL performance issues
  • Analyzing AWR, ASH and ADDM reports for resolving DB performance issues
  • Administration of Oracle
  • Active Data Guard Standby and Snapshot Databases
  • Restoring a database with available BCV backups
  • Supported Application BCP testing by switching over DBs to DR databases and after testing Switchback to original Primary
  • Creating ASM Diskgroups
  • Adding and Dropping Disks from ASM
  • Re-Org of Tables using EXPDP and IMP DP
  • Monitoring of databases using OEM 12c
  • Applying Quarterly PSU Patches of 11g DBs
  • Applying Bug Fixes patches as per Oracle Support Suggestions
  • Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases
  • Closely Worked with Oracle support in identifying some long-standing issues

Senior Oracle Database Administrator

Idexcel
Herndon, VA
06.2012 - 05.2016
  • Liaison between project manager and other operational DBA as needed
  • Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Automated processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
  • Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
  • Migration of databases across platform
  • Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
  • • Enforced corporate business rules through adequate user/resource/object management.
  • • Reconcile functional and technical problems through interaction with client by researching and identifying defined issue and by fully testing and confirming possible solutions to problem.
  • • Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
  • • Involved in performing upgrades from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
  • • Experience in using Golden Gate to support data replication in Oracle database environment.
  • • Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, databases.
  • • Worked on POC on OEM 12c Cloud, installed in all our non -prod databases, have good knowledge on 12c.
  • • Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS
  • • Experience in Data Migrations using oracle export/import, datapump, sqlldr.
  • • Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
  • • Proficient in using OEM and RMAN.
  • • Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
  • • Designing logical and physical database structure.
  • • Schema design experience using ERwin, expert scripting experience in Perl and all Unix shell scripting variations.
  • • Automated many common tasks using Crontab including Backups, exports and imports, archiving old records and verification of such processes.
  • • Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
  • • Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
  • • Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
  • • Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
  • • Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
  • • Assisting developers with builds to ensure promotion of data integrity and normalization according to standard operating procedure implemented .
  • • Troubleshoot and resolved log gap in Data Guard Configuration
  • • Managing and administering MySQL databases using SQL Server Management Studio

Education

Master of Science - Cybersecurity

University of Maryland - University College
Hyattsville, MD
12.2018

Skills

  • Data Imports
  • Technical Application Support
  • Data Encryption
  • Linux Environments
  • Administering Databases
  • Client Requirements
  • IBM DB2
  • Oracle Enterprise Manager
  • SQL Server Integration Services (SSIS)
  • Database Cloning
  • Ability to perform during stress/ crisis
  • Problem Solving
  • Time management
  • Communication
  • Cultural intelligence & diversity
  • Team work
  • Capacity management
  • Initiative

Accomplishments

  • Expertise in Oracle 19c/18c/12c/11g database administration in high availability 24
  • 7 production environment
  • Experience in Migration and Upgradation of VLDBs
  • (DB Size Range 25 TB to 350 TB)
  • Experience in Upgrading DBs from 11g to 19c/18c Multitenant Architecture (CDB/PDB)
  • Experience in setting up Bidirectional Golden Gate Replication
  • Experience in managing Oracle Data Guard (DG Broker, FSFO)
  • Good Exposure in managing RAC and DR DBs running on Exadata, ODA, STDSTKs and VMs
  • Good Exposure in managing Physical, Active Data Guard and Physical Snapshot standby databases
  • Experience in Analyzing AWR/ASH/ADDM reports for DB Performance issues
  • Good Exposure in handling Data Center Network Isolation Activities
  • Good Exposure in handling Application BCM Activities
  • Experience in Oracle Enterprise Manager 13c, Managing Multi OMS Environment with 20K+ targets
  • Solid experience in Oracle Recovery Manager (RMAN)

Timeline

AWS Administrator

Apprio
07.2019 - Current

Oracle Database Administrator

CSRA
07.2016 - 06.2019

Senior Oracle Database Administrator

Idexcel
06.2012 - 05.2016

Master of Science - Cybersecurity

University of Maryland - University College

Similar Profiles

CREATE PROFILE
Tosin Ajayi