Manager Oracle
Resume:
ATEMAFAC FRICE AMINGWA
************@*****.***
PROFILE
An Oracle Database Administrator with over 5 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 Oracle 10g /11g R2/12c databases and documentation in heterogeneous environments. Worked on various Oracle versions like 10g, 11g, 12c Databases across various platforms such as Solaris, AIX, UNIX, Linux, HP and Windows
SKILLS
Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.
Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
Installation, Upgradation, Configuration and Troubleshooting GoldenGate 11g/12c software.
Configured GoldenGate Classic and Integrated components for Active-Passive and Active-Active
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)
Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
Experience in Multitenant Databases (Oracle 12c Container and pluggable databases)
Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc
Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
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.
Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
Expertise in maintaining Database Security using auditing.
Experience in Data Migrations.
Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
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”.
Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
EXPERIENCE
Marriott Vacations Worldwide - Lakeland, FL Mar 2014 – Present
Role: Database Administrator
Environment: Oracle 12c/11g/10g, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.
Responsibilities:
Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5
Experience with large databases (1.5 Tb) for OLTP and OLAP applications.
Administration and supporting of Oracle RAC 11g/12c Databases ranging from 100GB to 6TB.
Installation, upgradation, configuration and troubleshooting GoldenGate 11G/12C software.
Configured GoldenGate components for unidirectional and bidirectional replications and maintain data synchronization.
Monitoring and Performance tuning of GoldenGate sessions at Database level and GGSCI level and investigate replication failures using LogDump utility.
Refreshing development/test database from production using Export/Import & RMAN backups.
Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
Managing database security.
Creating and assigning appropriate roles and privileges to users depending on the user activity.
Installed and configured Oracle (10g&11g R2) databases on Linux 5, HP-Unix 11.X.
Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database (from 10.2.0.3 to 11.2.0.2)
Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.
Defragmentation of tables and indexes for improved performance and effective space management.
Have touch-point calls with offshore team and make sure all issues happens in off business hours are addressed with sense of urgency.
Setup the unidirectional replication on oracle 11g databases using Goldengate.
Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.
Successfully upgraded the databases from 11g to non CDB 12c.
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.
Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces
Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.
Monitored and optimized database performance using Oracle Enterprise Manager (OEM) 11g Grid control.
Performed database backups with RMAN incremental and cumulative backups by registering 10g/11g databases in recovery catalog.
Performed complete and incomplete database recovery, data file and table space point in time (TSPITR) recoveries using RMAN and user managed backups..
Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
SQL query tuning using reports generated by tools like StatsPack, TKPROF and SQL*Trace and Explain Plan
Performed database tuning using Explain plan, Stats Pack, TKPROF, SQL tuning advisor, SQL access advisor, SQL planned management tools and AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH reports and performed database tuning based on the recommendations suggested by ADDM reports.
Experience in working with oracle support in resolving ORA 0600 / ORA-07445 errors and creating SR's.
Expertise in storage management by managing space, table spaces, segments and extents, Rollback segments and data dictionary.
Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
Designed Logical and physical database for business transaction functionality.
Provide production support for the deployed project till it is stabilized.
Written SQL scripts to create database objects like tables, views and sequences.
Created procedures and functions using PL/SQL.
Preparation of High Level & Low Level Design documents.
State Farm - Phoenix, AZ
July 2012 – Feb 2014
Oracle Database Administrator
Responsibilities:
Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
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.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implementing Datapump, conventional export/import utility of Oracle 11g, 10g 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 environments.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
Documented the Standard Processes for peers to follow.
Worked on user management mainly on grants, privileges, roles and profiles.
Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
Involved in query optimization and using rule based optimizers and cost based optimizers.
Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.
Environment: Oracle 10.1.0.4/10.2.0.4/11gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting,, TOAD.
TECHNICAL ENVIRONMENTS
OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP
RDBMS: Oracle 11g/10g
LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting
SOFTWARE/ APPLICATIONS/TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus
TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
Contact this candidate