Candidates About

Ayodele Bailey

Oracle Database Administrator

profile

Over 5 years of hands-on experience as an Oracle Database Administrator, having hands on experience in production support, installation, configuration, upgrades, performance tuning, backup and recovery, and database security with Oracle (10g, 11g, 12c) on Sun Solaris, Red Hat Linux, and Windows Platform.

Qualification Summary:

•    Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.

•    Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.

•    Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.

•    Migrating and consolidation of 11g databases into 12c in both QA and Production environments.

•    Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.

•    Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.

•    Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.

•    Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.

•    Experience in the Upgrade of Oracle Databases in patch set Level and also in version  (10g to 11g) and (11g to 12c).

•    Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

•    Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard.

•    Good hands-on experience in High Availability solutions with Oracle 10g, 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams, Golden gate.

•    Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.

•    Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.

•    Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.

•    Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.

•    Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.

•    Excellent skills in generating execution plan using EXPLAIN PLAN and gathering reports using TKPROF for Application Tuning and gathering optimizer statistics for SQL Tuning.

•    Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).

•     Used EXPDP&IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.

EXPERIENCE

Carrier Corporation - East Syracuse, NY

March 2015- Jan 2018

Oracle Database Administrator

Responsibilities:

•      Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g,12c

•      Migration of database from one server to another server.

•      Responsible for setup and implementation of 3 Node RAC on Linux in 10g and 11g R2.

•      Responsible for configuring datagaurd physical and standby database setup for high availability and handling synchronization issues between primary and standby.

•      Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

•      Database Monitoring and troubleshooting of RAC, managing disks and disk groups with ASM, use of Enterprise Manager 12c Cloud/11g Grid Control, Database Control(OEM).

•      Export and Import of database objects to copy from one database to another database with use of Datapump (expdp/impdp) in 10g/11g with new features.

•      Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patch management, DB monitoring, export/imports and SQL loader

•      Daily DBA activities like Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring, User creation and db profiles.

•      Applying quarterly, half-yearly, yearly patches using OPATCH. Also applying different patch sets on the database releases to overcome the bugs. 

•      Administrating and troubleshooting oracle cluster ware /Grid Infrastructure, starting-stopping different services like CRS.

•      Successfully migrated 12c Non CDB databases to pluggable databases

•      Created Oracle Wallets and implemented Tablespace level TDE security

•      Managed Database Maintenance Activities to achieve optimum database uptime

•      Configuration of Listener and Tnsnames

•      Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)

•      Experience in designing and configuring high-availability systems using Data Guard with physical standby effectively configured and used Data Guard Broker utility

•      Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.

•      Involved in database upgrade from 11.1.0.6 to 11.1.0.7 for all the environments in EIC project DEV, TEST, STAGE and PROD environments, upgrade from 11.2.0.1 to 11.2.0.4 for EDMS project for DEV, TEST and PROD environments

•       used Sql server to create databases, install the software.

•      created a maintenance pain to reduce the time it takes me to backup databases.

•      Proficient in Database Design (Physical and Logical Database Design) and Normalization.

Truven

 Health Analytics - Ann Arbor, MI        

July 2012 – Feb 2015

Oracle Database Administrator

Responsibilities:

•      Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.

•      Worked on disaster recovery of Exadata data guard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.

•      Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.

•      Performed troubleshooting of database using AWR and ADDM reports.

•      Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.

•      Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually

•      Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.

•      Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and perl based utility “opatch”.

•      Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

•      Installed Oracle and grid software on standalone servers on ASM and file system.

•      Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

•      Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

•      Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

•      Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Tools Used:   Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Environment:  Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

•    Educational Background:  Bachelors in Computer Science

technical environments

Database:    

Oracle 10g, 11g, 12c

Operating Systems:      

Windows 2008, 2010 RHEL (RedHat Linux), UNIX, Solaris,

Database Languages & Tools: TOAD 9.0.1.8/9.0/8.6.1/7.2, Pl/SQL Developer, SQL*PLUS, SQL* LOADER,VBA,JAVA, SQL Server, Database Links Utilities, RMAN, OAM, OEM, EXP, IMP, expdp, impdp, TOAD, SQL*Loader.