Resume

Sign in

oracle database administrator

Location:
Gilbert, Arizona, 85234, United States
Posted:
March 13, 2019

Contact this candidate

Resume:

Jane-Bianca Nchanji

SKILL SUMMARY

480-***-****

ac8rt5@r.postjobfree.com

An Oracle Database Administrator (DBA) with 6 years of working experience on Oracle and SQL Server databases installed on same and multiple platforms. I have hands on experience in software installation and configuration, production and project support, backup and recovery, space management, database security, Capacity Planning, performance monitoring and tuning, cloning/refreshes, migration, good documentation and communication skills.

Project:

Golden Gate, for online real time replication of data

Patches and Upgrades

Real Application Cluster (RAC) for high availability and scalability

Data Guard for disaster recovery, high availability, and data protection

PROFESSIONAL EXPERIENCE

June 2016 – Present

SUN PRODUCTS CORPERATION.

SALT LAKE CITY, UT. (Oracle DBA)

Installation and configuration of Oracle 10g,11g and 12c in UNIX/LINUX (RHEL).

Installation and configuration of 12c Container Databases on standalone servers and cluster on Unix platforms.

Used Logdump utility in Golden Gate environment and Installed Golden Gate in test, prod environment while managing trail files by purging old extract files and log files.

Experienced in rewriting SQL queries, understanding of views, stored procedures, triggers and optimization.

Worked on Oracle 12c New Features such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c Databases.

Supported in Performing Golden Gate configuration, administration, installation, also configuring pumps.

Replication Using Golden Gate for multiple extracts and replication and mapping, Great understanding and usage of advanced parameters in Golden Gate.

Expertise in Active DataGuard, using Dataguard Broker (DGMGRL) and Enterprise Manager. Implemented Active Data guard, creating both Logical (for testing) and Physical Standby databases in 11g RAC & 12c environment for the Production databases.

Generated AWR, ADDM, Explain Plan, TKPROF, SQLTRACE, reports for Performance tuning. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

Hands on experience in cloning and upgrading 11g non-container databases to 12c pluggable databases using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup and Communication vault.

Created Oracle Wallets and implemented Tablespace level TDE security.

Experience in upgrading the 11g management agents to 12c agents.

Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, and Crontab.

Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups.

Experienced with ASM, adding, deleting disks to the disk group.

Experienced in creating and managing users and privileges in a Multitenant Environment.

Hands on experience in patching and upgrading a multitenant container database.

October 2012 - May 2016

BARCLAYS – DALLAS, TX (Oracle DBA)

24 X 7 Production & Development database support and administration.

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

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

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

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.

Utilized Rman recover table functionality and created proof of concepts for our pre-prod environment.

Installed, Configured and Manage Oracle 11G Goldengate for Uni-Directional Replication. Troubleshooting and performance tuning Golden Gate replications, monitoring scripts for Golden Gate in Unix scripting.

Experience with Change Board Meetings and Change Control Management for all database changes.

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

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

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

Configured 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, for faster recovery of the databases and database objects.

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

Applying RDBMS quarterly patches for Improved security and functionality of the databases.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC with ASM file system.

Involved in converting single instance databases to RAC databases.

Creating and Scheduling Oracle Backend Process Jobs using UNIX crontab.

Configure SQL Server monitoring utilities for failed replication or failed lock synchronization.

TECHNICAL SKILLS

Tools: OEM (Oracle Enterprise Manager), Sql Developer, Toad, Winscp

RDBMS: Oracle 10g,11g and 12c

Database Utilities: TKPROF, Explain Plan, Stacspack, Sql Plus, AWR and ADDM, Slq Loader RMAN, Datapump (impdp/expdp)

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Operating System: AIX, Sun Solaris, Linux, Window.

EDUCATION AND CERTIFICATE

Bachelor’s Degree in Computer Science (Power Point) and Environmental Management

Structure Query Language Certified (12c Sql Fundamental)

OCA 12c Certified.



Contact this candidate