Oracle DBA

Atchala Nangah

Oracle Database Administrator

• 346-***-**** • **********@*******.***

Over 6 years of experience as an Oracle Database Administrator having extensive experience in oracle database installation, administration, configuration, production support, upgrades and patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.

Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD

Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

Wrote scripts to inform DBAs regarding the status, performance, and space management of the database.

Expertise in Installing and configuring ASM and RAC for high availability databases.

Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.

Strong troubleshooting, problem solving, analytical and design skills.

Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.

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

Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Installed and Configured the Oracle Databases (10g/11g) RDBMS, Performing Pre-installation, and Post-Installation Tasks

Experience in cloning Database from Production to Test and Development and from Development to Production.

Have comprehensive knowledge and experience in Creating, Installing, Managing, Upgrading, Patching Oracle RDBMS, Cloning, Backup and Recovery Strategies, Managing Security, Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle DATAGUARD, Performance Monitoring and Tuning, Real Application Clusters (RAC) and Oracle Flashback Technology and documentation.

Extensive knowledge on database administration for Oracle 10g, 11g and 12c with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.

Excellent experience in installation, setup, and configuration of Oracle 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.

Hands on experience in configuring, managing, troubleshooting, and migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments on various flavors of UNIX systems for high availability and load balancing.

Hands on experience in configuring, managing and troubleshooting Oracle RAC (2 and 3 node) databases on various flavors of UNIX systems.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

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

Having experience in ODM (oracle data mining).

Participated in planning and implementation of off-site Disaster-Recovery planning and testing

Worked with development and operations staff in resolving problems quickly and efficiently

Configured and maintained Physical, Logical, Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for disaster recovery procedures

Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user tablespace across Oracle databases.

Good experience in applying Patches, Critical Patch Update(CPU)/Patch Set Update(PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of a Oracle server to higher version available.

Experienced in capacity planning and estimating the growth of Oracle databases

Good exposure in Configuring Single instance, Oracle Real Application Clusters(RAC) and Automatic Storage Management(ASM), Exadata and Golden Gate

Expertise in installing, configuring, and maintaining Standalone and RAC databases.

Create new Oracle databases using DBCA or database scripts. Creating new ASM disk groups or raw devices for RAC DBs.

Excellent interpersonal, analytical and problem-solving skills with customer service oriented attitude.

Identified root causes and provided corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.

Performed manual recovery using archive logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.

Experience in Cloning the Oracle software to a different location and updating the copied bits to work in the new environment.

University of Buea, Cameroon

Bachelors of Science in Computer Science

Oracle Certified Associate

Calpine Corp - Houston, TX Sept 2014 – Present

Oracle Database Administrator

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11).

Performed conversion of Single Node Instance to Multi Node RAC with ASM, and adding instance to existing RAC.

Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.

Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.

Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.

Implemented Data Pump, Export and Import on day to day basis as per development and test servers.

Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices

Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).

Monitoring database performance and database operation to prevent downtime and slowness of the services.

Worked closely with the system operations team on database deployment processes and database capacity planning.

Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.

Identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.

Regular Security Patching and Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.

Production support for Oracle database 11g/12v RAC.

Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints

Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Analyzing schema of databases created to collect statistics using the DBMS STATS package.

Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS.

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.

Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security, and performance

Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1

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

Analyzed SQL queries causing performance problems.

Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities

Troubleshoot installation errors both independently and with Oracle support (via My Oracle Support)

Create oracle databases on configured servers using both the DBCA & Database creation scripts.

Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third-party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

Tools Used: Oracle RMAN, TOAD, SQL Developer, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ASH, ADDM, OEM Grid Control.

Coca Cola - Atlanta, GA Jun 2011 – Aug 2014

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping, or truncating of old portions.

Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.

Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.

Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.

Worked on Standardization of 12c/11g Clusterware build and DB build by preparation response files.

Implemented Oracle Physical Standby Dataguard on multiple oracle 11g / 12c databases.

Configured DG Broker for easy Failover/Switchover during outages and Convert to Snapshot standby during DR test every 6 months.

Troubleshooting and fixing DG Broker configuration.

Troubleshooting and Fixing out of sync Oracle Physical Standby DataGuard using RMAN incremental backup.

Upgrading Oracle databases from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 11.2.0.4.5 and from 11.2.0.X to 12.1.0.1.

Quarterly PSU patching on AIX/RHEL for 11g/12C databases on Standalone and RAC DB's.

Applying/Rolling back one-off patches to/from Standalone or RAC DB's.

Loading data from flat files to database using SQL*Loader, External Tables.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g 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).

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration, and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

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.

Tools Used: RMAN, AWR, ADDM, SQLPlus, SQL*Loader, OEM, Datapump, TOAD 10.x

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 12c/ 11g/ 10g

LANGUAGES: SQL, PL/SQL.

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