01/23/2023 updated
OF
100 % available
Technology Administrator, Oracle Database Administrator
USA
USA
2008-05 2012-09 Bachelor of Science: Computer Science University of Ibadan - Oyo State - Nigeria.NET FrameworkAmazon Web ServicesServer ApplicationBackup DevicesUnixUbuntu (Operating System)Cloud ComputingDatabasesData TransmissionsDatabase SchemaDatabase SecurityDatabase TuningOracle Data GuardLinuxWeb Development
Net Services, AWS, backups, Cloud, cloud service, data transfer, Database Schema, database security, Database tuning, DATABASE, database systems, databases, Datapump, Disaster Recovery, DNS, fault tolerant, file storage, Computer Science, IaaS, Linux, load balancer, MYSQL database, node, production data, Oracle, oracle applications, Oracle cloud infrastructure, Dataguard, Oracle database, Oracle Database Administration, Oracle 9i, 12c, Oracle DBA, Oracle 10g, 9i, Oracle exadata, sqlloader, PL SQL, PL/Sql, PLSQL, performance monitoring, Performance Tuning, PaaS, RMAN, Sql, server application, Shell Scripting, Shell scripts, software development, Development life cycle, Solaris, subnetting, Ubuntu, Unix operating system, Shell, Web Development
Experience
Professional experience5 - 10 years
Languages
EnglishFluent
Project history
* Upgrade database to Oracle 12c from 9i, 10g, 11g versions. Creating, configuring standalone & RAC
databases
* Installation of oracle applications, Backup and recovery using Oracle's RMAN software; used
offline/online for recovery in a production environment via shell scripting
* Proactive database-level performance tuning, with a good working knowledge of Oracle internals
* Use oracle datapump to import or export logical data of the database
* Oracle sqlloader to oracle from third-party software through Linux, Solaris and Unix operating
system
* Create and manage scripts to schedule backups, alteration of schemas & tablespaces, checking
running processes etc. Creation of schemas and mostly automate tasks as needed
* Use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance
* Diagnose problems and implement standardize solutions at a very fast pace to reduce inactivity
* Collaborate with development to provide support for production environment and other related
activities
* Configure and maintain Oracle active dataguard
* Implementing and maintaining security (create and maintain users, role and assign privileges).
Database tuning, application tuning, performance monitoring
* Administrate Oracle exadata database
* Fine tuning Initialization parameters, I/O, Memory
* Manage appropriate use of free space within tablespaces, reclaim space whenever possible
* Reorganize tables and indexes within databases when needed. Monitoring the production Oracle
alert logs for database errors; system resource availability and respond to system memory and
data issues
* Apply latest releases of patches to resolve few application issues
* Installation, configuration of grid including ASM to provide shared storage to RAC databases
* ASM administration including creating diskgroup, adding, dropping disks
* Installation of RAC and Managing RAC Environment efficiently. Proficient in RAC Performance
Tuning
databases
* Installation of oracle applications, Backup and recovery using Oracle's RMAN software; used
offline/online for recovery in a production environment via shell scripting
* Proactive database-level performance tuning, with a good working knowledge of Oracle internals
* Use oracle datapump to import or export logical data of the database
* Oracle sqlloader to oracle from third-party software through Linux, Solaris and Unix operating
system
* Create and manage scripts to schedule backups, alteration of schemas & tablespaces, checking
running processes etc. Creation of schemas and mostly automate tasks as needed
* Use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance
* Diagnose problems and implement standardize solutions at a very fast pace to reduce inactivity
* Collaborate with development to provide support for production environment and other related
activities
* Configure and maintain Oracle active dataguard
* Implementing and maintaining security (create and maintain users, role and assign privileges).
Database tuning, application tuning, performance monitoring
* Administrate Oracle exadata database
* Fine tuning Initialization parameters, I/O, Memory
* Manage appropriate use of free space within tablespaces, reclaim space whenever possible
* Reorganize tables and indexes within databases when needed. Monitoring the production Oracle
alert logs for database errors; system resource availability and respond to system memory and
data issues
* Apply latest releases of patches to resolve few application issues
* Installation, configuration of grid including ASM to provide shared storage to RAC databases
* ASM administration including creating diskgroup, adding, dropping disks
* Installation of RAC and Managing RAC Environment efficiently. Proficient in RAC Performance
Tuning
* Used oracle datapump to import or export logical data of the database
* Used sqlloader to load external files/data into oracle on Linux, Solaris and Unix operating
system
* Create and manage scripts to schedule backups, alteration of schemas & tablespaces, checking
running processes etc. Creation of schemas and mostly automate tasks as needed
* Diagnosed database problems and implement standardize solutions at a very fast pace to reduce
application downtime
* Collaborate with development to provide support for production environment deployments and other
related activities
* Configured and maintained Oracle active dataguard
* Implemented and maintained security through roles, profiles and resource allocation for
users/profile
* Fine-tuned database Initialization parameters, I/O and Memory consumption for better performance
* Manage appropriate use of free space within tablespaces, reclaim space whenever possible
* Reorganize tables and indexes within databases based on fragmentation level for better
performance. Monitoring the production Oracle alert logs for database errors and system resource
availability.
* Applied latest quarterly patches as per requirement to resolve any known issues
* Installation, configuration of grid including ASM to provide shared storage to RAC databases
* ASM administration including creating diskgroup, adding, dropping disks
* Used sqlloader to load external files/data into oracle on Linux, Solaris and Unix operating
system
* Create and manage scripts to schedule backups, alteration of schemas & tablespaces, checking
running processes etc. Creation of schemas and mostly automate tasks as needed
* Diagnosed database problems and implement standardize solutions at a very fast pace to reduce
application downtime
* Collaborate with development to provide support for production environment deployments and other
related activities
* Configured and maintained Oracle active dataguard
* Implemented and maintained security through roles, profiles and resource allocation for
users/profile
* Fine-tuned database Initialization parameters, I/O and Memory consumption for better performance
* Manage appropriate use of free space within tablespaces, reclaim space whenever possible
* Reorganize tables and indexes within databases based on fragmentation level for better
performance. Monitoring the production Oracle alert logs for database errors and system resource
availability.
* Applied latest quarterly patches as per requirement to resolve any known issues
* Installation, configuration of grid including ASM to provide shared storage to RAC databases
* ASM administration including creating diskgroup, adding, dropping disks