BESONG TIKU

adg4bg@r.postjobfree.com 240-***-****

Overview:

An Oracle Database Administrator with over 8 years of experience which includes Installation, Configuration, Migration, Database Backup & Recovery, data guard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle12c/11g/10g R2 databases and documentation in heterogeneous environments Professional Summary:

• Experience in Oracle database administration in heterogeneous system environment including WINDOWS, HPUX, UNIX and LINUX amongst others.

• Worked as a dedicated team member responsible for monitoring/support of oracle databases performing release upgrades including overall performance tuning/patch management.

• Documented all technical details including operations, maintenance and end user application issues.

• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.

• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle12c, 11gR2 Grid and 10g on ASM and OCSF2 file systems.

• Highly experienced in Oracle 11g, 10g Automatic Storage Management

(ASM) required to fulfill the storage needs.

• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.

• Performed periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.

• Experience with logical backups of the database using Data Pump (Expdp and Impdp)

• Implemented Database security administration by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.

• Performed backups and tested crash recoveries using conventional Hot and Cold backups.

• Experience in working on various OLTP and OLAP databases both in clustered and non-clustered environment.

• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases and Grid Infrastructure.

• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.

• Experience in using transportable tablespace, materialized view, RMAN incremental backup and bitmap indexes in data warehouse environment.

• Experience in Oracle Golden Gate 10.x/11.x/12.x installation, configuration, and troubleshooting Golden Gate issues.

• Zero downtime migration using oracle data pump and Golden Gate between Oracle 10g, 11g and 12c with Linux, Solaris, and Windows platforms.

• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.

• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 12c, 11g and 10g) for the purpose of monitoring multiple databases and application servers.

• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.

• Implementing 10g Data guard with one physical database.

• Experience in configuration and administration of Data Guard

(Physical/Logical standby Databases).

• Setup RMAN solutions for all Oracle Databases -- created Rman repository, provided best practices, optimizations and data guard and cloning techniques

-- restore and recovery.

• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.

• Process/workflow analysis, project management from analysis and design for implementation.

• Conceptual data modeling, logical and physical data modeling.

• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.

• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.

• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Standby Databases, Backup and Recovery procedures.

• Worked closely with the application, development and middleware teams for bug fixes and escalation of critical issues related with WAS.

• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*Loader.

• Worked with team of DBAs in migration of databases from oracle 10g to 11g, 12c.

Technical Skills:

Operating Systems:

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000. RDBMS:

Oracle 10g, 11g, 12c

Languages:

SQL, PL/SQL, Shell Scripting,

Tools:

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client Database Utilities:

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import Work Experience:

Verizon wireless - Ashburn,VA

Oracle Database Administrator Feb 2019 - present

• Work on oracle cloud database as well as On-prem databases.

• Create database on cloud using DBCA-silent mode and 13C OEM.

• Migrate On-prem databases to oracle cloud servers using Data pump,data guard, golden gate and RMAN .

• Build Data guard databases on OCI servers for disaster recovery

• Extensive experience in RMAN recovery testing, RAC and standalone database.

• Create and manage 4 node RAC on oracle cloud servers.

• Experience in setting up Oracle ASM storage for Oracle RAC databases.

• Performed database replication through Golden Gate.

• Performed database refereshes.

• Create a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.

• Performed Query tuning, Instance/Memory tuning by using various performance techniques.

• Build and managed data guard databases in production environment.

• Migrate databases across platforms, on-prem AIX to Linux Exadata cloud OCI using RMAN Incremental xtt method.

• Perform sql tuning on expensive queries using TOAD FOR XPERT and OEM 13C.

• Perform PSU patch quarterly for every Prod and Lower environment.

• Participate in meetings and supporting mid-dba and juniors for task when needed.

• Upgrade databases from 11Gr2 to 19C OCI using pbrun dbutils.

• Install, configure and support uni-directional Oracle-to-Oracle replicated environments utilizing Golden Gate for replication. Upgrade classical extract to integrated extract, patch golden gate for bug fixes and tuning of golden gate processes.

• Perform backup and recovery setup in OCI environment using RMAN and scripts.

• Perform TDE and NDE for maximum data security on tablespaces and network on OCI.

Independence Healthcare – Buffalo, NY

Oracle Database Administrator June 2015 – Dec 2018

• Strong skills in applying security patches (Patch set, Critical Patch Updates

(CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

• Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3/ 11.2.0.4. to 12.2.0.1.

• Setup the new Data guard after creation a new database, and do failover and switch over based on the requirement.

• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate for replication. Upgrade classical extract to intergrated extract, patch golden gate for bug fixes and tuning of golden gate processes.

• Using the Golden Gate Process to masking the sensitive data for reporting.

• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.

• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Troubleshooting and maintenance of RMAN backups and user managed backups.

• Implemented Backup-using RMAN (Recovery Manager) as media management layer

• Planning and scheduling Backups, Database Recovery, taking Logical Backups

(with Exp/Imp) and Data Pump Database backup (Hot & cold)

• Applying the PSU patch every quarterly for every Prod and Lower environment in the database and Yearly on Cluster using Rolling Fashion.

• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

• Used SERVICENOW to open change request for my production databases and JIRA for project work to give status update and to monitor the progress of the projects.

• Utilized Microsoft SQL server database tools and product to manage databases.

• Creating the 12c multitenant cluster database for new application and provide the end to end support to configure the application to connect 12c database.

• Migrating the normal database to exadata server using RMAN duplicate.

• ASM disk expansion in various database cluster nodes.

• 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.

• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRON JOB for Day-to-Day activities and Windows Task Scheduler) RMAN point in time recovery and Instance recovery done on 11g.

• Developed compliance reports and performed auditing at higher levels.

• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

• Applied PSU Patches (12.2.0.1, 11.2.0.3, 11.2.0.4) as a part of maintenance activity.

• Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.

• Conceptual data modeling, logical and physical data design for business operations.

• Extensive experience in RMAN recovery testing, RAC and standalone database Experience in setting up Oracle ASM storage for Oracle RAC databases.

• Performed database replication through Golden Gate.

• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.

• Performed Query tuning, Instance/Memory tuning by using various performance tools Tkprof, Explain Plan, ADDM, AWR etc.

• Planned Backup/Restoration Strategy planned and scheduled Backups, taking Logical Backups with Export/Import utilities RMAN and Data Guard

• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.

• Involved in Installation and configuration of Oracle 12c SGI, 12c RAC--2 node cluster with OCFS2 on Linux/Solaris using ASM storage for testing and development.

• Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 12c, 11gR2 Grid and 10g on ASM and OCSF2 file systems.

• Highly experienced in Oracle 11g, 12c Automatic Storage Management (ASM) required to fulfill the storage needs.

• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c,11g, and 10g RAC servers for the purpose of disaster recovery procedures.

• Supported& maintained the Production/Development databases on various servers

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

• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins

• Used hints for SQL tuning and optimization

• Performed Explain Plan analysis for Query Optimization and SQL tuning Apollo Group Inc – Phoenix, AZ

Oracle Database Administrator May 2012 – June 2015

• Installation, configuration and maintenance of Oracle 10g/11g/12c Real Application Clusters (RAC).

• Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.

• Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.

• Implemented and configured 11g grid control on RHEL.

• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).

• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.

• Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.

• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

• Automated the Data Replication process using Materialized Views for reporting databases.

• Used Oracle Enterprise Manager (OEM) 11gGrid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

• Generated and automated Statspack /AWR reports from Oracle 11g/10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.

• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.

• Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN. Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases.

• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g and 12c for re-organizing Databases/Schemas/Tables to improve the performance.

• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g /12c environments.

• Installed ASM environment and migrated databases from NON-ASM to ASM.

• Used TOAD for database management.

• Made optimal use of Oracle Support in resolving the SRs. 24 X 7 Production & Development database support and administration. Education:

• B.Sc. Degree in Accountancy

Contact this candidate